PDO::errorInfo
(PHP 5 >= 5.1.0, PHP 7, PHP 8, PECL pdo >= 0.1.0)
PDO::errorInfo —
Fetch extended error information associated with the last operation on the database handle
Descrizione
public PDO::errorInfo():
array
Elenco dei parametri
Questa funzione non contiene parametri.
Valori restituiti
PDO::errorInfo() returns an array of error information
about the last operation performed by this database handle. The array
consists of at least the following fields:
Nota:
If the SQLSTATE error code is not set or there is no driver-specific
error, the elements following element 0 will be set to null
.
PDO::errorInfo() only retrieves error information for
operations performed directly on the database handle. If you create a
PDOStatement object through PDO::prepare() or
PDO::query() and invoke an error on the statement
handle, PDO::errorInfo() will not reflect the error
from the statement handle. You must call
PDOStatement::errorInfo() to return the error
information for an operation performed on a particular statement handle.
Esempi
Example #1 Displaying errorInfo() fields for a PDO_ODBC connection to a DB2 database
<?php
/* Provoke an error -- bogus SQL syntax */
$stmt = $dbh->prepare('bogus sql');
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($dbh->errorInfo());
}
?>
Il precedente esempio visualizzerà:
PDO::errorInfo():
Array
(
[0] => HY000
[1] => 1
[2] => near "bogus": syntax error
)