萬盛學電腦網

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

PHP 入門實戰:從建表到用戶登入驗證完整流程(MySQL + MD5 + Session)

步驟 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/SameSitesession_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 = '帳號或密碼錯誤';
}
?>
copyright © 萬盛學電腦網 all rights reserved