前後端分離風格:前端負責交互與狀態顯示,後端提供 RESTful API(登入、登出、狀態檢查),通過 JSON 交換資料,Session 維持登入狀態。
CREATE TABLE `users` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) NOT NULL UNIQUE,
`password` CHAR(60) NOT NULL, -- bcrypt hash
`email` VARCHAR(100) DEFAULT '',
`login_count` INT(10) UNSIGNED DEFAULT 0,
`last_login_at` DATETIME DEFAULT NULL,
`last_login_ip` VARCHAR(45) DEFAULT '',
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- 測試帳號:demo / password123 (bcrypt hash)
INSERT INTO `users` (`username`, `password`) VALUES
('demo', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi');
config.php<?php
session_start();
header('Content-Type: application/json; charset=utf-8');
require_once 'db.php'; // PDO 連線
// 統一回應格式
function jsonResponse($success, $data = [], $message = '', $code = 200) {
http_response_code($code);
echo json_encode([
'success' => $success,
'data' => $data,
'message' => $message
], JSON_UNESCAPED_UNICODE);
exit;
}
// 獲取客戶端真實 IP
function getClientIp() {
$keys = ['HTTP_X_FORWARDED_FOR', 'HTTP_CLIENT_IP', 'REMOTE_ADDR'];
foreach ($keys as $key) {
if (!empty($_SERVER[$key])) {
$ips = explode(',', $_SERVER[$key]);
return trim($ips[0]);
}
}
return 'unknown';
}
api/login.php<?php
require_once 'config.php';
if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
jsonResponse(false, null, 'Method not allowed', 405);
}
$input = json_decode(file_get_contents('php://input'), true) ?? $_POST;
$username = trim($input['username'] ?? '');
$password = $input['password'] ?? '';
$remember = !empty($input['remember']);
if (!$username || !$password) {
jsonResponse(false, null, '帳號密碼不可為空');
}
$stmt = $pdo->prepare("SELECT id, username, password, login_count FROM users WHERE username = ?");
$stmt->execute([$username]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$user || !password_verify($password, $user['password'])) {
jsonResponse(false, null, '帳號或密碼錯誤');
}
// 更新登入資訊
$ip = getClientIp();
$now = date('Y-m-d H:i:s');
$pdo->prepare("UPDATE users SET login_count = login_count + 1, last_login_at = ?, last_login_ip = ? WHERE id = ?")
->execute([$now, $ip, $user['id']]);
// 設定 Session
$_SESSION['user'] = [
'id' => $user['id'],
'username' => $user['username'],
'login_count' => $user['login_count'] + 1,
'last_login_at' => $now
];
// 記住我:設定長效 Cookie(實際應用建議用 JWT 或資料庫 Token 表)
if ($remember) {
$token = bin2hex(random_bytes(32));
$expire = time() + 30 * 24 * 3600; // 30 天
$pdo->prepare("INSERT INTO user_tokens (user_id, token, expires_at) VALUES (?, ?, ?)")
->execute([$user['id'], hash('sha256', $token), date('Y-m-d H:i:s', $expire)]);
setcookie('remember_token', $token, $expire, '/', '', true, true); // Secure, HttpOnly
}
jsonResponse(true, [
'user' => $_SESSION['user'],
'redirect' => '/dashboard.php'
], '登入成功');
api/logout.php<?php
require_once 'config.php';
// 清除 remember token
if (!empty($_COOKIE['remember_token'])) {
$tokenHash = hash('sha256', $_COOKIE['remember_token']);
$pdo->prepare("DELETE FROM user_tokens WHERE token = ?")->execute([$tokenHash]);
setcookie('remember_token', '', time() - 3600, '/', '', true, true);
}
// 銷毀 Session
session_unset();
session_destroy();
jsonResponse(true, null, '已登出');
api/me.php<?php
require_once 'config.php';
// 自動登入檢查(remember token)
if (empty($_SESSION['user']) && !empty($_COOKIE['remember_token'])) {
$tokenHash = hash('sha256', $_COOKIE['remember_token']);
$stmt = $pdo->prepare("SELECT u.* FROM users u
JOIN user_tokens ut ON u.id = ut.user_id
WHERE ut.token = ? AND ut.expires_at > NOW()");
$stmt->execute([$tokenHash]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user) {
$_SESSION['user'] = [
'id' => $user['id'],
'username' => $user['username'],
'login_count' => $user['login_count'],
'last_login_at' => $user['last_login_at']
];
// 續期 token
$newExpire = date('Y-m-d H:i:s', time() + 30 * 24 * 3600);
$pdo->prepare("UPDATE user_tokens SET expires_at = ? WHERE token = ?")
->execute([$newExpire, $tokenHash]);
} else {
setcookie('remember_token', '', time() - 3600, '/', '', true, true);
}
}
if (!empty($_SESSION['user'])) {
jsonResponse(true, ['user' => $_SESSION['user']], '已登入');
} else {
jsonResponse(false, null, '未登入', 401);
}
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Ajax 登入系統</title>
<style>
.auth-container { max-width: 400px; margin: 50px auto; padding: 20px; border: 1px solid #ddd; border-radius: 8px; }
.form-group { margin-bottom: 15px; }
label { display: block; margin-bottom: 5px; font-weight: bold; }
input[type="text"], input[type="password"] { width: 100%; padding: 10px; border: 1px solid #ccc; border-radius: 4px; box-sizing: border-box; }
.btn { width: 100%; padding: 12px; background: #007bff; color: white; border: none; border-radius: 4px; cursor: pointer; font-size: 16px; }
.btn:hover { background: #0056b3; }
.msg { padding: 10px; border-radius: 4px; margin-bottom: 15px; display: none; }
.msg.error { background: #f8d7da; color: #721c24; border: 1px solid #f5c6cb; }
.msg.success { background: #d4edda; color: #155724; border: 1px solid #c3e6cb; }
.user-info { display: none; }
.user-info p { margin: 10px 0; }
</style>
</head>
<body>
<div class="auth-container">
<div id="msg" class="msg"></div>
<!-- 登入表單 -->
<form id="loginForm">
<h2>用戶登入</h2>
<div class="form-group">
<label>帳號</label>
<input type="text" name="username" id="username" autocomplete="username" required>
</div>
<div class="form-group">
<label>密碼</label>
<input type="password" name="password" id="password" autocomplete="current-password" required>
</div>
<div class="form-group">
<label><input type="checkbox" name="remember" value="1"> 記住我 (30天)</label>
</div>
<button type="submit" class="btn">登 入</button>
</form>
<!-- 登入後資訊 -->
<div id="userInfo" class="user-info">
<h2>歡迎回來</h2>
<p><strong id="displayName"></strong>,登入成功!</p>
<p>這是您第 <span id="loginCount"></span> 次登入</p>
<p>上次登入:<span id="lastLogin"></span></p>
<button id="logoutBtn" class="btn" style="background:#dc3545;">登 出</button>
</div>
</div>
<script src="https://cdn.jsdelivr.net/npm/jquery@3.6.0/dist/jquery.min.js"></script>
<script>
$(function() {
const $msg = $('#msg');
const $loginForm = $('#loginForm');
const $userInfo = $('#userInfo');
// 顯示訊息
function showMsg(text, isError = false) {
$msg.text(text).removeClass('success error').addClass(isError ? 'error' : 'success').show();
}
// 切換到登入狀態
function showLoggedIn(user) {
$loginForm.hide();
$('#displayName').text(user.username);
$('#loginCount').text(user.login_count);
$('#lastLogin').text(user.last_login_at);
$userInfo.show();
}
// 切換到登出狀態
function showLoggedOut() {
$userInfo.hide();
$loginForm.show();
$loginForm[0].reset();
}
// 檢查登入狀態(頁面載入時)
function checkAuth() {
$.getJSON('api/me.php', function(res) {
if (res.success) showLoggedIn(res.data.user);
else showLoggedOut();
}).fail(() => showLoggedOut());
}
// 登入提交
$loginForm.on('submit', function(e) {
e.preventDefault();
const $btn = $loginForm.find('button').prop('disabled', true).text('登入中...');
$.ajax({
url: 'api/login.php',
method: 'POST',
dataType: 'json',
data: $loginForm.serialize(),
success: function(res) {
$btn.prop('disabled', false).text('登 入');
if (res.success) {
showMsg(res.message);
setTimeout(() => showLoggedIn(res.data.user), 500);
} else {
showMsg(res.message, true);
}
},
error: function() {
$btn.prop('disabled', false).text('登 入');
showMsg('網路錯誤,請稍後再試', true);
}
});
});
// 登出
$('#logoutBtn').on('click', function() {
const $btn = $(this).prop('disabled', true).text('登出中...');
$.post('api/logout.php', function(res) {
$btn.prop('disabled', false).text('登 出');
if (res.success) {
showMsg('已登出');
setTimeout(showLoggedOut, 500);
} else {
showMsg(res.message, true);
}
}, 'json').fail(() => {
$btn.prop('disabled', false).text('登 出');
showMsg('網路錯誤', true);
});
});
// 初始化
checkAuth();
});
</script>
</body>
</html>
| 項目 | 實現方式 |
|---|---|
| 密碼加密 | PHP password_hash() / password_verify() (bcrypt/argon2) |
| CSRF 防護 | 雙重 Cookie 模式或 Header Token 驗證 |
| 暴力破解防禦 | IP 限流、帳號鎖定、驗證碼、fail2ban |
| Session 安全 | HttpOnly、Secure、SameSite=Strict、定期重生成 ID |
| Remember Token | 資料庫存雜湊、設定過期、單裝置/多裝置策略 |
| SQL 注入 | 全程 Prepared Statement (PDO) |
| XSS 防護 | 輸出轉義 htmlspecialchars、CSP 標頭 |
現代 Ajax 登入系統核心要素:JSON API 介面、Session + Remember Token 雙軌制、前端狀態機管理、完整安全防護。本範例可直接作為專案起始模板擴充註冊、密碼重設、OAuth 綁定等功能。