php - 设置上次登录日期

Question

我使用此代码，但它不起作用:/

$date = date('Y-m-d');
$update = DB::getInstance();
$update = ("UPDATE `users` SET `last_login` = '$date' WHERE `userid` = '" .$user->data()->id. "'");

Answer 1

您没有执行您的查询。你犯了一个大错误。

$date = date('Y-m-d');
$update = DB::getInstance(); #You created an instance
$update = ("UPDATE `users` SET `last_login` = '$date' WHERE `userid` = '" .$user->data()->id. "'"); #You assigned Query in the instance, This is the big mistake

你应该像下面这样查询

$date = date('Y-m-d');
$update = DB::getInstance();
$query = ("UPDATE `users` SET `last_login` = '$date' WHERE `userid` = '" .$user->data()->id. "'");

$update->YOUR_EXECUTE_FUNCTION($query);

注意:此处YOUR_EXECUTE_FUNCTION() 仅用于示例目的。将其更改为您的执行函数