PDOStatement::errorInfo

(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)

PDOStatement::errorInfo — 锟斤拷取锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟截碉拷锟斤拷展锟斤拷锟斤拷锟斤拷息

说锟斤拷

PDOStatement::errorInfo ( void ) : array

锟斤拷锟斤拷值

PDOStatement::errorInfo() 锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟街达拷胁锟斤拷锟斤拷拇锟斤拷锟斤拷锟较拷锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷侄危锟�

Element Information
0 SQLSTATE 锟斤拷锟斤拷锟诫（一锟斤拷锟斤拷5锟斤拷锟斤拷母锟斤拷锟斤拷锟斤拷锟斤拷傻锟斤拷锟� ANSI SQL 锟斤拷准锟叫讹拷锟斤拷谋锟绞讹拷锟斤拷锟斤拷锟�
1 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟诫。
2 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷

锟斤拷锟斤拷

Example #1 锟斤拷示锟斤拷锟接碉拷DB2锟斤拷锟捷匡拷锟� PDO_ODBC 锟斤拷锟接碉拷 errorInfo() 锟斤拷锟街讹拷

<?php
/* 锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷 --  BONES 锟斤拷锟捷憋拷锟斤拷锟斤拷 */
$sth = $dbh->prepare('SELECT skull FROM bones');
$sth->execute();

echo "\nPDOStatement::errorInfo():\n";
$arr = $sth->errorInfo();
print_r($arr);
?>

锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�

PDOStatement::errorInfo():
Array
(
    [0] => 42S02
    [1] => -204
    [2] => [IBM][CLI Driver][DB2/LINUX] SQL0204N  "DANIELS.BONES" is an undefined name.  SQLSTATE=42704
)

锟轿硷拷

  • PDO::errorCode() - 锟斤拷取锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷一锟轿诧拷锟斤拷锟斤拷氐锟� SQLSTATE
  • PDO::errorInfo() - Fetch extended error information associated with the last operation on the database handle
  • PDOStatement::errorCode() - 锟斤拷取锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟截碉拷 SQLSTATE