MAINHACK

Viewing / Editing File: edit_question.php

<?php include 'header.php';

?>
<script>
$(document).ready(function(){
$("#category").change(function() {
  var category = $('#category').val();
  //alert(category);
if(category=="")
{
$("#display").html("");
}
else
{
$.ajax({
type: "POST",
url: "ajax_check.php",
data: "category="+ category ,
 
success: function(html){
$("#display").html(html).show();
	$("#loader").hide();

}
});
}    
});    
});

</script>
<?php
$count=1;
$sr='upload_questions';//$subcategory='';
$stmt =$show->readwithdata($sr,'question_id',$_REQUEST['qid']);
$num = $stmt->rowCount();
    if($num>0){
 
        $count=1;
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
        extract($row);
        $uid[]=$row['id'];  
       
          $category=$row['category'];
          $question=$row['question'];
         $subcategory[]=$row['sub_category'];
           $option1=$row['option1'];
          $option2=$row['option2'];
          $option3=$row['option3'];
          $option4=$row['option4'];
      $answer=$row['answer'];        
        }
}
?>
		<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="row">
<div class="col-md-12">
<div class="card">
	<div class="card-header">
		<div class="card-title">Edit Question</div>
	</div>
	<form method="post" data-toggle="validator" enctype="multipart/form-data" > 
<div class="form-group"> 
                						
     <div class="col-md-6">
        	<label>Category</label>
        				    
      <select  name="category" id="category" class="form-control" required>
        <option value="">Category</option>          				
        <?php  
        $table1='category';
        $stmt=$show->readAll($table1);
        $num=$stmt->rowCount();
        if($num>0){
        while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
        
        echo "<option value='".$row['category']."'";if($category==$row['category']) echo "selected"; echo ">".$row['category']."</option>";	}
        
        }
        
        ?>
        </select>	
                </div>
						</div> 
<div class="form-group">
		           	<label>Sub Category</label>	    
 
	<div class="col-md-6">
		    <?php //$implode = implode(',', $subcategory); echo $implode; ?>
		    <table id="basic-datatables" class="display table table-striped table-hover">
		        <?php foreach($subcategory as $key=>$value){?>
		        
		        <tr><td><?=$value?></td><td><a href="delete.php?id=<?=$uid[$key]?>&table=upload_questions&url=edit_question.php?qid=<?=$_REQUEST['qid']?>" class="btn btn-xs btn-danger">Delete</a></td></tr>
		    <?php } ?>
		    </table>
		    
		</div>
		</div>			
<div class="form-group">
		           	<label>Add New Sub Category</label>	    
 
	<div class="col-md-6"  id="display">
		   
		    </table>
		    
		</div>
		</div>				
		<div class="form-group"> 
						<div class="col-md-12">
					<label>Question</label>
					
<textarea  name="question"> <?php echo $question; ?></textarea></div>	
					<div class="clearfix"></div>

</div> 	
						
						
							<div class="form-group"> 
										
								<div class="col-md-6">
											<label>Options 1</label>
									<input type="text" class="form-control" name="option1" value="<?php echo $option1; ?>" /> 
		
						</div>
								<div class="col-md-6">
										<label>Options 2</label>

</div>
										
										<div class="clearfix"></div>
						
						</div>
						<div class="form-group"> 
										
										<div class="col-md-6">
										<label>Options 3</label>
									<input type="text" class="form-control" name="option3" value="<?php echo $option3; ?>" /> 
		
						</div>
										<div class="col-md-6">
										<label>Options 4</label>
						 	<input type="text" class="form-control" name="option4" value="<?php echo $option4; ?>"  />

</div>
										<div class="clearfix"></div>
						</div>
								
								<div class="form-group">
																		                     
								<div class="col-md-6">
										
								<label>Answer:</label>

</div>

</div>
				
							</div>
					
					
				
													
				</form> 
</div>	
<?php

if(isset($_POST['sub'])){
	
$allowed = ["question","option1","option2","option3","option4","answer","category"];

$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars($_POST[$key]);
    }
}
if(isset($_POST['sub_category'])){
    
  foreach($_POST['sub_category'] as $key=>$value){
    
$data=array(
    
    'question_id'=>$_REQUEST['qid'],
    'category'=>htmlspecialchars($_POST['category']),
    'sub_category'=>$value,
   'question'=>$_POST['question'],
    'option1'=>htmlentities(strip_tags($_POST['option1'])),
    'option2'=>htmlentities(strip_tags($_POST['option2'])),
    'option3'=>htmlentities(strip_tags($_POST['option3'])),
    'option4'=>htmlentities(strip_tags($_POST['option4'])),
    'answer'=>htmlentities(strip_tags($_POST['answer'])),
	);
//	print_r($data);
	$r1=$show->insert('upload_questions',$data);	
}  
}
$setStr = rtrim($setStr, ",");
$params['question_id'] =$_REQUEST['qid'];
$show->table ='upload_questions';
$show->cols =$setStr;
$show->id_name ='question_id';
$show->params =$params;
//print_r($params);
if($show->update_all()){
   		
echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You ",
            text: "for Updating!",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';
} else{
	echo "ss";
}

}?>

</div>
				</div>
			</div>
			
		</div>

<?php include 'footer.php'; ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_question.php

Server Info

System Features

User Info