8. 刪、修

修改HTML
 

<p style="text-align:center"><span style="font-size:24px">腦筋急轉彎-修改</span></p>

<form method="post" name="update">
<p>題目：<input name="q" required="required" type="text" value='<?php echo $row[xxxx]; ?>' /></p>

<p>答案：<input name="a" required="required" type="text" value='<?php echo $row[xxxx]; ?>' /></p>
<input name="tid" type="hidden" value="<?php echo $row[xxxx]; ?>" />

<p><input name="submit" type="submit" value="修改" /></p>
</form>

修改PHP
 

<?php
include("config.php");
header("Content-Type: text/html; charset=utf-8");

if($_POST['submit'])  {
    $sql_query = "update think set q='$_POST[xxxx]',a='$_POST[xxxx]' where tid='$_POST[xxxx]' ";
    $db_link->query($sql_query) or die("錯誤:".$sql_query);
    //echo $sql_query."<br>";  
}

$sql_query = "SELECT * FROM think where tid = $_GET[xxxx] ";
$result = $db_link->query($sql_query);
$row = $result->fetch_array();
?>

刪除HTML

<td>動作</td>

<td><a href="list.php?tid=<?php echo $row[tid]; ?>">刪</a>、
    <a href="update.php?tid=<?php echo $row[tid]; ?>">修</a>
</td>

刪除PHP

if($_GET[xxxx])  {
    $sql_query = "delete from think where xxxx = $_GET[xxxx] ";
    $db_link->query($sql_query) or die("錯誤:$sql_query");    
}

刪除時的警告

onclick="javascript:return confirm('確定要刪除這筆資料嗎？');"