Checking for an empty result (PHP, PDO, and MySQL) [duplicate]

by

You’re throwing away a result row when you do $sth->fetchColumn(). That’s not how you check if there are any results. You do

if ($sth->rowCount() > 0) {
  ... got results ...
} else {
   echo 'nothing';
}

Relevant documentation is here: PDOStatement::rowCount

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. PHP – Using PDO with IN clause array
  4. How to properly set up a PDO connection
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. PDO binding values for MySQL IN statement [duplicate]
  8. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  9. PDO mysql: How to know if insert was successful
  10. mysql PDO how to bind LIKE
  11. implement LIKE query in PDO
  12. PHP PDO prepared statement — MySQL LIKE query
  13. Fetching single row, single column with PDO
  14. How to install pdo driver in php docker image?
  15. How do I loop through a MySQL query via PDO in PHP?
  16. MySQL retrieve variable from Stored Procedure in PHP PDO
  17. Understanding pdo mysql transactions
  18. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  19. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  20. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  21. Error while using PDO prepared statements and LIMIT in query [duplicate]
  22. PDO prepared statement fetch() returning double results
  23. How to handle PDO exceptions [duplicate]
  24. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  25. PDO::rowCount VS COUNT(*)
  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. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment