How to view query error in PDO PHP

Question

try        db   new PDO  mysql host   HOST   dbname   DB  USER  PW        st    db- gt prepare  SELECT   FROM c6ode      catch  PDOException  e       echo  e- gt getMessage        How can I check the mysql error for the query in above case

User · Answer

I m guessing that your complaint is that the exception is not firing  PDO is most likely configured to not throw exceptions  Enable them with this    db- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION

User · Answer

a quick way to see your errors whilst testing    error   st- gt errorInfo    echo  error 2

User · Answer

I m using this without any additional settings   if    st- gt execute          print r  st- gt errorInfo

User · Answer

Provoke an error -- the BONES table does not exist      sth    dbh- gt prepare  SELECT skull FROM bones     sth- gt execute     echo   nPDOStatement  errorInfo    n    arr    sth- gt errorInfo    print r  arr     output  Array        0    gt  42S02      1    gt  -204      2    gt   IBM  CLI Driver  DB2 LINUX  SQL0204N   DANIELS BONES  is an undefined name   SQLSTATE 42704

User · Answer

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    lt  php try        pdo   new PDO  mysql host localhost dbname test charset utf8    localonly    localonly         pdo- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION        pdo- gt setAttribute PDO  ATTR EMULATE PREPARES  false          pdo- gt prepare  INSERT INTO DoesNotExist  x  VALUES          catch Exception  e        echo  Exception - gt         var dump  e- gt getMessage         prints  in my case   Exception - gt  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  gt false      PDO  MYSQL ATTR DIRECT QUERY  gt false      PDO  ATTR ERRMODE  gt PDO  ERRMODE EXCEPTION

[php] How to view query error in PDO PHP

Examples related to php

Examples related to mysql

Examples related to pdo