PDO->errorInfo()

Fetch extended error information associated with the last operation on the database handle ()

Example 1759. Displaying errorInfo() fields for a PDO_ODBC connection to a DB2 database

copy to clipboard

<?php
/* Provoke an error -- bogus SQL syntax */
$stmt = $dbh->prepare('bogus sql');

if (!$stmt) {

    echo "\nPDO::errorInfo():\n";

    print_r($dbh->errorInfo());

}
?>

The above example will output:

copy to clipboard

PDO::errorInfo():

Array

(

    [0] => HY000

    [1] => 1

    [2] => near "bogus": syntax error

)

Code Examples / Notes » pdo_errorinfo

quickshiftin

here is a reference to the ansi error codes there are several others; a link to the official spec from ansi would be nice (have to rebuild this link because its too long to post w/o breaking it up) http://download-east.oracle.com/docs/ cd/B14117_01/appdev.101/a87540/ch2.htm ~quickshiftin`

Change Language

PDO->beginTransaction()
PDO->commit()
PDO->__construct()
PDO->errorCode()
PDO->errorInfo()
PDO->exec()
PDO->getAttribute()
PDO->getAvailableDrivers()
PDO->lastInsertId()
PDO->prepare()
PDO->query()
PDO->quote()
PDO->rollBack()
PDO->setAttribute()
PDOStatement->bindColumn()
PDOStatement->bindParam()
PDOStatement->bindValue()
PDOStatement->closeCursor()
PDOStatement->columnCount()
PDOStatement->errorCode()
PDOStatement->errorInfo()
PDOStatement->execute()
PDOStatement->fetch()
PDOStatement->fetchAll()
PDOStatement->fetchColumn()
PDOStatement->fetchObject()
PDOStatement->getAttribute()
PDOStatement->getColumnMeta()
PDOStatement->nextRowset()
PDOStatement->rowCount()
PDOStatement->setAttribute()
PDOStatement->setFetchMode()