Export (0) Print
Expand All

PDO::errorInfo

SQL Server 2008 R2

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 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());
?>

Reference

Other Resources

PDO

Community Additions

ADD
Show:
© 2015 Microsoft