case "update_action": update_action($action_id); header("location:index.php?action_id=$action_id"); exit; ``` ### 二、更新資料的SQL語法 1. 更新資料的SQL語法: ``` update `資料表名稱` set `欄位1`='值1', `欄位2`='值2', ... [where 篩選條件] [limit 筆數] ``` 2. 在 admin.php 中心新增函數: ``` //更新活動 function update_action($action_id) { global $db; $title = clean_var('title', '活動名稱'); $action_date = clean_var('action_date', '活動日期'); $end_date = clean_var('end_date', '截止日期'); $enable = clean_var('enable', '使否啟用'); $content = clean_var('content', '活動內容'); $uid = $_SESSION['uid']; $sql = "UPDATE `actions` SET `title`='{$title}', `content`='{$content}', `action_date`='{$action_date}', `end_date`='{$end_date}', `enable`='{$enable}', `uid`='{$uid}' WHERE `action_id`='{$action_id}'"; if (!$db->query($sql)) { throw new Exception($db->error); } } ```
update `資料表名稱` set `欄位1`='值1', `欄位2`='值2', ... [where 篩選條件] [limit 筆數] ``` 2. 在 admin.php 中心新增函數: ``` //更新活動 function update_action($action_id) { global $db; $title = clean_var('title', '活動名稱'); $action_date = clean_var('action_date', '活動日期'); $end_date = clean_var('end_date', '截止日期'); $enable = clean_var('enable', '使否啟用'); $content = clean_var('content', '活動內容'); $uid = $_SESSION['uid']; $sql = "UPDATE `actions` SET `title`='{$title}', `content`='{$content}', `action_date`='{$action_date}', `end_date`='{$end_date}', `enable`='{$enable}', `uid`='{$uid}' WHERE `action_id`='{$action_id}'"; if (!$db->query($sql)) { throw new Exception($db->error); } } ```
//更新活動 function update_action($action_id) { global $db; $title = clean_var('title', '活動名稱'); $action_date = clean_var('action_date', '活動日期'); $end_date = clean_var('end_date', '截止日期'); $enable = clean_var('enable', '使否啟用'); $content = clean_var('content', '活動內容'); $uid = $_SESSION['uid']; $sql = "UPDATE `actions` SET `title`='{$title}', `content`='{$content}', `action_date`='{$action_date}', `end_date`='{$end_date}', `enable`='{$enable}', `uid`='{$uid}' WHERE `action_id`='{$action_id}'"; if (!$db->query($sql)) { throw new Exception($db->error); } } ```
進階搜尋