PDOStatement::errorCode

Microsoft Drivers for PHP for SQL Server

Collapse image Expand Image Copy image CopyHover image

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

Syntax

string PDOStatement::errorCode();

Return Value

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

Remarks

Support for PDO was added in version 2.0 of the Microsoft Drivers for PHP for SQL Server.

Example

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

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

$stmt->execute();
print $stmt->errorCode();
?>

See Also

Reference

Other Resources

PDO