MAINHACK

Viewing / Editing File: upload_questions.php

<?php

include('header.php');

$paper_id=$_REQUEST['id'];
$paper=$_REQUEST['paper'];
?>
<style type="text/css">

#fli,#fli1
	{
	width: 79%;
height: 42px;
	}
	#display
	{
		position:absolute;
		width:303;
		margin-left:0;
		margin-top:0;
	
		padding:2px;
		display:none;
		border-top:0px;
		overflow:auto;
		border:1px #CCC solid;
		background-color: white;
		z-index:1000;
	}	
	
	.show11,.show12
	{
		padding:7px; 
		border-bottom:1px #999 dashed;
		font-size:13px; 
		
	}
	
	.show11:hover,.show1:hover
	{
		background:#1da1f2;
		color:#000;
		cursor:pointer;
	}	
.widget{
	overflow:visible !important;
	
}

</style>

}
});
}    
});    
});

</script>

<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">Upload QUESTIONS</div>
	</div>					
					
	<div class="card-body">				
	<form method="post" data-toggle="validator" enctype="multipart/form-data" > 
		<div class="form-group"> 
                						
     <div class="col-md-6">
        	<label>Category</label>
        				    
      
        
                </div>
						</div> 
						
			<div class="form-group ">
			<div class="col-lg-12 col-md-12 col-sm-12">
			<div class="table-responsive">
			<table id="basic-datatables" class="display table table-striped table-hover">
							<thead>
								<tr>  
								  <th>Category</th>
							      <th>Sub Category</th>
								
								  <th>Add</th>
								 
								</tr>
							    </thead>
								
			<tbody class='tr_input' id="tab" style="border:none !important;">
			<tr>
                   
                   
                  
					 <td>
					<div class="select2-input">
					<select name="category[]" class="category form-control" >
					    <option value="">Category</option>
                    <?php
                    
                    $sr='category';
                    $stmt =$show->readAll($sr);
                    $num = $stmt->rowCount();
                    
                    if($num>0){
                    
                    $count=1;
                    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                    extract($row);
                    ?>
                    <option value="<?=$row['category']?>"><?=$row['category']?></option>
                    <?php } } ?>
					</select> 
					</div>
					</td>
                   <td>
					<div class="select2-input">
					<select name="sub_category[]" class="form-control" id='dtestcode_1'>
					    <option value="">Category</option>
                    <?php
                    
                    $sr='sub_category';
                    $stmt =$show->readAll($sr);
                    $num = $stmt->rowCount();
                    
                    if($num>0){
                    
                    $count=1;
                    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
                    extract($row);
                    ?>
                    <option value="<?=$row['sub_category']?>"><?=$row['sub_category']?></option>
                    <?php } } ?>
					</select> 
					</div>
					</td>
                  <td><input type='button' class="btn btn-info" value='+' id='addmore'></td>
                    
                    </tr>       
			</tbody>
			
			
			</table>
			</div>
			</div>
			</div>
			
								
						

				<div class="form-group"> 
						<div class="col-md-12">
					<label>Question</label>
					<textarea name="question"></textarea>

</div>	
    
						</div> 	
				<div class="form-group"> 
						<div class="col-md-12">
					<label>Upload Main Image</label>
					<input type="file" name="main_img">

</div>	  
                <div class="form-group"> 
                			
                	<div class="col-md-6">
                				<label>Options 1</label>
                		<input type="text" class="form-control" placeholder="Option 1" name="option1" required /> 
                
                </div>
                	<div class="col-md-6">
                			<label>Options 2</label>
                
                 <input type="text" class="form-control" name="option2"  placeholder="Option 2" required/> 
                
                			</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" placeholder="Option 3" required/> 
                
                </div>
                			<div class="col-md-6">
                			<label>Options 4</label>
                 <input type="text" class="form-control" name="option4"  placeholder="Option 4" required/> 
                
                			</div>
                			<div class="clearfix"></div>
                </div>
                	
                	<div class="form-group">
                											                     
                	<div class="col-md-6">
                			
                	<label>Answer:</label>
                
                <input class="form-control" type="text" id="" placeholder="Answer"  name="answer" required/>
                	</div>
                <div class="clearfix"></div>
                
                	</div>
                
                
                        <div class="form-group"> 
                									
                		<div class="col-md-6">
                
                
                <input type="submit" class="btn btn-info" name="sub" value="Submit">
                </div>
                									<div class="clearfix"></div>
                
                </div>
							
				</form> 
							</div>
			
