Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Counting results with PDO

DZone's Guide to

Counting results with PDO

· Web Dev Zone ·
Free Resource

Access over 20 APIs and mobile SDKs, up to 250k transactions free with no credit card required

Many developers asked me how I count the result rows from a PDO statement.
I asked them how they do it.

They answered me the following example of www.php.net:

 

<?php
$sql = "SELECT COUNT(*) FROM fruit WHERE calories > 100";
if ($res = $conn->query($sql)) {

/* Check the number of rows that match the SELECT statement */
if ($res->fetchColumn() > 0) {

/* Issue the real SELECT statement and work with the results */
$sql = "SELECT name FROM fruit WHERE calories > 100";
foreach ($conn->query($sql) as $row) {
print "Name: " . $row['NAME'] . "\n";
}
}
/* No rows matched -- do something else */
else {
print "No rows matched the query.";
}
}

$res = null;
$conn = null;
?>

 

In some projects who I deployed recently I used the following code to count the rows:
 
<?php 
$sQuery = "SELECT * FROM table";

$rResult = $pdo->query($sQuery)->fetchAll();
echo count($rResult);
?>
 
 
Maybe you can use this simple lines of code yourself. Good luck with it.

 

#1 for location developers in quality, price and choice, switch to HERE.

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}