我更改了($newPassword到$new），它在数据库中仍然是空的！！:( ,. - i changed ($newPassword to $new), Still its empty in database!! :( ,

i changed ($newPassword to $new), Still its empty in database!! :( ,

'密码正在更新为空值！旧密码已替换为空值！！

$email = $_POST['email'];
$password = $_POST['password']; //old password
$new = $POST['new'];  //new password
//table name is users
    $stmt = $db->prepare("SELECT * FROM users WHERE email=:email_id");  
//checking email and password   
    $stmt->execute(array(":email_id"=>$email));
    $userRow=$stmt->fetch(PDO::FETCH_ASSOC);
    if(($userRow['email'] === $email)&&($userRow['password'] === $password))
    {    
        $doneQuery = $db->prepare("
        UPDATE users 
        SET password = :new   
        WHERE email = :emailid" );                                  
        $doneQuery->execute([":newPassword"=>$new,
                        ":emailid"=>$email]);
}

您正在使用$newpassword更新数据库，但您在顶部将其声明为$new，这意味着if是一个空变量并将其输入为空您还错过了帖子中的低分所以改变

$new = $POST['new'];

自

$newPassword = $_POST['new'];

$email = $_POST['email']; $password = $_POST['password']; //old password         $newPassword= $_POST['new']; //new password //table name is users $stmt = $db->prepare("SELECT * FROM users WHERE email=:email_id"); //checking email and password $stmt->execute(array(":email_id"=>$email)); $userRow=$stmt->fetch(PDO::FETCH_ASSOC); if(($userRow['email'] === $email)&&($userRow['password'] === $password)) { $doneQuery = $db->prepare(" UPDATE users SET password = :newPassword WHERE email = :emailid" ); $doneQuery->execute([":newPassword"=>$new, ":emailid"=>$email]); }