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

search for in the

PDOStatement->errorInfo()> <PDOStatement->columnCount()
Last updated: Sun, 25 Nov 2007

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: Sun, 25 Nov 2007
 
 
show source | credits | sitemap | contact | advertising | mirror sites