[!INCLUDEDriver_PHP_Download]

Retrieves extended error information of the most recent operation on the database handle.

  
array PDO::errorInfo();  

An array of error information about the most recent operation on the database handle. The array consists of the following fields:

• The SQLSTATE error code.

• The driver-specific error code.

• The driver-specific error message.

If there is no error, or if the SQLSTATE is not set, the driver-specific fields will be NULL.

PDO::errorInfo only retrieves error information for operations performed directly on the database. Use PDOStatement::errorInfo when a PDOStatement instance is created using PDO::prepare or PDO::query.

Support for PDO was added in version 2.0 of the [!INCLUDEssDriverPHP].

In this example, the name of the column is misspelled (Cityx instead of City), causing an error, which is then reported.

<?php  
$conn = new PDO( "sqlsrv:server=(local) ; Database = AdventureWorks ", "");  
$query = "SELECT * FROM Person.Address where Cityx = 'Essen'";  
  
$conn->query($query);  
print $conn->errorCode();  
echo "\n";  
print_r ($conn->errorInfo());  
?>  

PDO Class
PDO