php - LaSTLogin 登录时未更新

Question

我不确定我做错了什么，基本上当用户登录时我试图更新用户数据库中的“laSTLogin”字段。

$login = login($username, $password);
    if ($login === false) {
        $errors[] = 'That username/password combination is incorrect';
    } else {
        $_SESSION['user_id'] = $login;
        $sql = "UPDATE `users` (lastlogin) VALUES ('now()') WHERE `user_id` = $user_id";
        header('Location: index.php');
        exit();
    }

Answer 1

无需在now()函数上使用'，添加SET:

$sql = "UPDATE `users` SET lastlogin = now() WHERE `user_id` = $user_id";

您没有执行任何 mysql 函数，PDO , mysqli或旧/变质mysql_*

考虑添加:

$mysqli = new mysqli("example.com", "user", "password", "database");
$res = $mysqli->query("UPDATE `users` SET lastlogin = now() WHERE `user_id` = $user_id");