芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/question_edit.php

<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<script src="ckeditor/ckeditor.js"></script>
<?php
/*---For Add---*/
$question_id = $_REQUEST['id'];
if(empty($_POST['submit'])){ $_POST['submit']=''; }
if($_POST['submit'] == 'Save'){
	/*include("image_file.php");
	
	if($_FILES['filename']['name']!='')
  {
	$src_subscription_form=$_FILES['filename']['tmp_name'];
	$dest_subscription_form=time().$_FILES['filename']['name'];
	$dest_subscription_form1="upload_file/".$dest_subscription_form;
	//exit;
	 copy($src_subscription_form,$dest_subscription_form1);
  }
  */
	/*----check username----*/
	$chksql = "select `id` from `exam_question_answers_reasons` where `question`='".$_POST['bodyar11']."'";
	$chkqry = mysql_query($chksql);
	$getRow = mysql_num_rows($chkqry);
	/*----end username check-*/
		if($_POST['bodyar11'] == ''){
			$error = 'Please enter question.';
		}
		else
		{
			
			$paper_assign_year = mysql_fetch_array(mysql_query("SELECT * FROM `exam_paper` WHERE `id`='".$_POST['paper_id']."'"));
						
			
			$insSql = "update `exam_question_answers_reasons` set ";
			$insSql .= "exam_board_id='".mysql_real_escape_string($_POST['exam_board_id'])."', ";
			$insSql .= "subject_id='".mysql_real_escape_string($_POST['subject_id'])."', ";
			$insSql .= "paper_id='".mysql_real_escape_string($_POST['paper_id'])."', ";			$insSql .= "topic_id='".mysql_real_escape_string($_POST['topic'])."', ";			$insSql .= "sub_topic_id='".mysql_real_escape_string($_POST['sub-topic'])."', ";
			 $insSql .= "question='".mysql_real_escape_string($_POST['bodyar11'])."', ";
			 $insSql .= "ans1='".mysql_real_escape_string($_POST['bodyar12'])."', ";
			 $insSql .= "ans2='".mysql_real_escape_string($_POST['bodyar13'])."', ";
			 $insSql .= "ans3='".mysql_real_escape_string($_POST['bodyar14'])."', ";
			 $insSql .= "ans4='".mysql_real_escape_string($_POST['bodyar15'])."', ";
			 $insSql .= "ans5='".mysql_real_escape_string($_POST['bodyar16'])."', ";
			 $insSql .= "reasons1='".mysql_real_escape_string($_POST['reason1'])."', ";
			  $insSql .= "reasons2='".mysql_real_escape_string($_POST['reason2'])."', ";
			   $insSql .= "reasons3='".mysql_real_escape_string($_POST['reason3'])."', ";
			    $insSql .= "reasons4='".mysql_real_escape_string($_POST['reason4'])."', ";
				 $insSql .= "reasons5='".mysql_real_escape_string($_POST['reason5'])."', ";
			 $insSql .= "correct_ans='".mysql_real_escape_string($_POST['ans'])."', ";
			 $insSql .= "post_date='".$paper_assign_year['assign_year']."', ";
			 $insSql .= "status='".$_POST['status']."', ";
			 $insSql .= "modify_date=now() where id = '".$question_id."' ";
			 
		   //echo $insSql;exit;

mysql_query($insSql);

//include("mailuser.php");

header('location:question.php?success=3&page='.$_REQUEST['page'].'');

exit();
		}

}

else{

$_POST['name']='';

}
/*---End Add---*/

?>
<script>
function showsubject(str) {
	
	//alert(str);
    if (str == "") {
        document.getElementById("txtHint").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                document.getElementById("txtHint").innerHTML = xmlhttp.responseText;
            }
        }
        xmlhttp.open("GET","getsubject1.php?q="+str,true);
        xmlhttp.send();
    }
}
function showpaper(str1) {
	
	//alert(str1);
    if (str1 == "") {
        document.getElementById("txtHint1").innerHTML = "";
        return;
    } else {
        if (window.XMLHttpRequest) {
            // code for IE7+, Firefox, Chrome, Opera, Safari
            xmlhttp = new XMLHttpRequest();
        } else {
            // code for IE6, IE5
            xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
        }
        xmlhttp.onreadystatechange = function() {
            if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
                document.getElementById("txtHint1").innerHTML = xmlhttp.responseText;
            }
        }
        xmlhttp.open("GET","getpaper.php?q="+str1,true);
        xmlhttp.send();
    }
}

