How to get row count with PDO and PHP?

Spread the love

Sometimes, we want to get row count with PDO and PHP.

In this article, we’ll look at how to get row count with PDO and PHP.

How to get row count with PDO and PHP?

To get row count with PDO and PHP, we run a select count statement and then use the fetchColumn method.

For instance, we write

$sql = "SELECT count(*) FROM `table` WHERE foo = ?"; 
$result = $con->prepare($sql); 
$result->execute([$bar]); 
$number_of_rows = $result->fetchColumn(); 

to call prepare with the $sql string.

Then we call execute with the parameters for the prepared statement in an array.

And then we call fetchCoulmn to get the value of count returned by the SQL statement.

Conclusion

To get row count with PDO and PHP, we run a select count statement and then use the fetchColumn method.

Leave a Reply

Your email address will not be published. Required fields are marked *