query_items.php | searchcode

/admin/query_items.php

https://bitbucket.org/swallow13/online_exam_system
PHP | 198 lines | 180 code | 13 blank | 5 comment | 35 complexity | 47e246c1b997f61f58a158b434705003 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_once("../include/head.htm");



echo "</head><body><h3>以下是所有试题，试题的创建者可以编辑。</h3>";



if (!isset($_GET['QI_page'])) {

	$QI_page = 1;

	$QI_PAGE_SIZE = 10;

} else {

	$QI_page = intval($_GET['QI_page']);

	$QI_PAGE_SIZE = 10;

}



$ALL = mysql_num_rows(mysql_query("SELECT * FROM `gb_items_warehouse`;"));

$QI_PAGES = ceil($ALL/$QI_PAGE_SIZE);

$QI_OFFSET = $QI_PAGE_SIZE*($QI_page - 1);

$SQL = mysql_query("SELECT * FROM `gb_items_warehouse` ORDER BY `item_id` DESC LIMIT $QI_OFFSET,$QI_PAGE_SIZE;");



while ($ROW = mysql_fetch_array($SQL)) {

	switch($ROW[1]) {

		case 1:

		echo '<table border=1 cellspacing=5 cellpadding=8 width=90% align=center><tr>';

		echo '<td><b>题号ID：</b>'.$ROW[0].'</td>';

		$stem = mysql_query("SELECT `item_stem` FROM `gb_item_type1_stem` WHERE `item_id` = '$ROW[0]';");

		$option = mysql_query("SELECT * FROM `gb_item_type1_options` WHERE `item_id` = '$ROW[0]';");

		$image = mysql_query("SELECT `item_image` FROM `gb_item_image` WHERE `item_id` = '$ROW[0]';");

		$email = mysql_query("SELECT `email` FROM `gb_teachers_tb` WHERE `tea_id` = $ROW[6];");

		echo '<td>';

		echo '<span class=s14>'.mysql_result($stem,0,0).'</span> <span class=s12>(属 '.get_cat_name($ROW[2]).' 类别，分值：'.$ROW[3] .'分。由 <a href=mailto:'.mysql_result($email,0,0).'>'.$ROW[4].'</a> 于 '.$ROW[5].' 创建) </span>';

		echo '

		<table width=100% border=0>

      	<tr>

        <td width=20%><img src="';

		if (mysql_result($image,0,0) == '') {

			$image = "../pics/shift.gif";

		} else {

			$image = mysql_result($image,0,0);

		}

		echo $image;

		echo '		" class=pad /></td><td>';

		while ($myop = mysql_fetch_array($option)) {

			echo '<p>'.$myop[2].' '.$myop[1].'</p>';

		}

		echo '	</td>

      	</tr>

    	</table>

		';

		echo '</td>';

		echo '<td>';

		if ($ROW[6] == $_SESSION['uid']) {

			echo '<a href=edit_item.php?iid='.$ROW[0].'&cuid='.$ROW[6].'&itype='.$ROW[1].' target=_blank>编辑</a>';

		} else {

			echo '&nbsp;';

		}

		echo '</td>';

		echo '</tr></table>';

		break;

		

		case 2:

		echo '<table border=1 cellspacing=5 cellpadding=8 width=90% align=center><tr>';

		echo '<td><b>题号ID：</b>'.$ROW[0].'</td>';

		$stem = mysql_query("SELECT `item_stem` FROM `gb_item_type2_stem` WHERE `item_id` = '$ROW[0]';");

		$option = mysql_query("SELECT * FROM `gb_item_type2_options` WHERE `item_id` = '$ROW[0]';");

		$image = mysql_query("SELECT `item_image` FROM `gb_item_image` WHERE `item_id` = '$ROW[0]';");

		$email = mysql_query("SELECT `email` FROM `gb_teachers_tb` WHERE `tea_id` = $ROW[6];");

		echo '<td>';

		echo '<span class=s14>'.mysql_result($stem,0,0).'</span> <span class=s12>(属 '.get_cat_name($ROW[2]).' 类别，分值：'.$ROW[3] .'分。由 <a href=mailto:'.mysql_result($email,0,0).'>'.$ROW[4].'</a> 于 '.$ROW[5].' 创建) </span>';

		echo '

		<table width=100% border=0>

      	<tr>

        <td width=20%><img src="';

		if (mysql_result($image,0,0) == '') {

			$image = "../pics/shift.gif";

		} else {

			$image = mysql_result($image,0,0);

		}

		echo $image;

		echo '		" class=pad /></td><td>';

		while ($myop = mysql_fetch_array($option)) {

			echo '<p>'.$myop[2].' '.$myop[1].'</p>';

		}

		echo '	</td>

      	</tr>

    	</table>

		';

		echo '</td>';

		echo '<td>';

		if ($ROW[6] == $_SESSION['uid']) {

			echo '<a href=edit_item.php?iid='.$ROW[0].'&cuid='.$ROW[6].'&itype='.$ROW[1].' target=_blank>编辑</a>';

		} else {

			echo '&nbsp;';

		}

		echo '</td>';

		echo '</tr></table>';		

		break;

		

		case 3:

		echo '<table border=1 cellspacing=5 cellpadding=8 width=90% align=center><tr>';

		echo '<td><b>题号ID：</b>'.$ROW[0].'</td>';

		$stem = mysql_query("SELECT * FROM `gb_item_type3` WHERE `item_id` = '$ROW[0]' ORDER BY `sort_num`;");

		$image = mysql_query("SELECT `item_image` FROM `gb_item_image` WHERE `item_id` = '$ROW[0]';");

		$email = mysql_query("SELECT `email` FROM `gb_teachers_tb` WHERE `tea_id` = '$ROW[6]';");

		echo '<td>';

		$STR = '';

		while ($ss = mysql_fetch_array($stem)) {

			if ($ss[3] == 0) {

				$STR .= $ss[2];

			} else {

				$STR .= '<input type="text" class="blank" />';

			}

		}

		echo $STR.'<br /><span class=s12>(属 '.get_cat_name($ROW[2]).' 类别，分值：'.$ROW[3] .'分。由 <a href=mailto:'.mysql_result($email,0,0).'>'.$ROW[4].'</a> 于 '.$ROW[5].' 创建) </span><br />';

		

		echo '<img src="';

		if (mysql_result($image,0,0) == '') {

			$image = "../pics/shift.gif";

		} else {

			$image = mysql_result($image,0,0);

		}

		echo $image;

		echo '		" class=pad /><br />';



		echo '</td>';

		echo '<td>';

		if ($ROW[6] == $_SESSION['uid']) {

			echo '<a href=edit_item.php?iid='.$ROW[0].'&cuid='.$ROW[6].'&itype='.$ROW[1].' target=_blank>编辑</a>';

		} else {

			echo '&nbsp;';

		}

		echo '</td>';

		echo '</tr></table>';

		break;

		

		case 4:

		echo '<table border=1 cellspacing=5 cellpadding=8 width=90% align=center><tr>';

		echo '<td><b>题号ID：</b>'.$ROW[0].'</td>';		

		$stem = mysql_query("SELECT `item_type4_stem` FROM `gb_item_type4` WHERE `item_id` = '$ROW[0]';");

		$image = mysql_query("SELECT `item_image` FROM `gb_item_image` WHERE `item_id` = '$ROW[0]';");

		$email = mysql_query("SELECT `email` FROM `gb_teachers_tb` WHERE `tea_id` = $ROW[6];");

		echo '<td>';

		echo '<span class=s14>'.mysql_result($stem,0,0).'</span> <span class=s12>(属 '.get_cat_name($ROW[2]).' 类别，分值：'.$ROW[3] .'分。由 <a href=mailto:'.mysql_result($email,0,0).'>'.$ROW[4].'</a> 于 '.$ROW[5].' 创建) </span>';

		echo '

		<table width=100% border=0>

      	<tr>

        <td width=20%><img src="';

		if (mysql_result($image,0,0) == '') {

			$image = "../pics/shift.gif";

		} else {

			$image = mysql_result($image,0,0);

		}

		echo $image;

		echo '		" class=pad /></td><td>';

		//echo '<span class=s14>'.mysql_result($stem,0,0).'</span>';

		echo '	</td>

		</tr>

		</table>

		';

		echo '<td>';

		if ($ROW[6] == $_SESSION['uid']) {

			echo '<a href=edit_item.php?iid='.$ROW[0].'&cuid='.$ROW[6].'&itype='.$ROW[1].' target=_blank>编辑</a>';

		} else {

			echo '&nbsp;';

		}

		echo '</td>';

		echo '</tr></table>';						

		break;

	}

}



$first = 1;

$prev = $QI_page - 1;

$next = $QI_page + 1;

$last = $QI_PAGES;

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

echo "<div align=center>总共".$QI_PAGES."页&nbsp;&nbsp;";

if ($QI_page > 1) {

	echo "<a href='query_items.php?QI_page=".$first."'>首页</a>&nbsp;&nbsp;";

	echo "<a href='query_items.php?QI_page=".$prev."'>上一页</a>&nbsp;&nbsp;";

} 



if ($QI_page < $QI_PAGES) {

	echo "<a href='query_items.php?QI_page=".$next."'>下一页</a>&nbsp;&nbsp;";

	echo "<a href='query_items.php?QI_page=".$last."'>末页</a>";

}

echo "</div>";

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

echo "</body></html>";



mysql_close();

?>