<?php
// config.php
return [
'dsn' => 'mysql:host=127.0.0.1;dbname=test;charset=utf8mb4',
'user' => 'dbuser',
'pass' => 'dbpass',
'options' => [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false, // 真實預處理
],
];
// api/users.php
require __DIR__ . '/config.php';
$cfg = require __DIR__ . '/config.php';
try {
$pdo = new PDO($cfg['dsn'], $cfg['user'], $cfg['pass'], $cfg['options']);
} catch (PDOException $e) {
http_response_code(500);
exit(json_encode(['error' => 'DB connection failed']));
}
// 單筆查詢
$id = filter_input(INPUT_GET, 'id', FILTER_VALIDATE_INT);
if ($id) {
$stmt = $pdo->prepare('SELECT id, name, email FROM users WHERE id = ?');
$stmt->execute([$id]);
$user = $stmt->fetch();
header('Content-Type: application/json; charset=utf-8');
echo json_encode($user ?: ['error' => 'Not found'], JSON_UNESCAPED_UNICODE);
exit;
}
// 多筆列表
$stmt = $pdo->query('SELECT id, name, email FROM users ORDER BY id DESC LIMIT 50');
$users = $stmt->fetchAll();
header('Content-Type: application/json; charset=utf-8');
echo json_encode(['data' => $users], JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
?>
ATTR_EMULATE_PREPARES => false 使用真實預處理。JSON_UNESCAPED_UNICODE 保留中文可讀,JSON_UNESCAPED_SLASHES 避免 \/。Content-Type: application/json,避免瀏覽器誤判。close()。<?php
// 舊代碼(已棄用、移除)
$sql = "SELECT id, name FROM users WHERE id=1";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
echo json_encode(['jsonObj' => $row]);
mysql_free_result($result);
mysql_close();
?>
警告:
mysql_*函數在 PHP 7.0 完全移除,請務必遷移至 PDO 或 mysqli。