展示一個精簡的會員登入流程:輸入驗證 → SQL 查詢 → Session 狀態管理 → 導向。包含防 SQL 注入處理與訊息回饋機制。
<?php
// 安全過濾函數
function safestrip($string) {
$string = strip_tags($string);
$string = mysql_real_escape_string($string); // 注意:mysql_* 已棄用
return $string;
}
// 訊息顯示
function messages() {
$msg = '';
if (!empty($_SESSION['success'])) {
$msg = '<span id="message">' . $_SESSION['success'] . '</span>';
$_SESSION['success'] = '';
}
if (!empty($_SESSION['error'])) {
$msg = '<span id="message">' . $_SESSION['error'] . '</span>';
$_SESSION['error'] = '';
}
return $msg;
}
// 登入處理
function login($username, $password) {
$user = safestrip($username);
$pass = md5(safestrip($password)); // 建議改用 password_hash()
$sql = "SELECT * FROM user_table WHERE username = '$user' AND password = '$pass'";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) == 1) {
$_SESSION['authorized'] = true;
$_SESSION['success'] = '登入成功';
header('Location: ./index.php');
exit;
} else {
$_SESSION['error'] = '帳號或密碼錯誤';
}
}
?>
password_hash($pass, PASSWORD_DEFAULT) 儲存,password_verify($input, $hash) 驗證,勿用 MD5/SHA1。session_regenerate_id(true) 登入後重新產生 ID,設定 session.cookie_httponly=1、session.cookie_secure=1(HTTPS)。htmlspecialchars() 防 XSS。$pdo = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'user', 'pass');
$stmt = $pdo->prepare('SELECT id, password FROM users WHERE username = ?');
$stmt->execute([$username]);
$user = $stmt->fetch();
if ($user && password_verify($password, $user['password'])) {
$_SESSION['user_id'] = $user['id'];
// 登入成功...
}