萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> PHP 程式設計

PHP + MySQL 實現用戶註冊登錄系統

用戶註冊登錄是 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;

核心類:Auth.php

<?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);
    }
}

頁面示例

register.php

<?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; ?>

login.php

<?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)
  • ✅ Prepared Statements 防 SQL 注入
  • ✅ CSRF Token 保護表單提交
  • ✅ session_regenerate_id(true) 防 Session Fixation
  • ✅ Cookie 設置 HttpOnly、Secure、SameSite=Lax/Strict
  • ✅ 登錄失敗限流(建議用 Redis 記錄 IP/用戶名失敗次數)
  • ✅ 密碼重置流程:生成一次性 Token、郵件發送、限時有效、使用後失效
  • ✅ HTTPS 全站強制

擴展方向

  • OAuth2 / OpenID Connect 第三方登錄(Google、GitHub、微信)
  • 雙因子認證 (TOTP / SMS / Email)
  • JWT 無狀態認證(API 服務適用)
  • RBAC 權限系統(角色、權限、資源)
  • 設備指紋、異地登錄告警

此實現遵循現代 PHP 安全最佳實踐,代碼模塊化、可測試、易擴展,適合作為中小型項目認證系統的基石。

copyright © 萬盛學電腦網 all rights reserved