idSELECT 取得資料填入表單UPDATE<?php
$link = mysql_connect("localhost", "root", "") or die("連線失敗");
mysql_select_db("my_test");
if (!isset($_GET['id']) && !isset($_POST['id'])) {
// 列表頁
$result = mysql_query("SELECT * FROM `userinfo`");
echo "<table>...</table>"; // 略
} else {
if (!isset($_POST['ok'])) {
// 顯示編輯表單
$id = (int)($_GET['id'] ?? $_POST['id']);
$result = mysql_query("SELECT * FROM `userinfo` WHERE `id` = $id");
$row = mysql_fetch_assoc($result);
?>
<form method="post" action="modify.php">
<input type="hidden" name="id" value="<?= $row['id'] ?>">
姓名 <input name="username" value="<?= htmlspecialchars($row['username']) ?>"><br>
性別 <input name="gender" value="<?= htmlspecialchars($row['gender']) ?>"><br>
年齡 <input name="age" value="<?= htmlspecialchars($row['age']) ?>"><br>
註冊時間 <input name="regdate" value="<?= htmlspecialchars($row['regdate']) ?>"><br>
<input type="submit" name="ok" value="送出">
</form>
<?php
} else {
// 執行更新
$sql = "UPDATE `userinfo` SET
`username` = '{$_POST['username']}',
`gender` = '{$_POST['gender']}',
`age` = '{$_POST['age']}',
`regdate` = '{$_POST['regdate']}'
WHERE `id` = '{$_POST['id']}'";
$result = mysql_query($sql);
echo $result ? "修改成功" : "修改失敗";
}
}
mysql_close($link);
?>
version 欄位防並發覆蓋<?php
$pdo = new PDO(...);
$id = (int)($_GET['id'] ?? $_POST['id'] ?? 0);
if ($_SERVER['REQUEST_METHOD'] === 'GET') {
$stmt = $pdo->prepare("SELECT * FROM `userinfo` WHERE `id` = ?");
$stmt->execute([$id]);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$row) die("資料不存在");
// 輸出表單(同教學版,記得 htmlspecialchars)
} else {
// 驗證 CSRF、輸入驗證...
$stmt = $pdo->prepare("UPDATE `userinfo` SET
`username` = ?, `gender` = ?, `age` = ?, `regdate` = ?
WHERE `id` = ?");
$stmt->execute([
$_POST['username'], $_POST['gender'],
(int)$_POST['age'], $_POST['regdate'], $id
]);
echo $stmt->rowCount() ? "修改成功" : "資料無變更或不存在";
}
?>
動態建構 SET 子句,僅更新有傳入的欄位:
$allowed = ['username', 'gender', 'age', 'regdate'];
$sets = []; $params = [];
foreach ($allowed as $field) {
if (isset($_POST[$field])) {
$sets[] = "`$field` = ?";
$params[] = $_POST[$field];
}
}
if ($sets) {
$params[] = $id;
$sql = "UPDATE `userinfo` SET " . implode(', ', $sets) . " WHERE `id` = ?";
$stmt = $pdo->prepare($sql);
$stmt->execute($params);
}