How to view query error 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
try {
    $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 (?)');
}
catch(Exception $e) {
    echo 'Exception -> ';
    var_dump($e->getMessage());
}

prints (in my case)

Exception -> string(91) "SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'test.doesnotexist' doesn't exist"

see http://wezfurlong.org/blog/2006/apr/using-pdo-mysql/
EMULATE_PREPARES=true seems to be the default setting for the pdo_mysql driver right now.
The query cache thing has been fixed/change since then and with the mysqlnd driver I hadn’t problems with EMULATE_PREPARES=false (though I’m only a php hobbyist, don’t take my word on it…)

*) and then there’s PDO::MYSQL_ATTR_DIRECT_QUERY – I must admit that I don’t understand the interaction of those two attributes (yet?), so I set them both, like

$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly', array(
    PDO::ATTR_EMULATE_PREPARES=>false,
    PDO::MYSQL_ATTR_DIRECT_QUERY=>false,
    PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION
));

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. PDOException “could not find driver”
  5. Getting raw SQL query string from PDO prepared statements
  6. How do I set ORDER BY params using prepared PDO statement?
  7. “Invalid parameter number: parameter was not defined” Inserting data
  8. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  9. Insert/update helper function using PDO
  10. PDO with INSERT INTO through prepared statements [closed]
  11. PDO::fetchAll vs. PDO::fetch in a loop
  12. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  13. Resetting array pointer in PDO results
  14. Real escape string and PDO [duplicate]
  15. PDO multiple queries
  16. PHP PDO vs normal mysql_connect
  17. Can I create a database using PDO in PHP?
  18. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  19. PDO::PARAM for type decimal?
  20. PHP PDO and MySQLi [duplicate]
  21. PDO fetch one column from table into 1-dimensional array
  22. Update query with PDO and MySQL
  23. Is “SET CHARACTER SET utf8” necessary?
  24. Getting a PHP PDO connection from a mysql_connect()?
  25. Having issue with matching rows in the database
  26. Set PDO to throw exceptions by default [duplicate]
  27. PDO: MySQL server has gone away
  28. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  29. PHP/SQL Insert Error when using Named Placeholders
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment