[!INCLUDEDriver_PHP_Download]

Retrieves the SQLSTATE of the most recent operation on the database statement object.

  
string PDOStatement::errorCode();  

Returns a five-char SQLSTATE as a string, or NULL if there was no operation on the statement handle.

Support for PDO was added in version 2.0 of the [!INCLUDEssDriverPHP].

This example shows a SQL query that has an error. The error code is then displayed.

<?php  
$conn = new PDO( "sqlsrv:server=(local) ; Database = AdventureWorks", "", "");  
$stmt = $conn->prepare('SELECT * FROM Person.Addressx');  
  
$stmt->execute();  
print $stmt->errorCode();  
?>  

PDOStatement Class

PDO