为什么未捕获PDO异常错误? [英] Why PDO Exception Error Not Caught?
问题描述
我有一个PHP脚本,在SQL查询的语句中有两个故意的拼写错误:
I have a PHP script with two deliberate typo mistakes in the statement for an SQL query:
try
{
$stmt = $dbh->prepare("SELECT COUNT(*) FROM Product WHERE non-existent_column=?");
$stmt->blindValue(1, $id, PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetchColumn();
}
catch(PDOException $err)
{
var_dump($err->getMessage());
var_dump($dbh->errorInfo());
}
但是,即使将属性设置为PDO::ERRMODE_EXCEPTION
,该脚本也不会捕获错误.我在这里想念什么?
However, the script does not catch the error even after setting attribute to PDO::ERRMODE_EXCEPTION
. What am I missing here?
更新:
这是完整的脚本.第二个错字blindValue
已恢复.错误仍然存在:
This is the full script. The second typo blindValue
has been reverted back. The error remains uncaught:
<?php
$user= "user";
$password = "password";
$dsn = "mysql:dbname=Catalogue;host=localhost";
$dbh = new PDO($dsn, $user, $password);
$dbh->setAttribute(PDO::ERRMODE_EXCEPTION);
$id = 1000;
try
{
$stmt = $dbh->prepare("SELECT COUNT(*) FROM Product WHERE non-existent_column=?");
$stmt->bindValue(1, $id, PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetchColumn();
}
catch(PDOException $err)
{
echo "caught";
var_dump($err->getMessage());
var_dump($dbh->errorInfo());
exit();
}
var_dump($stmt);
var_dump($row);
echo "uncaught";
exit();
?>
推荐答案
您对setAttribute()的调用缺少第一个参数:
Your call to setAttribute() lacks the first parameter:
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
如果您没有获得
Warning: PDO::setAttribute() expects exactly 2 parameters, 1 given
您的错误报告级别太低开发服务器和/或您没有关注 display_errors = On (您更喜欢哪个;我更喜欢错误日志而不是display_errors).
your error_reporting level is too low for a development server and/or you didn't keep an eye on the error log or didn't set display_errors=On (which ever you prefer; I prefer the error log over display_errors).
请尝试
<?php
echo 'php version: ', phpversion(), "\n";
try {
$dbh = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly');
echo 'client version: ', $dbh->getAttribute(PDO::ATTR_CLIENT_VERSION), "\n";
echo 'server version: ', $dbh->getAttribute(PDO::ATTR_SERVER_VERSION), "\n";
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}
catch(PDOException $err) {
var_dump($err->getMessage());
die('...');
}
$id = 'foo';
try
{
$stmt = $dbh->prepare("SELECT COUNT(*) FROM Product WHERE `non-existent_column`=?");
$stmt->bindValue(1, $id, PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetchColumn();
}
catch(PDOException $err)
{
var_dump($err->getMessage());
var_dump($dbh->errorInfo());
die('....');
}
echo 'done.';
在我的机器上打印
php version: 5.3.5
client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $
server version: 5.5.8
string(94) "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'non-existent_column' in 'where clause'"
array(3) {
[0]=>
string(5) "42S22"
[1]=>
int(1054)
[2]=>
string(54) "Unknown column 'non-existent_column' in 'where clause'"
}
....
这篇关于为什么未捕获PDO异常错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!