rowCount

[cabbie]

$count prints out 0  it is retrieving correct username and password from database.  Ideas?

 

<?php
include_once ('connection.php');


class User{
        private $db;
        public function __construct(){        
            $this->db = new Connection();
            $this->db = $this->db->dbConnect();
        }
    
        public function Login($username, $password)
        {
            if(!empty($username) && !empty($password)){
                $st = $this->db->prepare("select * from users where username=? and password=?");
                $st->bindParam(1, $username);
                $st->bindParam(2, $password);
                $st->execute();
 
                    $count = $st->rowCount(); Print $count;  echo $username, ' ', $password;
                if($st->rowCount() == 1){
                    echo "User verified. Access granted";
                }else{
                    echo "Incorrect username or password";
                }                
            }else{
                echo "Please enter username and password";
            }
        }
}
?>        
            

[Psycho]

Per the manual: http://php.net/manual/en/pdostatement.rowcount.php

 

PDOStatement::rowCount() returns the number of rows affected by the last DELETE, INSERT, or UPDATE statement executed by the corresponding PDOStatement object.

 

If the last SQL statement executed by the associated PDOStatement was a SELECT statement, some databases may return the number of rows returned by that statement. However, this behaviour is not guaranteed for all databases and should not be relied on for portable applications.

[Hall of Famer]

Well at least for MySQL database, PDOStatement::rowCount() seems to work just fine. I wonder what OP's database driver is though.

[cabbie]

What is an alternative to check if a user exists during log in?

[Jessica]

Check what user id was returned, or use the database engines COUNT function