📄 mng_class_list_class_history.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>
<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_class_arrange_class.php">课堂管理</a> <span class="red"><strong>教学进度</strong></span></div></td>
<td width="100" 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="0" bordercolor="#DEE3EF">
<tr>
<td width="6%" height="24" background="images/top_bg.jpg">编号</td>
<td width="32%" height="24" background="images/top_bg.jpg"><a href="<?php echo $_SERVER['PHP_SELF']."?sort=title"; ?>">按课程顺序排序</a></td>
<td width="18%" height="24" background="images/top_bg.jpg"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">按班级顺序</a></td>
<td width="25%" height="24" background="images/top_bg.jpg"><a href="<?php echo $_SERVER['PHP_SELF']."?sort=time"; ?>">按时间顺序</a></td>
<td width="10%" height="24" background="images/top_bg.jpg">结束</td>
<td width="9%" height="24" background="images/top_bg.jpg">操作</td>
</tr>
<?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);
if(isset($_GET['action']) && $_GET['action']=="del"){
$sql="DELETE FROM lesson WHERE lid=".$_GET['lid'];
mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
echo "<p align=center><span class=red>报告：</span>刚才的教学记录已删除。</p>";
}
$sql ="SELECT lid,grade,class,time,end,title FROM lesson,course";
$sql.=" WHERE lesson.cid=course.cid";
if(!isset($_GET['sort']))
$sql.=" ORDER BY grade,class,time DESC";
else if($_GET['sort']=="title")
$sql.=" ORDER BY turn,grade,class";
else if($_GET['sort']=="time")
$sql.=" ORDER BY time DESC";
$result = mysql_query($sql,$db) or die("<b>$sql</b><br>" . mysql_error());
$i=1;
while($array=mysql_fetch_array($result)){
$time=$array['time'];
$del_msg="";
if($array['end']=="Y")
$del_msg="<a href=".$_SERVER['PHP_SELF']."?action=del&lid=".$array['lid']."&title=".$array['title'].">删除</a>";
echo "
<tr>
<td >$i</td>
<td >".$array['title']."</td>
<td >".$array['grade']."(".$array['class'].")班</td>
<td >$time</td>
<td >".$array['end']."</td>
<td>$del_msg</td>
</tr>";
$i++;
}
?>
</table>
<p> </p>
<table width="740" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#F7F3F7"><p> <a name="说明"></a>说明：</p>
<ul>
<li>教学进度作用：
<ul>
<li>向教师提供各班对比教学进度。</li>
<li>给学生登陆时提供课程和班级信息。</li>
</ul>
</li>
<li>删除已完成的教学任务不影响系统数据。</li>
</ul></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -