Strange PHP PDO MySQL Error

[DriedSponge]

I created a function that checks if a user exist in my data base:

function UserExist($gid)
{
    $query = SQLWrapper()->prepare("SELECT ID FROM Users WHERE gid = ?");
    $query->execute([$gid]);
    $info =  $query->fetch();
    if(empty($info)) {
        return false;
    } else {
        return true;
    }
}

But it gives me this error:

Uncaught Error: Call to a member function fetch() on bool

Any ideas as to why?

[Eigenvektor]

What language (PHP, I assume) and/or library is this? I would assume

$query->execute([$gid]);

to return some form of result object, so you'd have to use that to fetch your results? Similar to this:

$statement = $db->prepare('SELECT * FROM comments WHERE blogpostid = ? ORDER BY created ASC');
$exec = $statement->execute([$_GET['blogpostid']]);
$rows = $statement->fetchAll(\PDO::FETCH_ASSOC);

The error implies that "$query" is a boolean value, which is why you can't call "fetch" on it.

[MCDELTAT]

What he said. Look at the PHP docs, both the prepare() and the execute() functions regularly return Boolean values. So I would just log your values for both of those executions, and you'll figure out which one is returning a value you weren't expecting.

https://www.php.net/manual/en/pdo.prepare.php

https://www.php.net/manual/en/pdostatement.execute.php

[DriedSponge]

8 hours ago, Eigenvektor said:

What language (PHP, I assume) and/or library is this? I would assume

$query->execute([$gid]);

to return some form of result object, so you'd have to use that to fetch your results? Similar to this:

$statement = $db->prepare('SELECT * FROM comments WHERE blogpostid = ? ORDER BY created ASC');
$exec = $statement->execute([$_GET['blogpostid']]);
$rows = $statement->fetchAll(\PDO::FETCH_ASSOC);

The error implies that "$query" is a boolean value, which is why you can't call "fetch" on it.

I echoed out the value and it's not a boolean, for some reason it's equal to 11.

[DriedSponge]

Ok I got it to work by doing  fetchAll(\PDO::FETCH_ASSOC) but I'm still confused on why I have to do that. I have written many SQL SELECT queries before just like the one in my original post and they've worked perfectly fine.