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");

?>