PDO登录错误

Question

错误 SQLSTATEHY093:无效参数号:参数未定义！

<?php
    session_start();
    require_once 'dbconfig.php';
    if(isset($_POST['btn-login']))
    {
        $username = trim($_POST['username']);
        $user_password = trim($_POST['password']);
        $password = md5($user_password);
        try{
            $stmt = $db_con->prepare("SELECT * FROM user1 WHERE username=:username");
            $stmt->execute(array(":email"=>$username));
            $row = $stmt->fetch(PDO::FETCH_ASSOC);
            $count = $stmt->rowCount();
            if($row['user_password']==$password){
            echo "ok"; // log in
            $_SESSION['user_session'] = $row['username'];
            }
            else{
                    echo "email or password does not exist."; // wrong details 
                }
            }
             catch(PDOException $e) {
                   echo $e->getMessage();
                 }
           }
        ?>

正确的代码是什么？请任何人找出错误并给出正确的代码格式。

Answer 1

您的execute()语句是错误的。看这里，

$stmt->execute(array(":email"=>$username));
                         ^

应该是，

$stmt->execute(array(":username"=>$username));