9-3 上課範例：save_class.php
9-4 上課範例：index.php
<?php
require_once "header.php";
//執行刪除
$op=isset($_REQUEST['op'])?$_REQUEST['op']:"";
$class_sn=isset($_REQUEST['class_sn'])?intval($_REQUEST['class_sn']):"";
if($op=="delete"){
//設定SQL語法
$sql="delete from `tncomu_class` where class_sn='{$class_sn}'";
//執行SQL語法
mysql_query($sql) or die("無法執行：".mysql_error());
//執行完轉向
header("location: index.php");
}
//設定SQL語法
$sql="select * from `tncomu_class` order by seme desc, subject";
//執行SQL語法
$result = mysql_query($sql) or die("無法執行：".mysql_error());
$main="
<script>
function delete_func(sn){
var sure = window.
confirm('確定要刪除此資料？');
if (!sure) return;
location.href='index.php?op=delete&class_sn=' + sn;
}
</script>
<table border=1>";
while($data=mysql_fetch_assoc($result)){
$main.="
<tr>
<td>{$data['class_sn']}</td>
<td>{$data['seme']}</td>
<td>{$data['subject']}</td>
<td>{$data['class_name']}</td>
<td>{$data['teacher']}</td>
<td>{$data['passwd']}</td>
<td>{$data['access']}</td>
<td><a href='
javascript:delete_func({$data['class_sn']})'>刪除</a> | <a href='add_class.php?class_sn={$data['class_sn']}&op=edit'>編輯</a></td>
</tr>";
}
$main.="</table>
";
theme("theme.html");
?>
