如何在PDO PHP中查看查询错误 [英] How to view query error in PDO PHP

问题描述

try {
    $db = new PDO("mysql:host=".HOST.";dbname=".DB, USER, PW);
    $st = $db->prepare("SELECT * FROM c6ode");
}
catch (PDOException $e){
    echo $e->getMessage();
}

在上述情况下，如何检查查询的mysql错误?

How can I check the mysql error for the query in above case?

推荐答案

您需要将错误模式属性PDO :: ATTR_ERRMODE设置为PDO :: ERRMODE_EXCEPTION.
并且由于您期望prepare()方法会引发异常，因此应该禁用PDO :: ATTR_EMULATE_PREPARES * feature .否则，MySQL服务器在执行之前不会看到"该语句.

You need to set the error mode attribute PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION.
And since you expect the exception to be thrown by the prepare() method you should disable the PDO::ATTR_EMULATE_PREPARES* feature. Otherwise the MySQL server doesn't "see" the statement until it's executed.

<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);


    $pdo->prepare('INSERT INTO DoesNotExist (x) VALUES (?)');
}
catch(Exception $e) {
    echo 'Exception -> ';
    var_dump($e->getMessage());
}

打印(以我为例)

Exception -> string(91) "SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'test.doesnotexist' doesn't exist"

请参见 http://wezfurlong.org/blog/2006/apr/using-pdo-mysql/
EMULATE_PREPARES = true似乎现在是pdo_mysql驱动程序的默认设置. 从那时起，查询缓存的问题已得到修复/更改，并且使用mysqlnd驱动程序，我对EMULATE_PREPARES = false没问题(尽管我只是php爱好者，但请不要相信我的话...)

see http://wezfurlong.org/blog/2006/apr/using-pdo-mysql/
EMULATE_PREPARES=true seems to be the default setting for the pdo_mysql driver right now. The query cache thing has been fixed/change since then and with the mysqlnd driver I hadn't problems with EMULATE_PREPARES=false (though I'm only a php hobbyist, don't take my word on it...)

*)，然后有

*) and then there's PDO::MYSQL_ATTR_DIRECT_QUERY - I must admit that I don't understand the interaction of those two attributes (yet?), so I set them both, like

$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'localonly', 'localonly', array(
    PDO::ATTR_EMULATE_PREPARES=>false,
    PDO::MYSQL_ATTR_DIRECT_QUERY=>false,
    PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION
));

这篇关于如何在PDO PHP中查看查询错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！