<?php
	
if(isset($_POST['sub'])){

if(file_exists($_FILES['main_img']['tmp_name']) || is_uploaded_file($_FILES['main_img']['tmp_name'])) {   
 $img=$show->imageEdit($_FILES['main_img']['name']);  
 move_uploaded_file($_FILES['main_img']['tmp_name'],"../product_img/".$img);

}else{ $img='';} 
 
  foreach($_POST['category'] as $key=>$value){
    $qid=$show->getid('ids','Q');
  $uid=$show->getid('ids','QUES');

$data=array(
    'question_id'=>$uid,
    'qid'=>$qid,
    'category'=>htmlspecialchars($value),
    'question_type'=>'Basic',
    'sub_category'=>$_POST['sub_category'][$key],
    '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'])),
    'main_image'=>$img,
	);
//print_r($data);
	$r1=$show->insert('upload_questions',$data);	
}

if($r1){
 echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "Question has been added",
            type: "success"
        }, function() {
            window.location = "'.$_SERVER['REQUEST_URI'].'";
        });
    }, 1000);
</script>';

//echo "<script>swal('Thank you for Registration.');window.location.href='".$_SERVER['request_uri']."';</script>";
 }

}

?>				
		</div>			
					</div>

</div>	
</div>	
</div>
		</div>
		
            <script type="text/javascript">
        $(document).ready(function(){
            // Add more
            $('#addmore').click(function(){    
                // Get last id 
                var lastname_id = $('.tr_input select').last().attr('id');//alert('ss');
                var split_id = lastname_id.split('_');
            
                // New index
                var index = Number(split_id[1]) + 1;

// Create row with input elements
                var html = "<tr ><td><div class='select2-input'><select name='category[]' class='category form-control' ><option value=''>Category</option><?php $sr='category'; $stmt =$show->readAll($sr);while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row);?><option value='<?=$row['category']?>'><?=$row['category']?></option><?php } ?></select></div></td> <td><div class='select2-input'><select name='sub_category[]' id='testcode_"+index+"' class='form-control' ><?php $sr='sub_category'; $stmt =$show->readAll($sr);while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){ extract($row);?><option value='<?=$row['sub_category']?>'><?=$row['sub_category']?></option><?php } ?></select> </div></td> <td><a href='javascript:void(0);' id='remove_field' class='btn btn-danger remCF' >-</a></td></tr>";

// Append data
                $('#tab').append(html);
				
				
            });
			
       $("#tab").on('click','.remCF',function(){
        $(this).parent().parent().remove();
    });
       });
	   
	   </script>
		
<script >
		$(document).ready(function() {
			$('#basic-datatables').DataTable({
			});

$('#multi-filter-select').DataTable( {
				"pageLength": 5,
				initComplete: function () {
					this.api().columns().every( function () {
						var column = this;
						var select = $('<select class="form-control"><option value=""></option></select>')
						.appendTo( $(column.footer()).empty() )
						.on( 'change', function () {
							var val = $.fn.dataTable.util.escapeRegex(
								$(this).val()
								);

column
							.search( val ? '^'+val+'$' : '', true, false )
							.draw();
						} );

column.data().unique().sort().each( function ( d, j ) {
							select.append( '<option value="'+d+'">'+d+'</option>' )
						} );
					} );
				}
			});

// Add Row
			$('#add-row').DataTable({
				"pageLength": 5,
			});

var action = '<td> <div class="form-button-action"> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-primary btn-lg" data-original-title="Edit Task"> <i class="la la-edit"></i> </button> <button type="button" data-toggle="tooltip" title="" class="btn btn-link btn-danger" data-original-title="Remove"> <i class="la la-times"></i> </button> </div> </td>';

$('#addRowButton').click(function() {
				$('#add-row').dataTable().fnAddData([
					$("#addName").val(),
					$("#addPosition").val(),
					$("#addOffice").val(),
					action
					]);
				$('#addRowModal').modal('hide');

});
		});
	</script>
	
	<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