📄 mng_stu_list.php
字号:
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<title>学生管理-分班浏览学生信息</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>
<script language="javascript" src="ItAssisJS/java.js"></script>
</head>
<body>
<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" class="red"><strong>已注册学生</strong></a> <a href="mng_stu_mng_unregister.php">待注册学生</a> <a href="mng_stu_add_unregister.php">添加名单</a></div></td>
<td width="100" background="images/top_bg.jpg"><div align="left">[<a href="#explain">说明</a>]</div></td>
</tr>
</table>
<?php
include "config.inc.php";
include "ItAssisFC/FLib.php";
include "conn.inc.php";
$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);
$result_msg="";
//搜索学生
if(isset($_GET['action']) && $_GET['action']=="search"){
$sid=trim($_GET['sid']);
$sex=trim($_GET['sex']);
$sql ="select team,sid,pic,seat,identity from stu";
$condition[0]="";
if($sid!="姓名")
array_push($condition,"sid like \"%$sid%\"");
if($sex!="")
array_push($condition,"sex=\"$sex\"");
array_shift($condition);
$condition=implode(" and ", array_values($condition));
if($condition)
$sql.=" where $condition";
$sql.=" order by grade,class,sid";
$result2 = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
$num=mysql_num_rows($result2);
$result_msg="<strong><span class=red>$num</span></strong>个结果";
}//搜索学生结束
?>
<form name="form1" method="GET" >
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0" background="images/top_bg.jpg">
<tr>
<td height="20">
<input name="sid" type="text" value="<?php if(isset($_GET['sid'])) echo $_GET['sid'];else echo "姓名"; ?>" size="8">
<select name="sex" >
<option selected value="">性别</option>
<option value="男">男</option>
<option value="女">女</option>
</select>
<select name="menu" onChange="MM_jumpMenu('self',this,0)">
<option value=NULL>↓分班列出名单↓</option>
<?php
//显示班级列表
$sql ="select grade,class,count(*) as total from stu ";
$sql.="group by grade,class";
$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
while($array=mysql_fetch_array($result)){
$grade=$array['grade'];
$class=$array['class'];
$base_url="mng_stu_list.php?action=list&grade_class=$grade,$class";
echo "<option value=\"$base_url\">$grade($class)班[{$array['total']}人]</option>";}?>
</select>
<input name="search" type="image" src="images/search.gif" width="25" height="17" border="0">
<input name="action" type="hidden" value="search">
<?php echo $result_msg ?> </td>
</tr>
</table>
</form>
<table width="740" align="center">
<tr>
<td><table border="0" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF">
<tr>
<?php
//显示搜索学生结果
if(isset($num) && $num>0){
$i=1;
while($array=mysql_fetch_array($result2)){
$base_url="mng_stu_edit.php?sid=".$array['sid'];
$stu_msg=preg_replace("/$sid/","<span class=red>$sid</span>",$array['sid']);
$stu_msg="<a href=javascript:popUpWindow('$base_url',150,80,500,340) title=查看、修改学生资料>$stu_msg</a>";
if(!$array['pic']) $array['pic']="none.jpg";
$image_url="$CFG_STU_PHOTO_DIR/".$array['pic'];
if(bcmod($i++,13)!=0){
if($array['identity']==2)
$stu_msg.="<br>座[".$array['seat']."]";
else if($array['identity']==1)
$stu_msg.="<br>座[".$array['seat']."]<span class=blue>组</span>";
else if($array['identity']==0)
$stu_msg.="<br>座[".$array['seat']."]<span class=red>课</span>"; ?>
<td width="60"><table border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#FFD6AC">
<tr>
<td><div align="center"><img src="<?php echo $image_url;?>" width=50 height=60 border=0 align="middle"></div></td>
</tr>
<tr>
<td><p align="center"><?php echo $stu_msg ?> </p></td>
</tr>
</table></td>
<?php
}else
echo "</tr><tr>";
}//end while?>
</tr>
</table>
<?php
}//end if//显示搜索学生结果结束
//显示学生分组列表
if(isset($_GET['action']) && $_GET['action']=="list" && isset($_GET['grade_class'])){
list($grade,$class)=split(",",$_GET['grade_class']);
$sql ="select team,sid,pic,seat,identity from stu";
$sql.=" where grade=$grade AND class=$class";
$sql.=" ORDER BY team,seat";
$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
echo "<table><div align=center>$grade($class)班学生分组列表</div></table>";?>
<table border="0" cellpadding="0" cellspacing="1">
<tr>
<?php
$i=0;
$array=mysql_fetch_array($result);
do{
$bgc=$i%2==0?"#3399FF":"#33CCFF";
if($array['team']!=$i) {$i++;continue;}
?>
<td width="20" bgcolor="<?php echo $bgc ?>"><div align="center">
<p>第<br>
<?php echo $i ?><br>
组</p>
</div></td>
<?php
while($array['team']==$i && $array){
$base_url="mng_stu_edit.php?sid=".$array['sid'];
if(!$array['pic']) $array['pic']="none.jpg";
if(!isset($_SESSION['image']) || $_SESSION['image']=="on")
$img_msg="<img src=$CFG_STU_PHOTO_DIR/{$array['pic']} width=50 height=60 border=0 align=middle></a>";
else
$img_msg='';;
$name_msg="<a href=javascript:popUpWindow('$base_url',150,80,500,340) title=\"点击编辑学生档案\" >".$array['sid']."</a>";
if($array['identity']==2)
$name_msg.="<br>座[".$array['seat']."]";
else if($array['identity']==1)
$name_msg.="<br>座[".$array['seat']."]<span class=组长>组</span>";
else if($array['identity']==0)
$name_msg.="<br>座[".$array['seat']."]<span class=课代表>课</span>";
?>
<td width="60"><table border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#FFD6AC">
<tr>
<td><div align="center"><?php echo $img_msg;?></div></td>
</tr>
<tr>
<td><div align="center"><?php echo $name_msg;?></div></td>
</tr>
</table></td>
<?php
$array=mysql_fetch_array($result);
}//内部while结束
$i++;
?>
</tr>
<?php
}while($array and $i<=$CFG_USER_MAX_CLASS);//外部while结束
}//显示学生分组列表结束
?>
</table></td>
</tr>
</table>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F7F3F7"><p> <a name="说明"></a>说明：</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 + -