PHP 手册
后退前进


PDOStatement::errorCode

(no version information, might be only in CVS)

PDOStatement::errorCode --  Fetch the SQLSTATE associated with the last operation on the statement handle

说明

int PDOStatement::errorCode ( void )

返回值

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

范例

例子 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();
?>

上例将输出：

PDOStatement::errorCode(): 42S02

参见

PDO::errorCode()
PDO::errorInfo()
PDOStatement::errorInfo()


add a note add a note User Contributed Notes
vaclav dot sir at gmail dot com
05-Jun-2006 11:59
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');
?>
add a note add a note


后退起点前进
PDOStatement::columnCount上一级PDOStatement::errorInfo