| title | PDO::errorInfo | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 01/19/2017 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.technology | connectivity |
| ms.topic | conceptual |
| ms.assetid | 9d5481d5-13bc-4388-b3aa-78676c0fc709 |
| author | David-Engel |
| ms.author | v-daenge |
[!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, then the driver-specific fields are 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());
?>