| title | PDOStatement::errorInfo |
|---|---|
| description | API reference for the PDOStatement::errorInfo function in the Microsoft PDO_SQLSRV Driver for PHP for SQL Server. |
| ms.custom | |
| ms.date | 08/10/2020 |
| ms.prod | sql |
| ms.prod_service | connectivity |
| ms.reviewer | |
| ms.technology | connectivity |
| ms.topic | conceptual |
| ms.assetid | e45bebe8-ea4c-49b6-93db-cf1ae65f530c |
| author | David-Engel |
| ms.author | v-daenge |
[!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());
?>