</script>
<script>

function formSub(){

//alert(11111111);

document.formID.submit();

return true;
}
jQuery.noConflict();

(function($) {jQuery(document).ready(function(){

// binds form submission and fields to the validation engine
	/*$('#formID').on('change','#paper_id', function(){
		paper_id=$(this).val();	
		subject_id=$("#form-validation-field-0").val();	
		//alert(subject_id);
			$.ajax({	
				type: "POST",	
				url: "paper_topic.php",		
				data: { paper_id:paper_id,subject_id:subject_id},	
					success:function(data){	
					$("#select_topic").html(data);	
				}	
			});
		});*/
		$('#formID').on('change','#select_topic', function(){	
			topic_id=$(this).val();	
			//alert(topic_id);	
			$.ajax({	
				type: "POST",	
				url: "sub_topic.php",	
				data: { topic_id:topic_id},		
					success:function(data){			
					$("#sub_topic").html(data);	
				}
			});	
		});
	jQuery("#formID").validationEngine('attach', {

onValidationComplete: function(form, status){

//alert("The form status is: " +status+", it will never submit");

if(status == true){

//$('input[type="submit"]').attr('disabled','disabled');

return formSub();

}

});

});})(jQuery);

</script>

<?php

$sql_data = mysql_fetch_array(mysql_query("SELECT * FROM exam_question_answers_reasons WHERE id = '".$question_id."'"));
	/* echo '<pre>';	print_r($sql_data);	echo '</pre>'; */
?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
	<?php if(empty($error)){$error='';}
	if($error!=''){	?>    <tr>    <td colspan="5">		<div class="error"><?php echo $error; ?></div>
    </td>
    </tr>
    <?php } ?>
  <tr>    <td valign="top">
		<div class="tbl-out">
			<p class="client_table">
	    		<i class="fa fa-edit"></i>  Edit Question
	    	</p>		<table width="100%" border="0" cellspacing="0" cellpadding="0" class="center-tbl  new-tbl new-table2">
           <tr>				            <td align="right" valign="top">*Board</td>
				            <td><select name="exam_board_id" class="validate[required] selectfield require_select" onchange="showsubject(this.value)">
							<option value="">--Select Board --</option>
							<?php $board = mysql_query("select * from exam_board_master");
								
								while($bords_list=mysql_fetch_array($board))
								{
									?>
<option value="<?php echo $bords_list['id']?>" <?php if($bords_list['id']==$sql_data['exam_board_id']) { ?>selected="selected"<?php } ?>><?php echo $bords_list['name']?></option>
				              							 
				              
							  <?php } ?>
				            </select>
							</td>
				          </tr>
		 
		 <tr id="txtHint">
				            <td align="right" valign="top">*Subject</td>
				            <td><select name="subject_id" class="validate[required] selectfield require_select" onchange="showpaper(this.value)" id="form-validation-field-0">
							<option value="subject_id">--Select subject --</option>
							<?php $subject = mysql_query("select * from exam_subject_master");
								
								while($subject_list = 	mysql_fetch_array($subject))
								{
									?>

<option value="<?php echo $subject_list['id']?>" <?php if($subject_list['id'] == $sql_data['subject_id']) { ?>selected="selected"<?php } ?>><?php echo $subject_list['subject']?></option>
							  <?php } ?>
				            </select>
							</td>
		</tr>
		
		
		<tr id="txtHint1">
				            <td align="right" valign="top">*Paper</td>
				            <td><select name="paper_id" id="paper_id" class="validate[required] selectfield require_select" >
							<option value="paper_id">--Select Paper --</option>
							<?php $paper = mysql_query("select * from exam_paper");
								
								while($paper_list = 	mysql_fetch_array($paper))
								{
									?>

<option value="<?php echo $paper_list['id']?>" <?php if($paper_list['id'] == $sql_data['paper_id']) { ?>selected="selected"<?php } ?>><?php echo $paper_list['paper_name']?></option>					 
				              
							  <?php } ?>
				            </select>
							</td>
		</tr>
		<tr>			<td align="right" valign="top" class="left_head_form">*Topic</td>			<td>				<select name="topic" id="select_topic" class="validate[required] selectfield require_select">					<option>Select Topic</option>					<?php $topic = mysql_query("select * from exam_topic");																while($topic_list = 	mysql_fetch_array($topic))								{									?>				              <option value="<?php echo $topic_list['id']?>" <?php if($topic_list['id'] == $sql_data['topic_id']) { ?>selected="selected"<?php } ?>><?php echo $topic_list['name']?></option>							  <?php } ?>				</select>			</td>		</tr>		<tr>			<td align="right" valign="top" class="left_head_form">*Sub Topic</td>			<td>				<select id="sub_topic" name="sub-topic" class="validate[required] selectfield require_select">					<option>Select Sub Topic</option>					<?php $sub_topic = mysql_query("select * from exam_sub_topic");								while($sub_topic_list = 	mysql_fetch_array($sub_topic))								{									?>				              <option value="<?php echo $sub_topic_list['id']?>" <?php if($sub_topic_list['id'] == $sql_data['sub_topic_id']) { ?>selected="selected"<?php } ?>><?php echo $sub_topic_list['name']?></option>							  <?php } ?>				</select>			</td>		</tr>
		<tr>
            <td align="right" valign="top" class="left_head_form">*Question</td>
            <td><textarea class="ckeditor" cols="180" id="editor1"name="bodyar11" ><?php echo htmlspecialchars_decode(stripslashes($sql_data['question'])); ?></textarea></td>
         </tr> 
		
		 	<tr>
            <td align="right" valign="top" class="left_head_form">*Answer1</td>
            <td><textarea class="ckeditor" cols="80" id="editor1" name="bodyar12" ><?php echo htmlspecialchars_decode(stripslashes($sql_data['ans1'])); ?></textarea></td>
         </tr> 
		
		<tr>
            <td align="right" valign="top" class="left_head_form">*Reason1</td>
            <td><textarea name="reason1" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['reasons1'])); ?></textarea></td>
         </tr> 
		
		
		
		 	<tr>
            <td align="right" valign="top" class="left_head_form">*Answer2</td>
            <td><textarea name="bodyar13" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['ans2'])); ?></textarea></td>
         </tr>
			<tr>
            <td align="right" valign="top" class="left_head_form">*Reason2</td>
            <td><textarea name="reason2" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['reasons2'])); ?></textarea></td>
         </tr>
		 	<tr>
            <td align="right" valign="top" class="left_head_form">*Answer3</td>
            <td><textarea name="bodyar14" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['ans3'])); ?></textarea></td>
         </tr> 
		 <tr>
            <td align="right" valign="top" class="left_head_form">*Reason3</td>
            <td><textarea name="reason3" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['reasons3'])); ?></textarea></td>
         </tr>
		 	<tr>
            <td align="right" valign="top" class="left_head_form">*Answer4</td>
            <td><textarea name="bodyar15" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['ans4'])); ?></textarea></td>
         </tr>
