|
|
| Microsoft Drivers for PHP for SQL Server version 2.0 and 3.0 |
| PDOStatement::errorCode |
| Example See Also Send Feedback |
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 Code
|
|
|---|---|
<?php
$conn = new PDO( "sqlsrv:server=(local) ; Database = AdventureWorks", "", "");
$stmt = $conn->prepare('SELECT * FROM Person.Addressx');
$stmt->execute();
print $stmt->errorCode();
?>
|
|
