⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 mng_class_mng_class.php

📁 在实际教学应用中
💻 PHP
字号:
<?php session_start(); if(!$_SESSION['teacher']) {echo '<SCRIPT LANGUAGE="JavaScript">location.replace(\'mng.php\');</script>';exit;}?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>EasyTeacher信息技术课堂教学助手(ItAssis)-实时课堂管理</title>
<meta http-equiv="refresh" content="120">
<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>
<h2 align="center" class="red"><a name="top"></a>实时课堂管理</h2>
<p>  
<?php 
	include "conn.inc.php";
	include "config.inc.php";
	include "ItAssisFC/FLib.php";
	$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);

	$lid=$_GET['lid'];
	$sql="SELECT course.cid,title,url_tch,url_stu,grade,class FROM course,lesson";
	$sql.=" WHERE course.cid=lesson.cid and lid=$lid and end='N'"; 
	$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());

	if(!mysql_num_rows($result)) {echo "课堂已结束!";exit;}

	$array=mysql_fetch_array($result);
	$grade=$array['grade'];
	$class=$array['class'];
	$cid=$array['cid'];

	$url_tch="";$url_stu="";
	$array2=@split(",|,",$array['url_tch']);
		for($i=1;$url=current($array2);$i++)
			{$url_tch.="<a href=\"http://$url\" target=_blank>教案$i</a>&nbsp;";next($array2);}

	$array2=@split(",|,",$array['url_stu']);
		for($i=1;$url=current($array2);$i++)
			{$url_stu.="<a href=\"http://$url\" target=_blank>学案$i</a>&nbsp;";next($array2);}


 ?>
</p>
<div align="center">上课班级: <?php echo "$grade($class)"; ?>班 &nbsp;课程:〖<?php echo $array['title']; ?>〗&nbsp;&nbsp;<?php echo $url_tch;?>&nbsp;&nbsp;<?php echo $url_stu;?>&nbsp;&nbsp;<a href="#count">课堂统计</a>&nbsp;
<a href="<?php echo $_SERVER['PHP_SELF']."?lid=$lid" ?>">刷新</a></div>
<hr color="#FF0000">

<?php
	$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());
	?>
	<table border="1" cellpadding="0" cellspacing="0" bordercolor="#ADB6CE">
	  <tr>
   	<?php
	$i=0;
	$array=mysql_fetch_array($result);
	$MAX_TEAM=50;//每班最大编组数,防止死循环
	do{
       	$bgc=$i%2==0?"#FFFFEE":"#FFFFDD";
		if($array['team']!=$i) {$i++;continue;}
		?>
		<td width="42" bgcolor="<?php echo $bgc ?>"><div align="center">
			<p>第<br><?php echo $i ?><br>组</p>
		  </div></td>
		<?php
		//如果不设$array条件,当所有记录分组号都为0或NULL时,就会造成死循环
		while($array['team']==$i && $array){
			$base_url="mng_class_give_express.php?cid=$cid&sid=".$array['sid'];
			$edit_url="mng_stu_edit.php?sid=".$array['sid'];
			if(!$array['pic']) $array['pic']="none.jpg";
			$image_url="$CFG_STU_PHOTO_DIR/".$array['pic'];
				
			if(!isset($_SESSION['image']) || $_SESSION['image']){//默认为打开头像?>
				<td align="center" bgcolor="<?php echo $bgc ?>"><table width="50" height="60"  border="1" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#FFD6AC">
					<tr>
					  <td height="64"><div align="center"><a href=javascript:popUpWindow('<?php echo $base_url;?>',250,150,300,300)><img src="<?php echo $image_url;?>" alt="作出课堂评价" width=50 height=60 border=0 align="middle"></a></div></td>
					</tr>
					<tr>
					  <td><p align="center">
						  <?php		 
							if($array['identity']==2)
								echo "<a href=javascript:popUpWindow('$edit_url',150,80,500,340) title=查看、修改个人资料>".$array['sid']."</a><br>座[".$array['seat']."]";
							else if($array['identity']==1)
								echo "<a href=javascript:popUpWindow('$edit_url',150,80,500,340) title=查看、修改个人资料>".$array['sid']."</a><br>座[".$array['seat']."]<span class=组长>组</span>";
							else if($array['identity']==0)
								echo "<a href=javascript:popUpWindow('$edit_url',150,80,500,340) title=查看、修改个人资料>".$array['sid']."</a><br>座[".$array['seat']."]<span class=课代表>课</span>";?>
						  </span></p></td>
					</tr>
				  </table></td>
		    <?php	
			}else{//关闭头像
				echo "<td><div align=center><a href=javascript:popUpWindow('$base_url',250,150,300,300) title=作出课堂评价>".$array['sid']."</a><br>";
				if($array['identity']==2)
					echo "<a href=javascript:popUpWindow('$edit_url',150,80,500,340) title=查看、修改个人资料>"."</a><br>座[".$array['seat']."]";
				else if($array['identity']==1)
					echo "<a href=javascript:popUpWindow('$edit_url',150,80,500,340) title=查看、修改个人资料>"."</a><br>座[".$array['seat']."]<span class=组长>组</span>";
				else if($array['identity']==0)
					echo "<a href=javascript:popUpWindow('$edit_url',150,80,500,340) title=查看、修改个人资料>"."</a><br>座[".$array['seat']."]<span class=课代表>课</span>"; 
				echo " </div></td>";
			}//头像控制结束
				
			$array=mysql_fetch_array($result);
		}//内部while结束
		$i++;
		?>
	  </tr>
	<?php
	}while($array and $i<=$MAX_TEAM);//外部while结束
	//显示学生列表结束

 	$online_class=$grade."_".$class;
	$sql="select * from $online_class";
	$result=mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
	$totle_stu_num=mysql_num_rows($result);

	$absent_stu_name="";	$absent_stu_num=0;
	$unupload_stu_name="";	$unupload_stu_num=0;
	while($array=mysql_fetch_array($result)){
		if($array['login']=="N") {$absent_stu_name.=$array['sid']."&nbsp;&nbsp;";$absent_stu_num++;}
		if($array['upload']=="N") {$unupload_stu_name.=$array['sid']."&nbsp;&nbsp;";$unupload_stu_num++;}
	}
?>
</table>
    <p align="center">点头像可对该生作课堂表现评价 本页面每2分钟自动刷新</p>
    <p><a name="count"></a>[课堂统计] [<a href="#top">回到顶端</a>]</p>
    <table border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ADB6CE">
  <tr>
    <td width="73" rowspan="2">考勤统计:</td>
    <td width="674">实到人数:<span class="red"><?php echo $totle_stu_num-$absent_stu_num;?></span></td>
  </tr>
  <tr>
    <td>未登陆名单:<?php echo $absent_stu_name; ?></td>
  </tr>
  <tr>
    <td rowspan="2">作业统计:</td>
    <td>已交人数:<span class="red"><?php echo  $totle_stu_num-$unupload_stu_num;?></span></td>
  </tr>
  <tr>
    <td>未交人员名单:<?php echo $unupload_stu_name; ?></td>
  </tr>
</table>
<hr>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -