how to get the count of row values in php pdo

Question

There are many conflicting statements around, what is the best way to row count using PDO in PHP? Before using PDO I just simply used mysql_num_rows.

fetchAll is something I won't want as I may sometimes be dealing with large datasets, so not good for my use.

Any suggestions?

http://php.net/manual/en/pdostatement.rowcount.php – JustAnotherSimpleProgrammer__ Apr 26 '15 at 13:58 — JustAnotherSimpleProgrammer__, Apr 26 '15 at 13:58
Did you manage to get an answer to this – chapskev Apr 27 '15 at 23:59 — chapskev, Apr 27 '15 at 23:59

score 3 · Accepted Answer · edited May 23 '17 at 11:51

In Mysql $stmt->rowCount(); doesnt work. Try this

$nRows = $pdo->query('select count(*) from yourTable')->fetchColumn(); 
echo 'Number of rows is = '. $nRows;

Here is an excerpt from a comment and answer regarding the same. Check it out its very resourceful.

mysql_num_rows() worked is because it was internally fetching all the rows to give you that information, even if it didn't seem like it to you. Refer to this anwere

So in PDO, your options are:

Use MySQL's FOUND_ROWS() function.
Use PDO's fetch_all() function to fetch all the rows into an array, then use count() on it.
Do an extra query to SELECT COUNT(*),

https://stackoverflow.com/a/883523/2536812

score 0 · Answer 2 · answered Apr 26 '15 at 14:02

0

Directly out form PHP Manual about PDO Statements

$stmt->rowCount();

The $stmtvalue is for exemple the return of a prepare :

$stmt = $pdo->prepare('MY PREPARED SQL QUERY');

answered Apr 26 '15 at 14:02

Bobot

1,118
8
19

how to get the count of row values in php pdo

2 Answers2