Please i need only a small assistance, i do not understand why my select statement does not work, i can login even with invalid login credentials. i hashed my password on the registration page .
$Query = "SELECT *password FROM users WHERE username = ?";
$statement = $conn->prepare($Query);
$statement->bindValue(':username', $username);
$statement->execute();
$user = $statement->fetch(PDO::FETCH_ASSOC);
$RowCount = $statement->rowCount();
} catch (PDOerrorInfo $e){
die('QuerySCD Error '.$e->getMessage());
}
this is the code i used to hash my password
$password =password_hash($_POST['password'], PASSWORD_DEFAULT);
What I have tried:
code altercation, i checked tutorials