prepare("SELECT * FROM unified_users WHERE (username = ? OR phone = ? OR email = ?) AND status = 1");
$stmt->execute([$username, $username, $username]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user && password_verify($password, $user['password'])) {
// 登录成功，设置session
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
$_SESSION['nickname'] = $user['nickname'] ?: $user['username'];
$_SESSION['email'] = $user['email'];
$_SESSION['member_level'] = $user['member_level'];
// 更新token
$token = bin2hex(random_bytes(32));
$stmt = $db->prepare("UPDATE unified_users SET token = ?, last_login_at = NOW() WHERE id = ?");
$stmt->execute([$token, $user['id']]);
// 设置cookie
setcookie('auth_token', $token, time() + 86400 * 30, '/');
header('Location: /member/');
exit;
} else {
$error = '用户名或密码错误';
}
}
?>
登录 - 懒人生态圈
🌸 会员登录
注册即可享受：
- AI工具无限次使用
- 免费学习所有课程
- 专属学习路径规划
- 积分奖励体系