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
– Ahmed Ginani

2017-09-11 12:48:50 +00:00
Commented Sep 11, 2017 at 12:48 — Ahmed Ginani
– Ahmed Ginani, Commented Sep 11, 2017 at 12:48
@AhmedGinani I am getting no error .Its just blank.

Herry Potei
– Herry Potei

2017-09-11 12:50:05 +00:00
Commented Sep 11, 2017 at 12:50 — Herry Potei
– Herry Potei, Commented Sep 11, 2017 at 12:50
$smt->execute(); missing

Ahmed Ginani
– Ahmed Ginani

2017-09-11 12:52:38 +00:00
Commented Sep 11, 2017 at 12:52 — Ahmed Ginani
– Ahmed Ginani, Commented Sep 11, 2017 at 12:52

David Courtey · Accepted Answer · 2017-09-11 12:59:52Z

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, 2017 at 12:59

answered Sep 11, 2017 at 12:50

David Courtey

1395 bronze badges

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

3 Comments

Herry Potei Over a year ago

Oh wait its giving me this error now: Fatal error: Uncaught Error: Call to a member function fetchColumn() on boolean

David Courtey Over a year ago

I edit my code, execute() is alone now. Try this new

Herry Potei Over a year ago

Okay looks like return doesnt print the value, echo does. It works. Thank you.

Ahmed Ginani · Accepted Answer · 2017-09-11 13:22:55Z

0

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

$smt->execute();

answered Sep 11, 2017 at 13:22

Ahmed Ginani

6,6452 gold badges17 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP : not able to return sql count value

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related