📄 stu_list_excellent_task.php

📁 在实际教学应用中
💻 PHP
字号:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>EasyTeacher信息技术课堂教学助手(ItAssis)学生端-优秀作业</title>
<link href="et.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body,td,th {
	font-size: 14px;
}
-->
</style>
</head>
<body>
<?php
	include "conn.inc.php";
	include "config.inc.php";
	
	$db=Connect_db($CFG_DB_ADDRESS,$CFG_DB_PORT,$CFG_DB_NAME,$CFG_DB_OWNER,$CFG_DB_PWD);

	if(isset($_GET['list']) && $_GET['list']=="newer"){	
		$sql="
			select sid,pic,grade,class,ofname,nfname,cid,title
			from stu,s_c_t,task,course
			where good=\"Y\" and stu_id=sid and tsk_id=tid and crs_id=cid
			order by sub_time desc
			limit $CFG_TASK_SHOW_GOOD_NUMS";
		$result=mysql_query($sql,$db) or die($sql."<br>".mysql_error());

		echo '<div id=demo style=overflow:hidden;height:100%;width:100%;><div id=demo1>';	
		while($array=mysql_fetch_array($result)){
 			$file_path="$CFG_TASK_DIR/{$array['cid']}/{$array['nfname']}";
			if(!$array['pic']) $array['pic']="none.jpg";
			echo "<img src=\"$CFG_STU_PHOTO_DIR/{$array['pic']}\" width=\"100\" height=\"120\"><br>";
			echo "作者：".$array['sid']."<br>
				  班级：".$array['grade']."(".$array['class'].")<br>
				  作品：<a href=\"$file_path\" target=\"_blank\">{$array['ofname']}</a><br><br>";
 		}
		echo '</div><div id=demo2></div>';

		echo 
			'<script>
			var speed=20
			demo2.innerHTML=demo1.innerHTML
			function Marquee(){
				if(demo2.offsetTop-demo.scrollTop<=0)
					demo.scrollTop-=demo1.offsetHeight
				else
					demo.scrollTop++
			}
		
			var MyMar=setInterval(Marquee,speed)
			demo.onmouseover=function() {clearInterval(MyMar)}
			demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}
			</script>';
	}
?>
<?php 
	if(isset($_GET['list'])  && $_GET['list']=="all"){ ?>
<div align="center"><img src="images/task_youxiuzuoye.jpg">
  <table width="740"  border="0" cellpadding="1" cellspacing="2" align=center>
    <?php
		$sql="
			select sid,pic,grade,class,ofname,nfname,cid,title
			from stu,s_c_t,task,course
			where good=\"Y\" and stu_id=sid and tsk_id=tid and crs_id=cid
			order by turn desc,sub_time desc";
		$result=mysql_query($sql,$db) or die($sql."<br>".mysql_error());
		
		$next_line=true;			//换行标志
		$pre_title="";				//上次课程名
		$nums_each_line=5;			//每行显示优秀作业数量
		$width=740/$nums_each_line;	//单元格宽度
		$first_title_printed=false; //第一个标题是否打印过标志
		$i=1;
		while($array=mysql_fetch_array($result)){
			if($pre_title=="")$pre_title=$array['title'];
			$pre_title==$array['title']?$next_line=false:$next_line=true;
			
			if($next_line || !$first_title_printed){
				if($first_title_printed)
					while($i++<=$nums_each_line) //补齐单元格
						echo "<td background=\"images/wait.jpg\" width=\"$width\" align=center>此位空缺<br>期待着你</td>";
				
				//打印标题行
				echo "<tr><td colspan=\"$nums_each_line\" >&nbsp;</td></tr>
					  <tr><td colspan=\"$nums_each_line\" background=\"images/bg.jpg\">〖{$array['title']}〗</td></tr>";
				$first_title_printed=true;
				$i=1;
			}
			
			//打印单元格
			$file_path="$CFG_TASK_DIR/{$array['cid']}/{$array['nfname']}";			
			echo "
				
				<td background=\"images/phbbeijing.jpg\" width=\"$width\" align=center><a href=\"$file_path\" target=\"_blank\">{$array['ofname']}</a><br>
			      作者：".$array['sid']."<br>班级：".$array['grade']."(".$array['class'].")</td>";
			if(++$i>$nums_each_line){echo "</tr><tr>";$i=1;}//换行

			$pre_title=$array['title'];
		}
		while($i++<=$nums_each_line) //补齐最后一行单元格
			echo "<td background=\"images/wait.jpg\" width=\"$width\" align=center >此位空缺<br>期待着你</td>";
	}
?>
  </table>
</div>
</body>
</html>
⌨️ 快捷键说明

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