MAINHACK

Viewing / Editing File: edit_paper.php

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

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">Choose Questions</h4>
						
					</div>
					<div class="row">
    
    <div class="count-checkboxes-wrapper" style="display:none">
      <span id="count-checked-checkboxes">0</span> checked
    </div>

<div class="form-group">
		       <div class="col-md-4">
            <label> Category</label>
			<input type="text" class="form-control" value="<?=$_REQUEST['category']?>" readonly name="title" placeholder="Category">
			
             </div>
      
             <div class="col-md-8">
            <label>Paper Name</label>
			<input type="text" class="form-control" name="paper" value="<?=$_REQUEST['paper']?>"  readonly placeholder="Paper Name">
      			<input type="hidden" class="form-control" name="no_of_question" id="no_of_ques" value="<?=$_REQUEST['no_of_question']?>"  readonly placeholder="Paper Name">
      			<input type="hidden" class="form-control" name="paper_id" id="id" value="<?=$_REQUEST['id']?>"  readonly placeholder="Paper Name">
       </div>
      
            </div>   
		  
		  <div class="form-group">
		       <div class="col-md-4">
			<input type="submit" class="btn btn-xs btn-success" id="sub" name="sub" value="Add Paper">
            <a href="" class="btn btn-xs btn-danger" >Back</a>
		  </div>   
		  </div>

</div>

<div class="table-responsive">
						            <table id="basic-datatables" class="display table table-striped table-hover">
						<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Choose</th>
								  <th>Date</th>
								  <th>Question Id</th>
								  <th>Category</th>
								  <th>Sub Category</th>
								  <th>Questions</th> 
								  <th>Answer</th>
								</tr>
							</thead>
							<tbody>

<?php

$count=1;
        $stmt=$show->readAll('upload_questions');
        $num=$stmt->rowCount();
        if($num>0){
        while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
        $s1=$show->readwithdata('papers','paper_id',$_REQUEST['id']);
        while($row1=$s1->fetch(PDO::FETCH_ASSOC)){ 
        
            $QID=$row1['qid'];
        }
        if($QID==$row['qid']){
            $check='checked';
        }
?>

<?php
echo "	<tr>
								  <td>$count</td>
								  <td><input type='checkbox' name='check[]' $check id='id".$count."'>
								  <input type='hidden' name='qid[]' value='".$row['qid']."'>
								  <input type='hidden' name='category[]' value='".$row['category']."'>
							      <input type='hidden' name='sub_category[]' value='".$row['sub_category']."'>  
								  <input type='hidden' name='question[]' value='".$row['question']."'>  
								  <input type='hidden' name='answer[]' value='".$row['answer']."'>  
								  <input type='hidden' name='option1[]' value='".$row['option1']."'>  
								  <input type='hidden' name='option2[]' value='".$row['option2']."'>  
								  <input type='hidden' name='option3[]' value='".$row['option3']."'>  
								  <input type='hidden' name='option4[]' value='".$row['option4']."'>  
								  </td>
								  <td>".date("d-m-Y",strtotime($row['date']))."</td>
								   <td>".$row['question_id']."</td>
								   <td>".$row['category']."</td>
								   <td>".$row['sub_category']."</td>";
								  echo "<td>".htmlspecialchars_decode($row['question'])."</td>
								  <td>".$row['answer']."</td>
								 </tr>";
								  
								
		$count++;						
}
}

?>				</tbody></table>
				
						</div>
	</div>					
</div>						
	</form>	
<?php 
if(isset($_POST['sub'])){
    
    $s="delete from papers where paper_id='".$_POST['paper_id']."'";
    $s1=$con->prepare($s);
    $s1->execute();
    
    foreach($_POST['check'] as $key=>$value){
    
    $data=array(
    
    'paper_id'=>$_POST['paper_id'],
    'category'=>htmlspecialchars($_POST['category'][$key]),
    'sub_category'=>htmlspecialchars($_POST['sub_category'][$key]),
    'question'=>htmlspecialchars($_POST['question'][$key]),
    'option1'=>htmlspecialchars($_POST['option1'][$key]),
    'option2'=>htmlspecialchars($_POST['option2'][$key]),
    'option3'=>htmlspecialchars($_POST['option3'][$key]),
    'option4'=>htmlspecialchars($_POST['option4'][$key]),
    'answer'=>htmlspecialchars($_POST['answer'][$key]),
    'qid'=>htmlspecialchars($_POST['qid'][$key]),
	);
//	print_r($data);
	$r1=$show->insert('papers',$data);	
}
 if($r1){
 echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "paper has been added",
            type: "success"
        }, function() {
            window.location = "all_papers_new.php";
        });
    }, 1000);
</script>';
 
    
}
    
}
	
	?>					</div>

</div>
				</div>
			</div>
			
		</div>
 <script>
    $(document).ready(function () {
  var $checkboxes = $('#exampleValidation td input[type="checkbox"]');
  var no_of_ques=$('#no_of_ques').val();
//alert(no_of_ques);
  $checkboxes.change(function () {
    var countCheckedCheckboxes = $checkboxes.filter(":checked").length;
    $("#count-checked-checkboxes").text(countCheckedCheckboxes);

$("#edit-count-checked-checkboxes").val(countCheckedCheckboxes);
    
    if(countCheckedCheckboxes>no_of_ques){
     alert('You cannot select more than no of question set. i.e .'+no_of_ques);   
        $('#sub').prop('disabled', true);
    }else{
            $('#sub').prop('disabled', false);
    
    }
  });
});

</script>

$('#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>
<?php include'footer.php';?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: edit_paper.php

Server Info

System Features

User Info