How to get a query error from prepare() in PDO PHP?

by

You need to set the error mode attribute PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION.

And since you expect the exception to be thrown by the prepare() method, you should disable the PDO::ATTR_EMULATE_PREPARES feature. Otherwise the MySQL server doesn’t “see” the statement until it’s executed.

<?php
$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$pdo->prepare('INSERT INTO DoesNotExist (x) VALUES (?)');

prints (or logs, depends on the PHP settings)

SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'test.doesnotexist' doesn't exist

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. 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. PHP: mysql v mysqli v pdo [closed]
  30. PDO and MySQL ‘between’

Leave a Comment