Retrieves extended error information of the most recent operation on the database handle.
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 Microsoft Drivers for PHP for SQL Server.
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()); ?>