PDO Fatal error: Call to a member function fetchColumn() on a non-object

Question

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();

[How to squeeze error message out of PDO?](http://stackoverflow.com/q/3726505) — Pekka, Jan 20 '12 at 21:38
possible duplicate of [Error in my PDO fetch column function](http://stackoverflow.com/questions/4407413/error-in-my-pdo-fetch-column-function) — outis, Jan 21 '12 at 18:58

score 1 · Accepted Answer · answered Jan 20 '12 at 21:41

1

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();

answered Jan 20 '12 at 21:41

FtDRbwLXw6

27,774
13
70
107

bool PDOStatement::execute ([ array $input_parameters ] ) it doesn't return mixed value, only boolean value. – WojtekT Jan 20 '12 at 21:43
(trying to make a note on this)So the $dbh is an database object $q is a statement object which, once executed, has the resultset hung on it? – mcktimo Jan 20 '12 at 22:03

WojtekT · Answer 2 · 2012-01-20T22:07:28.227

0

$q->execute(...)

Returns only boolean value. Proper way:

$q = $dbh->prepare($sql);

if ($q->execute($repo, $list, $email) == TRUE) {
 $v = $q->fetchColumn();
} else {
 //error
}

edited Jan 20 '12 at 22:07

answered Jan 20 '12 at 21:40

WojtekT

4,735
25
37

PDO Fatal error: Call to a member function fetchColumn() on a non-object

2 Answers2

Linked