YouTip

# PDOStatement::errorInfo [PHP PDO Reference](#) PDOStatement::errorInfo — Get extended error information associated with the last statement handle operation (PHP 5 >= 5.1.0, PECL pdo >= 0.1.0) * * * ## Description ### Syntax array PDOStatement::errorInfo ( void ) PDOStatement::errorInfo() returns an array of error information about the last statement handle execution operation. This array contains the following fields: | Element | Information | | --- | --- | | 0 | SQLSTATE error code (a five-character alphanumeric identifier defined in the ANSI SQL standard). | | 1 | Driver-specific error code. | | 2 | Driver-specific error message. | * * * ## Example ### Display the fields of errorInfo() for a PDO_ODBC connection to a DB2 database prepare('SELECT skull FROM bones'); $sth->execute(); echo "nPDOStatement::errorInfo():n"; $arr = $sth->errorInfo(); print_r($arr);?>

 PDOStatement::errorCode(): 42S02
The above example will output:

PDOStatement::errorInfo():Array(  => 42S02  => -204  => [DB2/LINUX] SQL0204N "DANIELS.BONES" is an undefined name. SQLSTATE=42704)

* * PHP PDO Reference](#)