<?php
require_once 'config.php';
session_start();
if (!empty($_SESSION['user_id'])) {
header('Location: dashboard.php');
exit;
}
$errors = [];
$username = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$username = trim($_POST['username'] ?? '');
$password = $_POST['password'] ?? '';
$remember = !empty($_POST['remember']);
if ($username === '' || $password === '') {
$errors[] = '請輸入帳號密碼';
} else {
$pdo = getPDO();
$stmt = $pdo->prepare('SELECT id, username, password_hash, roles, status FROM users WHERE username = ?');
$stmt->execute([$username]);
$user = $stmt->fetch();
if ($user && $user['status'] && password_verify($password, $user['password_hash'])) {
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
$_SESSION['roles'] = $user['roles'];
$_SESSION['login_time'] = time();
$_SESSION['last_activity'] = time();
// 更新最後登入時間
$pdo->prepare('UPDATE users SET last_login_at = NOW() WHERE id = ?')->execute([$user['id']]);
// 記住我
if ($remember) {
issueRememberToken($pdo, $user['id']);
}
$redirect = $_GET['redirect'] ?? 'dashboard.php';
header('Location: ' . $redirect);
exit;
}
$errors[] = '帳號或密碼錯誤,或帳號已停用';
}
}
function issueRememberToken(PDO $pdo, int $userId): void {
$selector = bin2hex(random_bytes(16));
$validator = bin2hex(random_bytes(32));
$hash = hash('sha256', $validator);
$expires = date('Y-m-d H:i:s', time() + 30*86400);
$pdo->prepare('INSERT INTO remember_tokens (selector, validator_hash, user_id, expires) VALUES (?, ?, ?, ?)')
->execute([$selector, $hash, $userId, $expires]);
setcookie('remember_me', $selector . ':' . $validator, time() + 30*86400, '/', '', true, true);
}
?>
登入
登入系統
" . htmlspecialchars($e) . ""; ?>
<?php
require_once 'config.php';
session_start();
requireAuth(); // 檢查登入、逾時、自動登入
function requireAuth(): void {
// 1. 檢查 Session
if (empty($_SESSION['user_id'])) {
// 2. 嘗試記住我 Token 自動登入
if (tryAutoLogin()) return;
// 3. 導向登入頁
header('Location: login.php?redirect=' . urlencode($_SERVER['REQUEST_URI']));
exit;
}
// 4. 檢查閒置逾時
if (time() - $_SESSION['last_activity'] > SESSION_LIFETIME) {
session_destroy();
header('Location: login.php?expired=1');
exit;
}
$_SESSION['last_activity'] = time();
}
function tryAutoLogin(): bool {
if (empty($_COOKIE['remember_me'])) return false;
$pdo = getPDO();
[$selector, $validator] = explode(':', $_COOKIE['remember_me'], 2);
$stmt = $pdo->prepare('SELECT user_id, validator_hash, expires FROM remember_tokens WHERE selector = ?');
$stmt->execute([$selector]);
$token = $stmt->fetch();
if (!$token || $token['expires'] < date('Y-m-d H:i:s')) return false;
if (!hash_equals($token['validator_hash'], hash('sha256', $validator))) return false;
// 取得使用者
$stmt = $pdo->prepare('SELECT id, username, roles, status FROM users WHERE id = ?');
$stmt->execute([$token['user_id']]);
$user = $stmt->fetch();
if (!$user || !$user['status']) return false;
// 登入成功:旋轉 Token
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
$_SESSION['roles'] = $user['roles'];
$_SESSION['login_time'] = time();
$_SESSION['last_activity'] = time();
// 更新 Token
$newSelector = bin2hex(random_bytes(16));
$newValidator = bin2hex(random_bytes(32));
$newHash = hash('sha256', $newValidator);
$pdo->prepare('UPDATE remember_tokens SET selector = ?, validator_hash = ? WHERE selector = ?')
->execute([$newSelector, $newHash, $selector]);
setcookie('remember_me', $newSelector . ':' . $newValidator, strtotime($token['expires']), '/', '', true, true);
return true;
}
?>
會員中心
歡迎,= htmlspecialchars($_SESSION['username']) ?>
角色: = implode(', ', $_SESSION['roles']) ?>
<?php
require_once 'config.php';
session_start();
// 清除記住我 Token
if (!empty($_COOKIE['remember_me'])) {
[$selector] = explode(':', $_COOKIE['remember_me'], 2);
$pdo = getPDO();
$pdo->prepare('DELETE FROM remember_tokens WHERE selector = ?')->execute([$selector]);
setcookie('remember_me', '', time() - 3600, '/', '', true, true);
}
// 銷毀 Session
$_SESSION = [];
session_destroy();
header('Location: login.php?logged_out=1');
exit;
?>
<?php
// config.php
function getPDO(): PDO {
static $pdo = null;
if ($pdo === null) {
$pdo = new PDO(
"mysql:host=127.0.0.1;dbname=myapp;charset=utf8mb4",
'app_user', 'secure_pass',
[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false]
);
}
return $pdo;
}
define('SESSION_LIFETIME', 1800); // 30分
// Session 安全設定
ini_set('session.cookie_httponly', '1');
ini_set('session.cookie_secure', isset($_SERVER['HTTPS']) ? '1' : '0');
ini_set('session.use_strict_mode', '1');
ini_set('session.gc_maxlifetime', (string)SESSION_LIFETIME);
ini_set('session.sid_length', '48'); // PHP 7.1+
?>
password_hash() / password_verify() (bcrypt/argon2)session_regenerate_id(true)htmlspecialchars() 防 XSS