步驟 1:建立用戶表
CREATE TABLE IF NOT EXISTS `useradmin` (
`id` INT(4) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(20) DEFAULT NULL,
`userpass` VARCHAR(40) DEFAULT NULL COMMENT 'MD5 雜湊',
`logins` INT(4) NOT NULL DEFAULT 0 COMMENT '登入次數',
`logintime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`mid` CHAR(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4;
步驟 2:登入表單(HTML)
<form method="post" action="">
<label>帳號: <input type="text" name="uname" id="uname" required></label><br>
<label>密碼: <input type="password" name="password" id="password" required></label><br>
<button type="submit" name="submit">登入</button>
</form>
步驟 3:PHP 處理邏輯
<?php
// 1. 資料庫連線(建議用 PDO/MySQLi 預處理防注入)
$mysqli = new mysqli('localhost', 'root', 'root', 'dbname');
$mysqli->set_charset('utf8mb4');
// 2. 表單提交檢查
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$uname = trim($_POST['uname'] ?? '');
$pass = $_POST['password'] ?? '';
if ($uname && $pass) {
// 3. 參數化查詢
$stmt = $mysqli->prepare("SELECT id, userpass, logins FROM useradmin WHERE username = ? LIMIT 1");
$stmt->bind_param('s', $uname);
$stmt->execute();
$stmt->bind_result($uid, $hash, $logins);
$stmt->fetch();
$stmt->close();
// 4. 驗證密碼(MD5 不安全,僅教學示範)
if ($hash && md5($pass) === $hash) {
// 登入成功
$_SESSION['user_id'] = $uid;
$_SESSION['username'] = $uname;
// 更新登入資訊
$mysqli->query("UPDATE useradmin SET logins = logins + 1, logintime = NOW() WHERE id = $uid");
header('Location: dashboard.php');
exit;
}
}
$error = '帳號或密碼錯誤';
}
?>
安全性關鍵補強(生產環境必做)
| 問題 | 風險 | 解決方案 |
| MD5 雜湊 | 極易碰撞、彩虹表破解、無鹽值 | 改用 password_hash() (BCrypt/Argon2) + password_verify() |
| SQL 注入 | 拼接 SQL 字串 | 全面使用預處理 prepare/bind_param |
| Session 劫持 | Cookie 無 HttpOnly/Secure/SameSite | session_set_cookie_params(['httponly'=>true, 'secure'=>true, 'samesite'=>'Lax']) |
| 暴力破解 | 無限制嘗試 | 失敗計數鎖定、驗證碼、IP 限流 |
| CSRF | 偽造登入請求 | 表單加入 CSRF Token 驗證 |
現代化登入流程範例(PHP 8 + PDO + password_hash)
<?php
session_start();
$pdo = new PDO('mysql:host=localhost;dbname=db;charset=utf8mb4', 'user', 'pass', [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$stmt = $pdo->prepare('SELECT id, username, password FROM users WHERE username = ?');
$stmt->execute([$_POST['username']]);
$user = $stmt->fetch();
if ($user && password_verify($_POST['password'], $user['password'])) {
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
header('Location: /dashboard');
exit;
}
$error = '帳號或密碼錯誤';
}
?>