downloads | documentation | faq | getting help | mailing lists | licenses | wiki | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

PDOStatement->errorInfo()> <PDOStatement->columnCount()
Last updated: Wed, 22 Jul 2009

view this page in

PDOStatement->errorCode()

(PHP 5 >= 5.1.0, PECL pdo:0.1-1.0.3)

PDOStatement->errorCode() — Fetch the SQLSTATE associated with the last operation on the statement handle

Description

PDOStatement
string errorCode ( void )

Return Values

Identical to PDO->errorCode(), except that PDOStatement->errorCode() only retrieves error codes for operations performed with PDOStatement objects.

Examples

Example#1 Retrieving a SQLSTATE code

<?php
/* Provoke an error -- the BONES table does not exist */
$err $dbh->prepare('SELECT skull FROM bones');
$err->execute();

echo 
"\nPDOStatement::errorCode(): ";
print 
$err->errorCode();
?>

The above example will output:

PDOStatement::errorCode(): 42S02



add a note add a note User Contributed Notes
PDOStatement->errorCode()
There are no user contributed notes for this page.

PDOStatement->errorInfo()> <PDOStatement->columnCount()
Last updated: Wed, 22 Jul 2009
 
 
show source | credits | stats | sitemap | contact | advertising | mirror sites