<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><title></title>
<style type="text/css">
<!--
body { font-family:Verdana,Tahoma,Arial;font-size:12px;text-align:center;line-height:3em;}
table { border:1px solid #C4D2DB;border-collapse:collapse;background-color:#F1F5F8;margin-bottom:50px;}
table td{ border:1px solid #C4D2DB;border-collapse:collapse;}
h1 { font-size:14px;}
div#select_wrapper { width:500px;height:50px;line-height:50px;}
-->
</style>
<script type="text/javascript">
function hideLayer(Obj,value) //科目id要从1递增,否则会出错
{
var len = Obj.length;
var tableLayer = document.getElementById("course"+value);
for(var i = 1;i <= len;i++)
document.getElementById("course"+i).style.display = "none";
tableLayer.style.display = "block";
}
</script>
</head>
<body>
<?php
require("inc/mysql.class.php");
$action = $_GET['action'];
$id = $_GET['id'];
$cid = $_GET['cid']?$_GET['cid']:0;
switch($action)
{
case "depart": $id--;order_by_department($id,$cid);break;
case "class": order_by_class($id,cid);break;
case "prize": order_by_prize($id,cid);break;
default : echo "没有参数";
}
//order_by_department(1);
function template()
{
$query = new DF_MySQL;
$department_id = $query->OneCol("select id from stu_department"); //得到学院ID数组
$department_name = $query->OneCol("select name from stu_department"); //得到学院名称数组
$course_id = $query->OneCol("select id from stu_course"); //得到课程ID数组
$course_name = $query->OneCol("select name from stu_course"); //得到课程名称数组
for($i = 0;$i < $query->RowsNum("select id from stu_department");$i++){ //从学院ID为0开始
$student_num = $query->RowsNum("select distinct stu_id from stu_grade where department_id=$department_id[$i]"); //得到当前学院下的学生人数
for($j = 0;$j < $query->RowsNum("select id from stu_course");$j++){ //从课程ID为0开始
$num[$i][$j][0] = $query->RowsNum("select grade from stu_grade where department_id=$department_id[$i] and course_id=$course_id[$j] and grade>=90");//高等数学优秀的人数
$percent[$j][0] = round($num[$i][$j][0]/$student_num*100);
$num[$i][$j][1] = $query->RowsNum("select grade from stu_grade where department_id=$department_id[$i] and course_id=$course_id[$j] and grade>=60");//高等数学及格的人数
$percent[$j][1] = round($num[$i][$j][1]/$student_num*100);
$num[$i][$j][2] = $query->RowsNum("select grade from stu_grade where department_id=$department_id[$i] and course_id=$course_id[$j] and grade<60");//高等数学不及格的人数
$percent[$j][2] = round($num[$i][$j][2]/$student_num*100);
}
}
for($i = 0;$i < $query->RowsNum("select id from stu_department");$i++){ //从学院ID为0开始
echo ($i+1)."院 $department_name[$i]的成绩统计:<br />";
for($j = 0;$j < $query->RowsNum("select id from stu_course");$j++){ //从课程ID为0开始
echo "<table width=\"500\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo " <tr>";
echo " <td rowspan=\"3\">科目名:".$course_name[$j]."</td>";
echo " <td>优秀的人数为:".$num[$i][$j][0]."优秀率为:".$percent[$j][0]."%</td>";
echo " </tr>";
echo " <tr>";
echo " <td>及格的人数为:".$num[$i][$j][1]."及格率为:".$percent[$j][1]."%</td>";
echo " </tr>";
echo " <tr>";
echo " <td>不及格的人数为:".$num[$i][$j][2]."不及格率为:".$percent[$j][2]."%</td>";
echo " </tr>";
echo "</table>";
}
}
$query->Close();
}
////////////////////按学院统计开始/////////////////////////////
function order_by_department($get_department_id,$get_course_id=0)//默认显示全部课程记录
{
$query = new DF_MySQL;
$department_id = $query->OneCol("select id from stu_department"); //得到学院ID数组
$department_name = $query->OneCol("select name from stu_department"); //得到学院名称数组
$course_id = $query->OneCol("select id from stu_course"); //得到课程ID数组
$course_name = $query->OneCol("select name from stu_course"); //得到课程名称数组
$i = $get_department_id; //从参数中接收到学院ID
$student_num = $query->RowsNum("select distinct stu_id from stu_grade where department_id=$i"); //得到当前学院下的学生人数
$length = ($get_course_id==0)?$query->RowsNum("select id from stu_course"):$query->RowsNum("select id from stu_course where id=$get_course_id");
for($j = 0;$j < $length;$j++){ //从课程ID为0开始
$num[$j][0] = $query->RowsNum("select grade from stu_grade where department_id=$i and course_id=$course_id[$j] and grade>=90");//高等数学优秀的人数
$percent[$j][0] = ($student_num!=0)?(round($num[$j][0]/$student_num*100)):0;
$num[$j][1] = $query->RowsNum("select grade from stu_grade where department_id=$i and course_id=$course_id[$j] and grade>=60");//高等数学及格的人数
$percent[$j][1] = ($student_num!=0)?(round($num[$j][1]/$student_num*100)):0;
$num[$j][2] = $query->RowsNum("select grade from stu_grade where department_id=$i and course_id=$course_id[$j] and grade<60");//高等数学不及格的人数
$percent[$j][2] = ($student_num!=0)?(round($num[$j][2]/$student_num*100)):0;
}
echo "<h1>".($i+1)."院 $department_name[$i]的成绩统计:</h1>";
echo "<div id=\"select_wrapper\">";
echo "按科目筛选: <select name=\"select\" onchange=\"hideLayer(this,this.value)\">\r\n";
for($i = 0;$i < count($course_id);$i++){
echo "<option value=\"$course_id[$i]\">$course_name[$i]</option>\r\n";
}
echo "</select>\r\n";
echo "</div>\r\n";
for($j = 0;$j < $query->RowsNum("select id from stu_course");$j++){ //从课程ID为0开始
echo "<table width=\"500\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" id=\"course$course_id[$j]\">";
echo " <tr>";
echo " <td rowspan=\"3\">科目名:".$course_name[$j]."</td>";
echo " <td>优秀的人数为:".$num[$j][0]."优秀率为:".$percent[$j][0]."%</td>";
echo " </tr>";
echo " <tr>";
echo " <td>及格的人数为:".$num[$j][1]."及格率为:".$percent[$j][1]."%</td>";
echo " </tr>";
echo " <tr>";
echo " <td>不及格的人数为:".$num[$j][2]."不及格率为:".$percent[$j][2]."%</td>";
echo " </tr>";
echo "</table>";
}
$query->Close();
}
////////////////////按学院统计结束/////////////////////////////
////////////////////按班级统计开始/////////////////////////////
function order_by_class($get_class_id,$get_course_id=0)
{
$query = new DF_MySQL;
$class_id = $query->OneCol("select id from stu_class"); //得到班级ID数组
$class_name = $query->OneCol("select name from stu_class"); //得到班级名称数组
$current_class_name = $query->OneCol("select name from stu_class where id=$get_class_id"); //得到当前班级名称
$course_id = $query->OneCol("select id from stu_course"); //得到课程ID数组
$course_name = $query->OneCol("select name from stu_course"); //得到课程名称数组
$student_num = $query->RowsNum("select distinct stu_id from stu_grade where class_id=$get_class_id"); //得到当前班级下的学生人数
$length = ($get_course_id==0)?$query->RowsNum("select id from stu_course"):$query->RowsNum("select id from stu_course where id=$get_course_id");
for($j = 0;$j < $length;$j++){ //从课程ID为0开始
$num[$j][0] = $query->RowsNum("select grade from stu_grade where class_id=$get_class_id and course_id=$course_id[$j] and grade>=90");//高等数学优秀的人数
$percent[$j][0] = ($student_num!=0)?(round($num[$j][0]/$student_num*100)):0;
$num[$j][1] = $query->RowsNum("select grade from stu_grade where class_id=$get_class_id and course_id=$course_id[$j] and grade>=60");//高等数学及格的人数
$percent[$j][1] = ($student_num!=0)?(round($num[$j][1]/$student_num*100)):0;
$num[$j][2] = $query->RowsNum("select grade from stu_grade where class_id=$get_class_id and course_id=$course_id[$j] and grade<60");//高等数学不及格的人数
$percent[$j][2] = ($student_num!=0)?(round($num[$j][2]/$student_num*100)):0;
}
echo "<h1>$current_class_name[0]的成绩统计:</h1>";
echo "<div id=\"select_wrapper\">";
echo "按科目筛选: <select name=\"select\" onchange=\"
学生成绩统计系统[PHP+Mysql]
4星 · 超过85%的资源 需积分: 50 153 浏览量
2009-06-27
21:55:54
上传
评论 6
收藏 79KB RAR 举报 
Stu_Sta_System.rar （13个子文件） 
inc 
backup.php 2KB
restore.html 912B restore.php 532B mysql.class.php 4KB query.php 10KB student.sql 3KB images 
title_index.png 5KB
logo.jpg 61KB left.png 2KB js prototype.js 48KB global.css 549B index.html 639B left.php 7KB
- 1
- 2
- 3
前往页