<tr>
            <td align="right" valign="top" class="left_head_form">*Reason4</td>
            <td><textarea name="reason4" class="ckeditor" cols="180" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['reasons4'])); ?></textarea></td>
         </tr>		 
		 <tr>
            <td align="right" valign="top" class="left_head_form">*Answer5</td>
            <td><textarea name="bodyar16" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['ans5'])); ?></textarea></td>
         </tr> 
		 <tr>
            <td align="right" valign="top" class="left_head_form">*Reason5</td>
            <td><textarea name="reason5" class="ckeditor" cols="80" id="editor1"><?php echo htmlspecialchars_decode(stripslashes($sql_data['reasons5'])); ?></textarea></td>
         </tr>
		      <tr><td align="right" valign="top" class="left_head_form">*Correct Answer</td>
			 <td><input type="radio" name="ans" id="ans" value="1" <?php if($sql_data['correct_ans']==1){ echo "checked"; ?><?php } ?> > Answer1 <br>
			 <input type="radio" name="ans" id="ans" value="2" <?php if($sql_data['correct_ans']==2){ echo "checked"; ?><?php } ?>> Answer2<br>
			 <input type="radio" name="ans" id="ans" value="3" <?php if($sql_data['correct_ans']==3){ echo "checked"; ?><?php } ?>> Answer3<br>
			 <input type="radio" name="ans" id="ans" value="4" <?php if($sql_data['correct_ans']==4){ echo "checked"; ?><?php } ?>> Answer4<br>
			 <input type="radio" name="ans" id="ans" value="5" <?php if($sql_data['correct_ans']==5){ echo "checked"; ?><?php } ?>> Answer5</td> 
		 </tr>             
           <tr>

