I'm doing a simple login here via SQLite, but when I hit the "Enter" button, it says " Login Failed ") everything is correct in the form;
$sqlite = "sqlite:teste.db";
$pdo = new PDO($sqlite);
$username = $_POST['login_username'];
$password = $_POST['login_password'];
$login=$pdo->prepare("SELECT * FROM users WHERE Email= :username AND password= :password");
$login->bindValue(":username",$username);
$login->bindValue(":password",$password);
$login->execute();
if(isset($_POST['login_btn'])){
if($login->rowCount()==1){
echo "Logged In";
}else{
echo "Login Failed";
}
}