list_unmark_papers.php

/admin/list_unmark_papers.php

https://bitbucket.org/swallow13/online_exam_system
PHP | 61 lines | 55 code | 2 blank | 4 comment | 9 complexity | 43cf972f97ba410b62f76db778e8fda3 MD5 | raw file

<?php



/**

 * @Alex Ai swallow13@163.com

 * @copyright 2009

 */

require_once("../include/auth_t.php");

require_once("../include/config.php");

require("../include/funs.php");

include("../include/head.htm");

?>

<body>

<h2>批阅试卷</h2>

<div>请选择：

<form name="choose" method="post" action="list_unmark_papers.php">

<select name="unmark" id="unmark">

<option value="0">所有试卷</option>

<?php

$qr = mysql_query("SELECT `paper_id`,`paper_title` FROM `gb_papers_warehouse` WHERE `paper_public` = '1';");

while ($v = mysql_fetch_array($qr)) {

	echo '<option value='.$v[0].'>'.$v[1].'</option>';	

} 

?>

</select>&nbsp;&nbsp;

<input type="submit" value="选择" /><input type="hidden" name="hooker" value="y" />

</form>

</div>

<div class="space30"></div>

<?php

if (isset($_POST['hooker'])) {

	$pid = $_POST['unmark'];

	if ($pid == 0) {

		$qr1 = mysql_query("SELECT `paper_id` FROM `gb_answer_papers` WHERE `status` = '0';");

		$qr2 = mysql_query("SELECT DISTINCT `paper_id` FROM `gb_answer_papers` WHERE `status` = '0';");

	} else {

		$qr1 = mysql_query("SELECT `paper_id` FROM `gb_answer_papers` WHERE `status` = '0' AND `paper_id` = '$pid';");

		$qr2 = mysql_query("SELECT DISTINCT `paper_id` FROM `gb_answer_papers` WHERE `status` = '0' AND `paper_id` = '$pid';");

	}

	

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

		echo "<b>没有符合条件的试卷。</b>";

	} else {

		echo '<table border="1" cellpadding="8" width="85%">';

		echo '<tr><td>试卷名称</td>';

		echo '<td>待阅考卷数量</td>';

		echo '<td>&nbsp;</td></tr>';

		while ($v1 = mysql_fetch_array($qr2)) {

			$qr3 = mysql_query("SELECT `paper_id` FROM `gb_answer_papers` WHERE `status` = '0' AND `paper_id` = '$v1[0]';");

			$T = mysql_result(mysql_query("SELECT `paper_title` FROM `gb_papers_warehouse` WHERE `paper_id` = '$v1[0]';"),0);

			echo '<tr><td>'.$T.'</td>';

			echo '<td>'.mysql_num_rows($qr3).' 份</td>';

			echo '<td><a href="mark.php?pid='.$v1[0].'" target="_blank">阅卷</a></td></tr>';

		}

		echo '</table>';

	}

}

include_once("../include/daohang.htm"); 

mysql_close($con);

?>

</body>

</html>