<td align="right" valign="top" class="left_head_form">Status</td>

<option value="Active" <?php if($sql_data['status']=='Active') { ?>selected="selected"<?php } ?>>Active</option>

<option value="Inactive" <?php if($sql_data['status']=='Inactive') { ?>selected="selected"<?php } ?>>Inactive</option>

</select></td>

</tr>        
        </table>
		</div>
    </td>
          </tr>
        </table>
</td>
    <td width="2%" valign="top"> </td>
    <td width="34%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>           
              <td colspan="5" align="center">           
              <input name="submit" type="submit" value="Save" class="require float-none org" style=" margin-bottom:10px;" onclick="return Checkfiles();" />
             <input type="button" name="back" id="back" class="require float-none" value="Cancel" style=" margin-bottom:10px;" onclick="window.history.back();" />         
              </td>
            </tr>             
        </table>
</td>
  </tr>
</table>
</form>
<div class="clear"></div>
</div>
<script type="text/javascript" src="js/tinymce/tinymce.min.js"></script>
<script type="text/javascript">
tinymce.init({
        selector: "#bodyar11",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor",
				"paste"
        ],

menubar: false,
        toolbar_items_size: 'small',
		//relative_urls: false,
		relative_urls : false,
		remove_script_host : false,
		convert_urls : true,
		//document_base_url: 'http://www.insurancemall2.com/india/',
        style_formats: [
                {title: 'Bold text', inline: 'b'},
                {title: 'Red text', inline: 'span', styles: {color: '#ff0000'}},
                {title: 'Red header', block: 'h1', styles: {color: '#ff0000'}},
                {title: 'Example 1', inline: 'span', classes: 'example1'},
                {title: 'Example 2', inline: 'span', classes: 'example2'},
                {title: 'Table styles'},
                {title: 'Table row 1', selector: 'tr', classes: 'tablerow1'}
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
</script>
<script type="text/javascript">
tinymce.init({
        selector: "#bodyar12",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#bodyar13",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#bodyar14",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#bodyar15",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});

tinymce.init({
        selector: "#bodyar16",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
tinymce.init({
        selector: "#reason1",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
tinymce.init({
        selector: "#reason2",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
tinymce.init({
        selector: "#reason3",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
tinymce.init({
        selector: "#reason4",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
tinymce.init({
        selector: "#reason5",
		height : 225,
		width : 750,
        plugins: [
                "advlist autolink autosave link image lists charmap print preview hr anchor pagebreak spellchecker",
                "searchreplace wordcount visualblocks visualchars code fullscreen insertdatetime media nonbreaking",
                "table contextmenu directionality emoticons template textcolor paste fullpage textcolor"
        ],

templates: [
                {title: 'Test template 1', content: 'Test 1'},
                {title: 'Test template 2', content: 'Test 2'}
        ]
});
</script>
<?php include("includes/footer.php"); ?>