Work-around for PHP5’s PDO rowCount MySQL issue

by

You can issue a SELECT FOUND_ROWS() query right after the original SELECT query to get row count.

$pdo->query("SELECT * FROM users");
$foundRows = $pdo->query("SELECT FOUND_ROWS()")->fetchColumn();

See also: MySQL Docs on FOUND_ROWS()

More Related Contents:

  1. mysqli or PDO – what are the pros and cons? [closed]
  2. What is the difference between bindParam and bindValue?
  3. How do I create a PDO parameterized query with a LIKE statement?
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. PHP PDO: charset, set names?
  6. How to get numeric types from MySQL using PDO?
  7. PDO prepared statement – what are colons in parameter names used for?
  8. php pdo: get the columns name of a table
  9. Use bound parameter multiple times
  10. What is the difference between MySQL, MySQLi and PDO? [closed]
  11. Why is PDO better for escaping MySQL queries/querystrings than mysql_real_escape_string?
  12. PDO bindParam vs. execute
  13. how safe are PDO prepared statements
  14. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  15. PDO error message? [duplicate]
  16. PHP PDO – Num Rows
  17. php pdo prepare repetitive variables
  18. How to solve General error: 2006 MySQL server has gone away
  19. Replacing mysql_* functions with PDO and prepared statements
  20. How to make PDO run SET NAMES utf8 each time I connect, In ZendFramework
  21. How do I sanitize input with PDO?
  22. Calling stored procedure with Out parameter using PDO
  23. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  24. Setting a connect timeout with PDO
  25. What is the best way to insert multiple rows in PHP PDO MYSQL?
  26. PDO MySQL: Insert multiple rows in one query
  27. How to bind LIKE values using the PDO extension?
  28. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  29. PDO LIMIT and OFFSET [duplicate]
  30. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]

Leave a Comment