PHP MySQLi bind_result null?

Question

I'm writing a class, but I stucked in a function. It requests the email address by username, but it's only returning null.

Code:

private function getUserEmail($username){
    if($stmt = $this->_mysqli->prepare("SELECT email FROM users WHERE username='?'")){
        $stmt->bind_param("s", $username);
        $stmt->execute();
        $stmt->bind_result($email);
        $stmt->fetch();
        var_dump($email);
        $stmt->close();
        return $email;
    }
}

Did you check if the query is actually executing? Actually returning any data? Your code is simply assuming success throughout. — Marc B
– Marc B, Commented Aug 16, 2013 at 19:39
I checked if $stmt->fetch returns error, but it returns null, so I think the problem is somwhere there. — TMS
– TMS, Commented Aug 16, 2013 at 19:49
getting null from the ->fetch() call means that there's no data at all (or you've fetched all available data already): php.net/manual/en/mysqli-stmt.fetch.php. Do a echo $stmt->num_rows() right after the ->execute() call. If you get 0, then you've just got no data at all. — Marc B
– Marc B, Commented Aug 16, 2013 at 19:52

Jaak Kütt · Accepted Answer · 2013-08-16 20:40:00Z

1

Try removing the single quotations around the ?

if($stmt = $this->_mysqli->prepare("SELECT email FROM users WHERE username=?")){

Otherwise it won't recognize the ? as a placeholder.

See documentation on syntax here: "The ? characters should not be enclosed within quotation marks, even if you intend to bind them to string values."

edited Aug 16, 2013 at 20:40

answered Aug 16, 2013 at 20:33

Jaak Kütt

2,6864 gold badges35 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TMS Over a year ago

Wow, thanks for the help. I removed the quations, and now the code is working.

Collectives™ on Stack Overflow

PHP MySQLi bind_result null?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related