PHP : not able to return sql count value

Question

I am a newbie in PHP programming. Here is my code :

class AdminActions extends DBManager{
    public function loginUser($username, $password){
        $dbh = $this->getConnection();
        $smt = $dbh->prepare("SELECT count(1) FROM admin WHERE admin_name=:username AND admin_password=:password"); 
        $smt->bindValue(':username', $username);
        $smt->bindValue(':password', $password);
        $count = $smt->fetchColumn();
        return $count;
    }
}

I am not able to return the value of $count. There is no error to be displayed (no output). I would like to have answers containing the function fetchColumn() . Thank you in advance.

what is the error are you getting ? – Ahmed Ginani Sep 11 '17 at 12:48 — Ahmed Ginani, Sep 11 '17 at 12:48
@AhmedGinani I am getting no error .Its just blank. – Herry Potei Sep 11 '17 at 12:50 — Herry Potei, Sep 11 '17 at 12:50
$smt->execute(); missing – Ahmed Ginani Sep 11 '17 at 12:52 — Ahmed Ginani, Sep 11 '17 at 12:52

David Courtey · Accepted Answer · 2017-09-11T12:59:52.983

2

You forget to exec the request and to select what column you wanna count. Try :

class AdminActions extends DBManager{
public function loginUser($username, $password){
    $dbh = $this->getConnection();
    $smt = $dbh->prepare("SELECT count(id) FROM admin WHERE admin_name=:username AND admin_password=:password"); 
    $smt->bindValue(':username', $username);
    $smt->bindValue(':password', $password);
    $smt->execute();
    return $smt->fetchColumn();
}

From : Row count with PDO

edited Sep 11 '17 at 12:59

answered Sep 11 '17 at 12:50

David Courtey

139
5

Oh wait its giving me this error now: `Fatal error: Uncaught Error: Call to a member function fetchColumn() on boolean` – Herry Potei Sep 11 '17 at 12:57
I edit my code, execute() is alone now. Try this new – David Courtey Sep 11 '17 at 13:00
1

Okay looks like return doesnt print the value, echo does. It works. Thank you. – Herry Potei Sep 11 '17 at 13:06

score 0 · Answer 2 · answered Sep 11 '17 at 13:22

0

As per document you have to execute pdo statement. you have to execute your query.

$smt->execute();

answered Sep 11 '17 at 13:22

Ahmed Ginani

6,522
2
15
33

PHP : not able to return sql count value

2 Answers2