prepare('SELECT * FROM accounts WHERE remember_me_code = ?');
$stmt->execute([ $_COOKIE['remember_me'] ]);
$account = $stmt->fetch(PDO::FETCH_ASSOC);
if ($account) {
// Authenticate the user
session_regenerate_id();
$_SESSION['account_loggedin'] = TRUE;
$_SESSION['account_name'] = $account['username'];
$_SESSION['account_id'] = $account['id'];
$_SESSION['account_role'] = $account['role'];
// Update last seen date
$date = date('Y-m-d\TH:i:s');
$stmt = $pdo->prepare('UPDATE accounts SET last_seen = ? WHERE id = ?');
$stmt->execute([ $date, $account['id'] ]);
// Redirect to home page
header('Location: home.php');
exit;
}
}
?>
404 - Layout 2 | Canvas
