📄 score_query.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>成绩查看</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$connection = openconnection( );
$query = "SELECT count(*) from EXAM_DATA WHERE PARTICIPANT='".$LOGIN_USER_ID."' and FLOW_ID={$FLOW_ID}";
$cursor = exequery( $connection, $query );
$ONLINE_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$ONLINE_COUNT = $ROW[0];
}
if ( $ONLINE_COUNT == 0 )
{
echo "<table class=\"TableList\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/test.gif\" align=\"absmiddle\"><span class=\"big3\"> 考试成绩查询 - ";
echo $PAPER_TITLE;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r\n";
message( "", "未参加考试" );
echo "<div align=center>\r\n<br>\r\n <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='index.php?CUR_PAGE=\$CUR_PAGE'\">\r\n</div>\r\n";
exit( );
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/test.gif\" align=\"absmiddle\"><span class=\"big3\"> 考试成绩查询</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n<table border=\"0\" width=\"100%\" class=\"TableList\">\r\n <tr class=\"TableHeader\">\r\n <td nowrap align=\"center\">考试时间</td>\r\n <td nowrap align=\"center\">考试名称</td>\r\n <td nowrap align=\"center\">满分</td>\r\n <td nowrap align=\"center\">成绩</td>\r\n </tr>\r\n\r\n";
$query = "SELECT distinct FLOW_TITLE,PAPER_GRADE,QUESTIONS_COUNT,SCORE,RANK_DATE from EXAM_DATA,EXAM_PAPER,EXAM_FLOW WHERE EXAM_DATA.PARTICIPANT='".$LOGIN_USER_ID."' and EXAM_FLOW.PAPER_ID=EXAM_PAPER.PAPER_ID and EXAM_DATA.FLOW_ID={$FLOW_ID} and EXAM_FLOW.FLOW_ID={$FLOW_ID} order by RANK_DATE desc";
$cursor = exequery( $connection, $query );
$ONLINE_COUNT = 0;
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$FLOW_TITLE = $ROW['FLOW_TITLE'];
$PAPER_GRADE = $ROW['PAPER_GRADE'];
$QUESTIONS_COUNT = $ROW['QUESTIONS_COUNT'];
$RANK_DATE = $ROW['RANK_DATE'];
$SCORE = $ROW['SCORE'];
$SCORE_ARRAY = explode( ",", $SCORE );
$COUNT = count( $SCORE_ARRAY );
$SUM = 0;
$i = 0;
$i = 0;
for ( ; $i < $COUNT; ++$i )
{
$SUM += $SCORE_ARRAY[$i];
}
$SUMSCORE = $PAPER_GRADE * $SUM / $QUESTIONS_COUNT;
$SUMSCORE = round( $SUMSCORE, 2 );
echo " <tr class=\"TableLine1\">\r\n <td nowrap align=\"center\" >";
echo $RANK_DATE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $FLOW_TITLE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $PAPER_GRADE;
echo "</td>\r\n <td nowrap align=\"center\">";
echo $SUMSCORE;
echo "</td>\r\n </tr>\r\n";
}
echo "\r\n</table>\r\n</body>\r\n\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -