Tad 教材網 - 線上書籍

:::

\[1002\] PHP入門班
===============

```
<pre class="brush: php;" title="code">
<?php
//引入共同檔
require_once "header.php";

//變數初始化
$op=isset($_REQUEST['op'])?$_REQUEST['op']:"";
$class_sn=isset($_REQUEST['class_sn'])?intval($_REQUEST['class_sn']):"";

//流程控制
if($op=="delete"){
  //若op是刪除班級，則呼叫刪除班級函數
  delet_class($class_sn);
}else{
  //否則執行列出班級函數
  $main=list_class();
}

//套用樣板
theme("theme.html");

/*************** 功能函數區 **************/

//刪除班級
function delet_class($class_sn=null){

//設定SQL語法
  $sql="delete from `tncomu_class` where class_sn='{$class_sn}'";

//執行SQL語法
  mysql_query($sql) or die("無法執行：".mysql_error());

//執行完轉向
  header("location: index.php");
}

//列出所有班級
function list_class(){
  //設定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='java_script:delete_func({$data['class_sn']})'>刪除</a> | <a href='add_class.php?class_sn={$data['class_sn']}&op=edit'>編輯</a></td>
    </tr>";
  }
  
  $main.="</table>";
  
  return $main;
}

?>
```

:::