用戶註冊登錄是 Web 應用基礎功能。本文提供一個基於 PDO、密碼哈希、Prepared Statements、Session 管理的完整實現,包含註冊、登錄、登出、記住我、CSRF 防護、密碼重置流程,代碼結構清晰,可直接作為項目起步模板。
CREATE TABLE `users` (
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL COMMENT '用戶名',
`email` VARCHAR(100) NOT NULL COMMENT '郵箱',
`password_hash` VARCHAR(255) NOT NULL COMMENT 'password_hash() 結果',
`salt` VARCHAR(32) DEFAULT NULL COMMENT '舊版兼容,新版不需單獨鹽',
`status` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT '1=正常,0=禁用',
`last_login_at` TIMESTAMP NULL DEFAULT NULL,
`last_login_ip` VARCHAR(45) DEFAULT NULL,
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `uk_username` (`username`),
UNIQUE KEY `uk_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
<?php
class Auth {
private PDO $pdo;
public function __construct(PDO $pdo) { $this->pdo = $pdo; }
// 註冊
public function register(string $username, string $email, string $password): array {
// 驗證
if (!preg_match('/^[a-zA-Z0-9_]{3,20}$/', $username)) return ['ok'=>false, 'msg'=>'用戶名 3-20 位字母數字下劃線'];
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) return ['ok'=>false, 'msg'=>'郵箱格式錯誤'];
if (strlen($password) < 8) return ['ok'=>false, 'msg'=>'密碼至少 8 位'];
// 檢查唯一性
$stmt = $this->pdo->prepare("SELECT 1 FROM users WHERE username=? OR email=?");
$stmt->execute([$username, $email]);
if ($stmt->fetch()) return ['ok'=>false, 'msg'=>'用戶名或郵箱已存在'];
// 密碼哈希
$hash = password_hash($password, PASSWORD_ARGON2ID); // PHP 7.2+
// 插入
$stmt = $this->pdo->prepare("INSERT INTO users (username, email, password_hash) VALUES (?, ?, ?)");
$stmt->execute([$username, $email, $hash]);
return ['ok'=>true, 'id'=>$this->pdo->lastInsertId()];
}
// 登錄
public function login(string $username, string $password, bool $remember = false): array {
$stmt = $this->pdo->prepare("SELECT * FROM users WHERE (username=? OR email=?) AND status=1");
$stmt->execute([$username, $username]);
$user = $stmt->fetch();
if (!$user) return ['ok'=>false, 'msg'=>'用戶不存在或已禁用'];
if (!password_verify($password, $user['password_hash'])) {
return ['ok'=>false, 'msg'=>'密碼錯誤'];
}
// 更新登錄信息
$ip = $_SERVER['REMOTE_ADDR'] ?? '';
$this->pdo->prepare("UPDATE users SET last_login_at=NOW(), last_login_ip=? WHERE id=?")
->execute([$ip, $user['id']]);
// Session 綁定
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
// 記住我:長效 Cookie + 資料庫 Token 表(此處簡化)
if ($remember) {
setcookie('remember_token', $user['id'] . '|' . hash('sha256', $user['password_hash'] . $ip),
time() + 30*86400, '/', '', true, true); // Secure, HttpOnly
}
return ['ok'=>true, 'user'=>['id'=>$user['id'], 'username'=>$user['username']]];
}
// 登出
public function logout(): void {
$_SESSION = [];
if (ini_get("session.use_cookies")) {
$params = session_get_cookie_params();
setcookie(session_name(), '', time() - 42000, $params["path"], $params["domain"], $params["secure"], $params["httponly"]);
}
session_destroy();
setcookie('remember_token', '', time() - 3600, '/', '', true, true);
}
// 獲取當前用戶
public function user(): ?array {
if (empty($_SESSION['user_id'])) return null;
$stmt = $this->pdo->prepare("SELECT id, username, email, status FROM users WHERE id=? AND status=1");
$stmt->execute([$_SESSION['user_id']]);
return $stmt->fetch() ?: null;
}
// CSRF Token
public function csrfToken(): string {
if (empty($_SESSION['csrf_token'])) {
$_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}
return $_SESSION['csrf_token'];
}
public function verifyCsrf(string $token): bool {
return isset($_SESSION['csrf_token']) && hash_equals($_SESSION['csrf_token'], $token);
}
}
<?php require 'bootstrap.php'; // 包含 PDO、Auth 實例化
$auth = new Auth($pdo);
$errors = [];
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (!$auth->verifyCsrf($_POST['csrf'] ?? '')) $errors[] = 'CSRF 校驗失敗';
else {
$res = $auth->register($_POST['username'], $_POST['email'], $_POST['password']);
if ($res['ok']) header('Location: login.php?registered=1');
else $errors[] = $res['msg'];
}
}
?>
<form method="post">
<input type="hidden" name="csrf" value="<?= $auth->csrfToken() ?>">
<div><label>用戶名<input name="username" required></label></div>
<div><label>郵箱<input name="email" type="email" required></label></div>
<div><label>密碼<input name="password" type="password" required minlength="8"></label></div>
<button type="submit">註冊</button>
</form>
<?php foreach ($errors as $e): ?><p style="color:red"><?= $e ?></p><?php endforeach; ?>
<?php require 'bootstrap.php';
$auth = new Auth($pdo);
$errors = [];
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (!$auth->verifyCsrf($_POST['csrf'] ?? '')) $errors[] = 'CSRF 校驗失敗';
else {
$res = $auth->login($_POST['login'], $_POST['password'], isset($_POST['remember']));
if ($res['ok']) header('Location: ' . ($_GET['redirect'] ?? 'index.php'));
else $errors[] = $res['msg'];
}
}
?>
<form method="post">
<input type="hidden" name="csrf" value="<?= $auth->csrfToken() ?>">
<div><label>用戶名/郵箱<input name="login" required></label></div>
<div><label>密碼<input name="password" type="password" required></label></div>
<label><input type="checkbox" name="remember"> 記住我 (30天)</label>
<button type="submit">登錄</button>
</form>
<?php foreach ($errors as $e): ?><p style="color:red"><?= $e ?></p><?php endforeach; ?>
<?php
require 'bootstrap.php';
$auth = new Auth($pdo);
$user = $auth->user();
if (!$user) {
header('Location: login.php?redirect=' . urlencode($_SERVER['REQUEST_URI']));
exit;
}
echo "歡迎,{$user['username']} (ID: {$user['id']}) <a href='logout.php'>登出</a>";
password_hash() + password_verify()(Argon2id/Bcrypt)session_regenerate_id(true) 防 Session FixationHttpOnly、Secure、SameSite=Lax/Strict此實現遵循現代 PHP 安全最佳實踐,代碼模塊化、可測試、易擴展,適合作為中小型項目認證系統的基石。