📄 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 + -