PHP PDO – Num Rows

by

According to the manual, there is a PDOStatement->rowCount method ; but it shouldn’t be used (quoting) :

For most databases,
PDOStatement::rowCount() does not
return the number of rows affected by
a SELECT statement.
Instead, use
PDO::query() to issue a SELECT COUNT(*) statement with the same
predicates as your intended SELECT
statement, then use
PDOStatement::fetchColumn() to
retrieve the number of rows that will
be returned.
Your application can then
perform the correct action.

If you already have a recordset, and want to know how many lines are in it, you’ll have to fetch the data, using one of the fetch* methods ; and use count — like you suggested.

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. Insert form in MySQL with PDO [duplicate]
  4. PHP – Using PDO with IN clause array
  5. How to properly set up a PDO connection
  6. PHP PDO prepared statements
  7. Getting raw SQL query string from PDO prepared statements
  8. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  9. “Invalid parameter number: parameter was not defined” Inserting data
  10. PDO binding values for MySQL IN statement [duplicate]
  11. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  12. PDO mysql: How to know if insert was successful
  13. mysql PDO how to bind LIKE
  14. implement LIKE query in PDO
  15. PHP PDO prepared statement — MySQL LIKE query
  16. Fetching single row, single column with PDO
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. PDO Connection Test
  19. How do I loop through a MySQL query via PDO in PHP?
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Use of PDO in classes [duplicate]
  24. How to handle PDO exceptions [duplicate]
  25. Check if row exists in the database before inserting
  26. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  27. PDO and MySQL Fulltext searches
  28. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. What is the PDO equivalent of function mysql_real_escape_string?

Leave a Comment