query_answ_paper.php

/query_answ_paper.php

https://bitbucket.org/swallow13/online_exam_system
PHP | 51 lines | 31 code | 6 blank | 14 comment | 0 complexity | a0abb34d34eb4c0a15991f6fd7d043eb MD5 | raw file

<?php



/**

 * @Alex Ai swallow13@163.com

 * @copyright 2009

 */

require_once("include/auth.php");

require_once("include/config.php");

require("include/normal_funs.php");

include("include/head1.htm");



/*$keyword = $_POST['keyword'];



$qr = mysql_query("SELECT * FROM `gb_answer_papers` WHERE `keyword` = '$keyword';");

if (mysql_num_rows($qr) == 0) {

	echo '<script>alert("没有找到与您的KEYWORD对应的考卷！请检查您的KEYWORD是否输入正确");window.location.href="login.php";</script>';

	exit;

}*/

$answ_id = $_GET['id'];

$qr = mysql_query("SELECT * FROM `gb_answer_papers` WHERE `id` = '$answ_id';");

/*$uid = mysql_result($qr,0,stu_id);

$qr1 = mysql_query("SELECT * FROM `gb_students_tb` WHERE `stu_id` = '$uid';");

$gid = mysql_result($qr1,0,group);*/



echo "</head><body><p>

<table border=1 cellspacing=1 cellpadding=8 width=80%>

<tr><td>";

$D = getdate(mysql_result($qr,0,4));

$pid = mysql_result($qr,0,1);

$qr2 = mysql_query("SELECT * FROM `gb_papers_warehouse` WHERE `paper_id` = '$pid';");

$TITLE = mysql_result($qr2,0,1);

$FULLSCORE = mysql_result($qr2,0,5);

$qr3 = mysql_query("SELECT `score1`,`score2`,`total`,`score3`,`score4` FROM `gb_answ_score` WHERE `id` = '$answ_id';");

$SCORE = mysql_result($qr3,0,2);

$SCORE1 = mysql_result($qr3,0,0);

$SCORE2 = mysql_result($qr3,0,1);

$SCORE3 = mysql_result($qr3,0,3);

$SCORE4 = mysql_result($qr3,0,4);

echo "<p>".$_SESSION['cname']." 于 ".$D[year]."年".$D[mon]."月".$D[mday]."日完成的 ".$TITLE." 测试，得分为 ".$SCORE." 分。（总分".$FULLSCORE."分）</p>";

echo "<p>其中，单选题得分 ".$SCORE1." 分，多选题得分 ".$SCORE2." 分，填空题 ".$SCORE3." 分，简答题 ".$SCORE4." 分。</p>";



echo "</td></tr></table><p>&nbsp;</p>";



$arr = explode(",",mysql_result($qr2,0,3));

view_result($arr,$answ_id);

echo "<a href=index.php>返回</a>";



mysql_close($con);

?>

</body>

</html>