/admin/edit_item.php

<?php



/**

 * @Alex Ai swallow13@163.com

 * @copyright 2009

 */

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

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

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

echo '<link href="../basic.css" rel="stylesheet" type="text/css" />';



if ($_SESSION['uid'] != $_GET['cuid']) {

	echo '您不是该题的创建者，不能编辑。';

	exit;

}

$iid = $_GET['iid'];

switch($_GET['itype']) {

	case 1:

	$qr1 = mysql_query("SELECT * FROM `gb_item_type1_stem` WHERE `item_id` = '$iid';");

	$qr2 = mysql_query("SELECT * FROM `gb_item_type1_options` WHERE `item_id` = '$iid';");

	$qr3 = mysql_query("SELECT * FROM `gb_item_std_answ` WHERE `item_id` = '$iid';");

	$qr4 = mysql_query("SELECT * FROM `gb_item_image` WHERE `item_id` = '$iid';");

	echo '<form action="update_item.php" method="post" enctype="multipart/form-data">';

	echo '<p>题干：<input name="stem" value="'.mysql_result($qr1,0,1).'" class="length" /></p>';

	

	if (mysql_result($qr4,0,1) == NULL) {

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

	} else {

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

	}

	echo '<p><img src="'.$image.'" /></p>';

	echo '更换图像(留空将保持原有的不变，图像文件应小于512K)：<br /><input type="file" name="item_image" /><input type="hidden" name="MAX_FILE_SIZE" value="524288" />';

		

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

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

		if ($myop[2] == $std_answ) {

			echo '<p><input type="radio" value="'.$myop[2].'" name="daan" checked="checked" /> <input type="text" name="t['.$myop[2].']" value="'.$myop[1].'" class="length" /></p>';

		} else {

			echo '<p><input type="radio" value="'.$myop[2].'" name="daan" /> <input type="text" name="t['.$myop[2].']" value="'.$myop[1].'" class="length" /></p>';

		}

	}

	

	//$AN_NUM = mysql_num_rows($qr2);

	//echo '<input type="hidden" name="an_num" value="'.$AN_NUM.'" />';	

	echo '<input type="hidden" name="iid" value="'.$iid.'" />';

	echo '<input type="hidden" name="itype" value="1" />';

	echo '<input type="submit" value="更改" />';

	echo '</form>';

	

	break;

	

	case 2:

	$qr1 = mysql_query("SELECT * FROM `gb_item_type2_stem` WHERE `item_id` = '$iid';");

	$qr2 = mysql_query("SELECT * FROM `gb_item_type2_options` WHERE `item_id` = '$iid';");

	$qr3 = mysql_query("SELECT * FROM `gb_item_std_answ` WHERE `item_id` = '$iid';");

	$qr4 = mysql_query("SELECT * FROM `gb_item_image` WHERE `item_id` = '$iid';");

	echo '<form action="update_item.php" method="post" enctype="multipart/form-data">';

	echo '<p>题干：<input name="stem" value="'.mysql_result($qr1,0,1).'" class="length" /></p>';

	

	if (mysql_result($qr4,0,1) == NULL) {

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

	} else {

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

	}

	echo '<p><img src="'.$image.'" /></p>';

	echo '更换图像(留空将保持原有的不变，图像文件应小于512K)：<br /><input type="file" name="item_image" /><input type="hidden" name="MAX_FILE_SIZE" value="524288" />';

	

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

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

		if (strpos($std_answ,$myop[2]) === false) {

			echo '<p><input type="checkbox" name=daan[] value="'.$myop[2].'" /><input type="text" name="t['.$myop[2].']" value="'.$myop[1].'" /></p>';

		} else {

			echo '<p><input type="checkbox" name=daan[] value="'.$myop[2].'" checked="checked" /><input type="text" name="t['.$myop[2].']" value="'.$myop[1].'" /></p>';

		}

	}

	

	//$AN_NUM = mysql_num_rows($qr2);

	//echo '<input type="hidden" name="an_num" value="'.$AN_NUM.'" />';		

	echo '<input type="hidden" name="iid" value="'.$iid.'" />';

	echo '<input type="hidden" name="itype" value="2" />';

	echo '<input type="submit" value="更改" />';

	echo '</form>';	

	

	break;

	

	case 3:

	$qr1 = mysql_query("SELECT * FROM `gb_item_type3` WHERE `item_id` = '$iid' ORDER BY `sort_num`;");

	$qr2 = mysql_query("SELECT * FROM `gb_item_image` WHERE `item_id` = '$iid';");

	echo '<form action="update_item.php" method="post" enctype="multipart/form-data">';

	$TK_STR = '<p>';

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

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

			$TK_STR .= '<input type="text" class="xuxian" value="'.$ss[2].'" name="g['.$ss[1].']" />';

		} else {

			$re = mysql_query("SELECT * FROM `gb_item_type3_reffer` WHERE `item_id` = '$iid' AND `sort_num` = '$ss[1]';");

			$TK_STR .= '<input type="text" class="blank" value="'.mysql_result($re,0,2).'" name="k['.$ss[1].']" />';

		}

	}

	echo $TK_STR.'</p>';

	echo '<p><img src="';

	if (mysql_result($qr2,0,1) == '') {

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

	} else {

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

	}

	echo $image;

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

	echo '<p>更换图像(留空将保持原有的不变，图像文件应小于512K)：<br /><input type="file" name="item_image" /><input type="hidden" name="MAX_FILE_SIZE" value="524288" /></p>';	

	

	//$AN_NUM = mysql_num_rows($qr1);

	//echo '<input type="hidden" name="an_num" value="'.$AN_NUM.'" />';		

	echo '<input type="hidden" name="iid" value="'.$iid.'" />';

	echo '<input type="hidden" name="itype" value="3" />';

	echo '<p><input type="submit" value="更改" /></p>';

	echo '</form>';		

	break;

	

	case 4:

	$qr1 = mysql_query("SELECT * FROM `gb_item_type4` WHERE `item_id` = '$iid';");

	$qr2 = mysql_query("SELECT * FROM `gb_item_image` WHERE `item_id` = '$iid';");

	echo '<form action="update_item.php" method="post" enctype="multipart/form-data">';

	echo  mysql_result($qr1,0,1).'<br />';

	echo '修改为：<br />';

	echo '<textarea name="stem" class="length" rows="30">'.mysql_result($qr1,0,1).'</textarea>';

	

	if (mysql_result($qr2,0,1) == NULL) {

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

	} else {

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

	}

	echo '<p><img src="'.$image.'" /></p>';

	echo '更换图像(留空将保持原有的不变，图像文件应小于512K)：<br /><input type="file" name="item_image" /><input type="hidden" name="MAX_FILE_SIZE" value="524288" />';

	

	echo '<br /><br />参考答案：<br />'.mysql_result($qr1,0,2);

	echo '修改为：<br />';

	echo '<textarea name="reffer" class="length" rows="30">'.mysql_result($qr1,0,2).'</textarea>';

	

	echo '<input type="hidden" name="iid" value="'.$iid.'" />';

	echo '<input type="hidden" name="itype" value="4" />';

	echo '<p><input type="submit" value="更改" /></p>';

	echo '</form>';

	

	break;

}

?>