初始化PDO对象后,尝试将错误模式设置得更高。
我有以下代码片段:
error_reporting(E_ALL);
$hostname = "localhost";
$username = "user";
$password = "password";
try {
$db = new PDO("mysql:host=$hostname;dbname=DBNAME", $username, $password);
echo "connected...<br/>n";flush();
$sql = "SELECT COLA, COLB FROM TABLEA LIMIT 10";
echo "query:$sql--<br/>n";flush();
$stmt = $dbh->query($sql);
echo "statement:<pre>";print_r($stmt);echo "</pre>nfetching...<br/>n";flush();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
if ($result === true) {
echo "result is true<br/>n";flush();
}
else if ($result === false) {
echo "result is false<br/>n";flush();
}
else {
echo "what?<br/>n";flush();
}
foreach ($result as $key=>$val) {
echo "key:$key - val:$val--<br/>n";flush();
}
echo "done";
$dbh = null;
}
catch (Exception $e) {
die ($e->getMessage());
}
正如你所看到的,我有一堆调试echo语句,但我看到的只有:
connected...
query:SELECT COLA, COLB FROM TABLEA LIMIT 10
我本来希望看到我的语句对象以及我的结果被显示,我是不是遗漏了什么?
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
默认值为PDO::ERRMODE_SILENT
,不会输出任何警告/错误。使用此默认设置,您必须轮询errorInfo()
才能查看错误详细信息。