PDO致命错误:在非对象上调用成员函数fetchColumn() [英] PDO Fatal error: Call to a member function fetchColumn() on a non-object

问题描述

尝试转到PDO无法找出问题所在

Trying to move to PDO can't figure out what is wrong with this

$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);  
$sql = "SELECT COUNT(*) FROM users WHERE repo=? AND list=? AND email=?";
$q=$dbh->prepare($sql);
$res = $q->execute(array($repo, $list, $email));
$v = $res->fetchColumn();

推荐答案

PDOStatement::execute()返回TRUE或FALSE(请参见

PDOStatement::execute() returns either TRUE or FALSE (see here), so $res is being set to a boolean and then you're trying to call a method on it. Try this instead:

$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);  
$sql = "SELECT COUNT(*) FROM users WHERE repo=? AND list=? AND email=?";
$q=$dbh->prepare($sql);
if (($res = $q->execute(array($repo, $list, $email))) === FALSE) {
    echo 'Query failed!';
    exit;
}
$v = $q->fetchColumn();

这篇关于PDO致命错误:在非对象上调用成员函数fetchColumn()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！