| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
PDOStatement::errorInfo |
API reference for the PDOStatement::errorInfo function in the Microsoft PDO_SQLSRV Driver for PHP for SQL Server. |
David-Engel |
davidengel |
01/29/2021 |
sql |
connectivity |
reference |
[!INCLUDEDriver_PHP_Download]
Retrieves extended error information of the most recent operation on the statement handle.
array PDOStatement::errorInfo();
An array of error information about the most recent operation on the statement 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.
Support for PDO was added in version 2.0 of the [!INCLUDEssDriverPHP].
In this example, the SQL statement has an error, which is then reported.
<?php
$conn = new PDO( "sqlsrv:server=(local) ; Database = AdventureWorks", "", "");
$stmt = $conn->prepare('SELECT * FROM Person.Addressx');
$stmt->execute();
print_r ($stmt->errorInfo());
?> When an exception occurs, the ODBC Driver may return more than one error to help diagnose problems. However, PDOStatement::errorInfo always shows only the first error. In response to this bug report, PDO::errorInfo and PDOStatement::errorInfo have been updated to indicate that drivers should display at least the following three fields:
0 SQLSTATE error code (a five characters alphanumeric identifier defined in the ANSI SQL standard).
1 Driver specific error code.
2 Driver specific error message.
Starting with 5.9.0, the default behavior of PDOStatement::errorInfo is to show additional ODBC errors, if they are available. See PDO::errorInfo for more details.