PDOStatement->columnCount
Statement's errorCode() returns an empty string before execution, and '00000' (five zeros) after a sucessfull execution:
<?php
$stmt = $pdo->prepare($query);
assert($stmt->errorCode === '');
$stmt->execute();
assert($stmt->errorCode === '00000');
?>
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
string PDOStatement::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
User Contributed NotesPDOStatement->errorCode
vaclav dot sir at gmail dot com
05-Jun-2006 06:59
05-Jun-2006 06:59