使用已棄用的 mysql_* 函數示範基本流程,**實務請改用 PDO 或 MySQLi**。
<?php
// 連線資料庫
$link = mysql_connect("localhost", "root", "") or die("連線失敗");
mysql_select_db("my_test");
// 共用:未帶 id 顯示列表,帶 id 顯示明細
if (!isset($_GET['id'])) {
// 列表頁
$sql = "SELECT * FROM `userinfo`";
$result = mysql_query($sql);
echo "<table border='1'>
<tr>
<th>編號</th><th>用戶名稱</th><th>性別</th>
<th>年齡</th><th>註冊時間</th><th>操作</th>
</tr>";
while ($row = mysql_fetch_assoc($result)) {
echo "<tr>
<td>{$row['id']}</td>
<td>{$row['username']}</td>
<td>{$row['gender']}</td>
<td>{$row['age']}</td>
<td>{$row['regdate']}</td>
<td><a href='?id={$row['id']}'>查看</a></td>
</tr>";
}
echo "</table>";
} else {
// 明細頁
$id = (int)$_GET['id']; // 強制轉型防注入
$sql = "SELECT * FROM `userinfo` WHERE `id` = $id";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if ($row) {
echo "編號:{$row['id']}<br>";
echo "用戶名:{$row['username']}<br>";
echo "性別:{$row['gender']}<br>";
echo "年齡:{$row['age']}<br>";
echo "註冊時間:{$row['regdate']}<br>";
echo "<br><a href='query.php'>繼續查詢</a>";
} else {
echo "找不到該筆資料";
}
}
mysql_close($link);
?>
htmlspecialchars() 防 XSS<?php
$pdo = new PDO("mysql:host=localhost;dbname=my_test;charset=utf8", "root", "");
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if (!isset($_GET['id'])) {
$stmt = $pdo->query("SELECT * FROM `userinfo`");
echo "<table>...</table>"; // 同樣輸出邏輯
foreach ($stmt as $row) { /* 輸出列 */ }
} else {
$stmt = $pdo->prepare("SELECT * FROM `userinfo` WHERE `id` = ?");
$stmt->execute([$_GET['id']]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if ($row) { /* 輸出明細 */ }
}
?>
LIMIT 分頁SELECT *