MAINHACK

Viewing / Editing File: upload_questions.php

<?php

include('header.php');

$paper_id=$_REQUEST['id'];
$paper=$_REQUEST['paper'];
?>

<div id="page-wrapper">
			<div class="main-page">
				<div class="row">
					<div class="col-md-8">
			
					
					<div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
						<div class="form-title">
							<h4>SET QUESTIONS</h4>
						</div>
						<div class="form-body">
	<form method="post" data-toggle="validator" enctype="multipart/form-data" > 
							<div class="form-group"> 
							
					<div class="col-md-4">
					<label>Paper ID</label>
					
	<input type="text" class="form-control" name="file" value="<?php echo $_REQUEST['id']; ?>" readonly /> 
</div>
			<div class="col-md-4">
					<label>Paper Number</label>
					
	<input type="text" class="form-control" name="papr_num" value="<?php echo $_REQUEST['paper']; ?>" readonly /> 
</div>
									
							<div class="clearfix"></div>
						</div> 
				<div class="form-group"> 
						<div class="col-md-12">
					<label>Question</label>
					
<textarea class="form-control" name="quest"></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" /> 
		
						</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" /> 
		
						</div>
										<div class="col-md-6">
										<label>Options 4</label>
						 	<input type="text" class="form-control" name="option4"  />

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

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

</div>

</div>
				
							</div>
					
					
				
													
				</form> 
				
<?php
	
if(isset($_POST['sub'])){
//	include('ids.php');
		$today=date("s");

$options=trim($_POST['option1'])."-".trim($_POST['option2'])."-".trim($_POST['option3'])."-".trim($_POST['option4']);
$val1 = 'select 1 from $paper LIMIT 1';
$val= mysqli_query($con,$val1);

if($val !== FALSE)
{
echo "<script>sweetAlert('OK','Thank you for For giving the Question','success');</script>";
 }
else
{
	$s1="create table $paper(id int not null auto_increment,paper_id varchar(20),paper_number varchar(20),questions text,options text,answer text,date date,marks varchar(10), primary key(id))";
	$r1=mysqli_query($con,$s1);
$sq1="select count(id) as c from $paper order by id";
$r12=mysqli_query($con,$sq1);
while($test=mysqli_fetch_array($r12)){
    
 $total=$test[c];    
}
if($total>=20){
    echo "<script>sweetAlert('OK','Sorry Questions cannot be more than 20','success');</script>";

}else{	
 $sq="insert into $paper(paper_id,paper_number,questions,options,answer,date,marks) 
values('".$paper_id."','".$paper."','".mysqli_real_escape_string($con,$_POST['quest'])."','".mysqli_real_escape_string($con,$options)."','".mysqli_real_escape_string($con,$_POST['answer'])."',curdate(),'1')";
$r=mysqli_query($con,$sq) or die(mysqli_error($con));
//echo $sq;
if($r==1){
echo "<script>sweetAlert('OK','Thank you for For giving the Question','success');</script>";
}
}
}

}

?>				
				
						</div>

<div class="col-md-12">
			
					
					<div class="form-grids row widget-shadow" data-example-id="basic-forms"> 
						<div class="form-title">
							<h4>All Questions</h4>
						</div>
						<div class="panel-body widget-shadow">
	<table class="table"  id="example">
							<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Paper ID</th>
								  <th>Paper NO</th>
								  <th>Questions</th> 
								  <th>Answer</th>
								  <th>Date</th>
								  <th>Edit/Delete</th>
								</tr>
							</thead>
							<tbody>

<?php

$count=1;
$sq="select * from $paper order by id desc";
$r=mysqli_query($con,$sq);
while($row=mysqli_fetch_array($r)){
$url=urlencode($_SERVER['REQUEST_URI']);
//echo $url;
echo "	<tr>
								  <td>$count</td>
								   <td>".$row['paper_id']."</td>
								  <td>".$row['paper_number']."</td>
								  <td>".$row['questions']."</td>
								  <td>".$row['answer']."</td>
								  <td>".date("d-m-Y",strtotime($row['date']))."</td>
								  <td><a href='edit_ques.php?paper=$paper&id=".$row['id']."&url=".$url."'  class='label label-info'>Show</a>
								  <a href='delete_ques.php?paper=$paper&id=".$row['id']."&url=".$url."' class='label label-danger' onclick='return send();'>Delete</a>
								 </td>								  </tr>";
								  
								
		$count++;						
}

?>				</tbody></table>
				
						</div>

</div>			
</div>	
</div>	
</div>
		</div>
		
	<script src="js/bootstrap-datepicker.js"></script>
        <script type="text/javascript">
            // When the document is ready
             $(document).ready(function(){
       $("#date1").datepicker({
	   format: 'dd-mm-yyyy',
	   
	   });
	         $("#date2").datepicker({
	   format: 'dd-mm-yyyy',
	   
	   }); 
	   $("#date2").datepicker({
	   format: 'dd-mm-yyyy',
	   
	   });
	   
	       
        </script>	
		
		
<?php

include('footer.php');
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: upload_questions.php

Server Info

System Features

User Info