前端 (index.html) │ 用戶輸入用戶名 → onblur 觸發 ▼ JS (ajax.js) │ XMLHttpRequest / fetch GET /check.php?name=xxx ▼ 後端 (check.php) │ 查詢資料庫 → 回傳 "true"/"false" 或 JSON ▼ 前端顯示「已被註冊」/「可使用」
<!DOCTYPE html>
<html><head>
<meta charset="UTF-8">
<title>用戶名檢測</title>
<style>
.available { color: green; }
.taken { color: red; }
</style>
</head><body>
<form>
用戶名: <input type="text" id="username" name="username" autocomplete="off">
<span id="msg"></span>
</form>
<script src="ajax.js"></script>
</body></html>
// ajax.js
const usernameInput = document.getElementById('username');
const msgEl = document.getElementById('msg');
let debounceTimer;
usernameInput.addEventListener('input', () => {
clearTimeout(debounceTimer);
debounceTimer = setTimeout(checkUsername, 300); // 防抖 300ms
});
async function checkUsername() {
const name = usernameInput.value.trim();
if (!name) {
msgEl.textContent = '';
msgEl.className = '';
return;
}
msgEl.textContent = '檢查中...';
msgEl.className = '';
try {
const res = await fetch(`check.php?name=${encodeURIComponent(name)}`);
const data = await res.json();
if (data.exists) {
msgEl.textContent = '✗ 此用戶名已被註冊';
msgEl.className = 'taken';
} else {
msgEl.textContent = '✓ 可使用';
msgEl.className = 'available';
}
} catch (e) {
msgEl.textContent = '檢查失敗,請稍後再試';
msgEl.className = 'taken';
console.error(e);
}
}
<?php
// check.php
header('Content-Type: application/json; charset=UTF-8');
require_once __DIR__ . '/conn.php'; // PDO 連線
$name = trim($_GET['name'] ?? '');
if ($name === '') {
echo json_encode(['exists' => false, 'error' => 'empty']);
exit;
}
// 安全:長度限制、字符白名單
if (strlen($name) > 20 || !preg_match('/^[a-zA-Z0-9_\x{4e00}-\x{9fa5}]+$/u', $name)) {
echo json_encode(['exists' => false, 'error' => 'invalid_format']);
exit;
}
$stmt = $pdo->prepare("SELECT 1 FROM users WHERE username = ? LIMIT 1");
$stmt->execute([$name]);
$exists = (bool)$stmt->fetchColumn();
echo json_encode(['exists' => $exists]);
<?php
// conn.php
$dsn = 'mysql:host=127.0.0.1;dbname=test;charset=utf8mb4';
$user = 'root';
$pass = 'password';
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (PDOException $e) {
// 生產環境記錄日誌,不輸出細節
error_log('DB Connection failed: ' . $e->getMessage());
die(json_encode(['exists' => false, 'error' => 'db_error']));
}
textContent 而非 innerHTML 輸出訊息。資料庫欄位 utf8mb4_unicode_ci、連線 SET NAMES utf8mb4、前端 encodeURIComponent、後端直接查詢即可,無需額外轉碼。