How to get row count with PDO with PHP?

Spread the love

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

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

How to get row count with PDO with PHP?

To get row count with PDO with PHP, we can run a select count query.

For instance, we write

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

to run the $sql query that selects the count from the table table.

The $sql string is converted to a prepared statement with prepare.

We run the query with execute.

We then get the value from $result->fetchColumn().

Conclusion

To get row count with PDO with PHP, we can run a select count query.

Leave a Reply

Your email address will not be published.