?? mng_stu_mng_unregister.php
字號:
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<title>EasyTeacher信息技術課堂教學助手(ItAssis)教師端-分班瀏覽學生信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="et.css" rel="stylesheet" type="text/css">
<style type="text/css">
body,td,th {font-size: 14px;}
</style>
</head>
<body>
<?php
include "config.inc.php";
include "conn.inc.php";
$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);
$sql="SELECT * FROM unregiester ORDER BY grade,class,name ";
$source=mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
//改變未注冊數據庫中學生注冊狀態
if(isset($_GET['action']) && $_GET['action']=="state"){
if($_GET['state']=='Y') $state='N'; else $state='Y';
$sql="UPDATE unregiester SET state=\"$state\" WHERE id=".$_GET['id'];
mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
echo "<p align=center ><span class=red>".$_GET['name']."</span>狀態已改變！</p>";
}
//刪除未注冊數據庫中學生名單
if(isset($_GET['action']) && $_GET['action']=="del"){
$sql="DELETE FROM unregiester WHERE id=".$_GET['id'];
mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
echo "<p align=center ><span class=red>".$_GET['name']."</span>已刪除！</p>";
}
?>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="30" background="images/top_bg.jpg"><div align="left"> 位于：<a href="mng_stu_list.php">已注冊學生</a> <strong class="red">待注冊學生[<?php echo "<strong><span class=red>".mysql_num_rows($source)."</span></strong>"; ?>人]</strong> <a href="mng_stu_add_unregister.php">添加名單</a></div></td>
<td width="99" background="images/top_bg.jpg"><div align="left">[<a href="#explain">說明</a>]</div></td>
</tr>
</table>
<br>
<table width=740 border="1" align=center cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor=#DEE3EF>
<tr bordercolor="#FFFFFF">
<td width="10%"><div align="center">編號</div></td>
<td width="12%"><div align="center">姓名</div></td>
<td width="14%"><div align="center">班級</div></td>
<td width="39%"><div align="center">注冊狀態[Y/N]</div></td>
<td width="25%"><div align="center">操作</div></td>
</tr>
<?php
$sql="SELECT * FROM unregiester ORDER BY grade,class,name ";
$source=mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
$i=1;
$self_url=$_SERVER['PHP_SELF'];
while($array=mysql_fetch_array($source)){
$state=$array['state'];
$id=$array['id'];
$name=$array['name'];
$grade=$array['grade'];
$class=$array['class'];
$state_url="$self_url?action=state&state=$state&id=$id&name=".urlencode($name);
$del_url="$self_url?action=del&id=$id&name=$name";
echo "
<tr bgcolor=#FFFFFF><td><div align=center>$i</div></td>
<td><div align=center>$name</div></td>
<td><div align=center>$grade($class)班</div></td>
<td><div align=center>[$state]<a href=$state_url>點擊改變狀態</a></div></td>
<td><div align=center><a href=$del_url>刪除</a></div></td></tr>";
$i++;
}
?>
</table>
<br>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F7F3F7"><p> 說明：</p>
<ul>
<li class="explain_hight">待注冊學生：在[管理名單]中有姓名，但不能使用從首頁登陸的。</li>
<li class="explain_hight">注冊學生：指從首頁成功注冊過身份的學生。</li>
<li class="explain_hight">學生注冊成功后自動從未注冊學生名單消失。</li>
</ul></td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -