mySQL SELECT PDOStatement->rowCount

Question

I am just wondering what the definitive answer to this question is. The PHP PDO documentation warns that PDOStatement->rowCount cannot be relied up to return the number of rows "affected" with a SELECT statement. And yet I find that this continues to work perefectly with mySQL + PHP version after version. Perhaps there is an issue when using another DB but if I don't ever want to migrate to another DB should I really care?

score 1 · Accepted Answer · edited May 23 '17 at 10:24

1

Yes, you should still care about the usage of that method. It's not just the database, but PHP itself can be a problem.

If you want to play it safe, it's better if you just issue a SELECT COUNT(*) instead.

edited May 23 '17 at 10:24

Community

1
1

answered Sep 26 '12 at 14:49

Kemal Fadillah

9,660
3
44
62

Thank you! SELECT COUNT it is then! – DroidOS Sep 27 '12 at 03:06
I'm not sure running a query twice and assuming the same results were returned each time is safe exactly. – Sep 05 '13 at 10:45

mySQL SELECT PDOStatement->rowCount

1 Answers1