php - 我究竟做错了什么？准备语句登录

Question

这是我的login.php文件，当表单定向到此页面运行代码时，屏幕说

"this page is not working"

我做错了什么以及如何解决它？另外，当我让代码工作时，cookie 还没有设置，这让我认为错误就在那里。

//IF REMEMBER ME IS TURNED ON
$stmt = $conn->prepare("SELECT * FROM users WHERE email=? AND password=?");
$stmt->bind_param("ss", $SearchEmail, $SearchPassword);

// set parameters and execute
$SearchEmail = $email;
$SearchPassword = $password;
$stmt->execute();
if($stmt->fetch() == true) {
    $result = $stmt->get_result();
    while($row = $result->fetch_assoc()) {
        setcookie("SIT_name", $row['FirstName'], time()+3600*24*365*10, '/');
        setcookie("SIT_acc_type", $row['acc_type'], time()+3600*24*365*10, '/');
    }

    $stmt = $conn->prepare("UPDATE users SET last_log=? WHERE email=? AND password=?");
    $stmt->bind_param("sss", $time, $SearchEmail, $SearchPassword);
    $time = 'Time: '.date("h:i:sa").', Date: '.date("d/m/Y").'.';
    $SearchEmail = $email;
    $SearchPassword = $password;
    if ($stmt->execute()) {
        echo "Success";
        //Header('Location: ../');
    }
} else {
    echo "Wrong Username or Password!";
}

屏幕截图(来自评论部分)

Answer 1

试试这个

//IF REMEMBER ME IS TURNED ON
$stmt = $conn->prepare("SELECT * FROM users WHERE email=? AND password=?");
$stmt->bind_param("ss", $SearchEmail, $SearchPassword);

// set parameters and execute
$SearchEmail = $email;
$SearchPassword = $password;
$stmt->execute();

if($stmt->fetch() == true) {
    $result = $stmt->get_result();
    while ($row = $result->fetch_array()) {
        setcookie("SIT_name", $row['FirstName'], time()+3600*24*365*10, '/');
        setcookie("SIT_acc_type", $row['acc_type'], time()+3600*24*365*10, '/');
    }

    $stmt = $conn->prepare("UPDATE users SET last_log=? WHERE email=? AND password=?");
    $stmt->bind_param("sss", $time, $SearchEmail, $SearchPassword);
    $time = 'Time: '.date("h:i:sa").', Date: '.date("d/m/Y").'.';
    $SearchEmail = $email;
    $SearchPassword = $password;
    if ($stmt->execute()) {
        echo "Success";
        //Header('Location: ../');
    }
} else {
    echo "Wrong Username or Password!";
}