Fetching single row, single column with PDO

by

Are you sure it’s returning any rows? 

$stmt->fetchColumn()

is correct way to fetch a single value, so either you probably didn’t bind the :user parameter or it simply returned no rows.

More Related Contents:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDO get the last ID inserted
  3. PDO mysql: How to know if insert was successful
  4. MySQL check if a table exists without throwing an exception
  5. Replacing mysql_* functions with PDO and prepared statements
  6. PDO::PARAM for type decimal?
  7. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  8. PHP PDO and Mysql [closed]
  9. Using PHP data in MySQL [closed]
  10. PHP – Using PDO with IN clause array
  11. How to properly set up a PDO connection
  12. PHP PDO prepared statements
  13. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  14. strange character encoding of stored data , old script is showing them fine new one doesn’t
  15. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  16. mysql PDO how to bind LIKE
  17. How to loop through a mysql result set
  18. PHP PDO prepared statement — MySQL LIKE query
  19. How to get the total number of rows of a GROUP BY query?
  20. How to connect to mssql using pdo through PHP and Linux?
  21. How do I loop through a MySQL query via PDO in PHP?
  22. IP address storing in MySQL database using PHP [duplicate]
  23. PDO error: SQLSTATE[HY000]: General error: 2031
  24. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  25. How to handle PDO exceptions [duplicate]
  26. Check if row exists in the database before inserting
  27. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  28. PDO and MySQL Fulltext searches
  29. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  30. Is a BLOB converted using the current/default charset in MySQL?

Leave a Comment