MAINHACK

Viewing / Editing File: all_basic_question.php

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

<div class="main-panel">
			<div class="content">
				<div class="container-fluid">
					<div class="page-header">
						<h4 class="page-title">All Basic Questions</h4>
						
					</div>
					<div class="row">
<div class="col-md-12">
			
	<div class="card">
							
					
									<div class="table-responsive">
						            <table id="basic-datatables" class="display table table-striped table-hover">
						<thead>
								<tr>  
								  <th>Sl</th>
								  <th>Date</th>
								  <th>Question Id</th>
								  <th>Category</th>
								  <th>Sub Category</th>
								  <th>Questions</th> 
								  <th>Answer</th>
								  <th>Edit/Delete</th>
								</tr>
							</thead>
							<tbody>

<?php

$count=1;
        $stmt=$show->readwithdata_clause('upload_questions','question_type','Basic','group by question_id order by id desc');
        $num=$stmt->rowCount();
        if($num>0){
        while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
        $s1=$show->readwithdata('upload_questions','question_id',$row['question_id']);
        $sr='upload_questions';
            
echo "	<tr>
								  <td>$count</td>
								  <td>".date("d-m-Y",strtotime($row['date']))."</td>
								   <td>".$row['question_id']."</td>
								   <td>".$row['category']."</td>
								   <td>";
								   foreach($s1 as $subcate){
            echo $subcate['sub_category']."<br>";
        }
								   echo "</td>";
								  echo "<td>".htmlspecialchars_decode($row['question'])."</td>
								  <td>".$row['answer']."</td>
								  <td>
								 
								  <a href='' data-toggle='modal' data-target='#myModal".$count."' class='btn btn-xs btn-success'>Copy</a>
								  <a href='edit_question.php?qid=".$row['qid']."&url=".$_SERVER['REQUEST_URI']."'  class='btn btn-xs btn-info'>Edit</a>
								  <a href='delete.php?id=".$row['id']."&table=$sr&url=".$_SERVER['REQUEST_URI']."' class='btn btn-xs btn-danger' onclick='return send();'>Delete</a>
								 </td>							
								 </tr>";
								  
								
?>

}
});
}    
});    
});

</script>

<div id="myModal<?=$count?>" class="modal fade pageloadPupup" role="dialog" style="display:none;">
    <button id="myBtn">Open Modal</button>
    <div class="modal-dialog">

<div class="modal-content">
          <div class="modal-header">
            <button type="button" class="close" data-dismiss="modal">&times;</button>
          </div>
            <div class="modal-body">
                
               
                    <div class="modal-enquary">
                    <h5>Copy question</h5>
                        <form method="post">
                        <div class="modal-enquary-form">
                            <label>Choose Category<b>*</b></label>
                         <select  name="category<?=$count?>" id="category<?=$count?>" class="form-control" required>
        <option value="">Category</option>          				
        <?php  
        $stmt11=$show->readAll('category');
        $num11=$stmt11->rowCount();
        if($num11>0){
        while($row11=$stmt11->fetch(PDO::FETCH_ASSOC)){
        
        echo "<option value='".$row11['category']."'";if($state==$row11['category']) echo "selected"; echo ">".$row11['category']."</option>";	}
        
        }
        
        ?>
        </select>	
                      </div>
                       <div class="modal-enquary-form">
                      
                        <label>Sub Category</label>	    
                        
                        <div class="col-md-6"  id="display<?=$count?>">
                        
                        </div>

</div>
                        <div class="modal-enquary-form">
                            <label>Question<b>*</b></label>
                            <p id="name<?=$count?>"><?=htmlspecialchars_decode($row['question']);?></p>
                            <input id="name<?=$count?>" type="hidden" title="name" name="question<?=$count?>" value="<?=htmlspecialchars_decode($row['question'])?>">
                        </div>
                        <div class="modal-enquary-form">
                            <label>Options<b>*</b></label>
                             <p>1.<?=$row['option1']?></p>
                              <p>2.<?=$row['option2'];?> </p>
                              <p>3.<?=$row['option3'];?></p>
                              <p>4.<?=$row['option4'];?></p>
                             <input  type="hidden" name="option1<?=$count?>"  id="option1<?=$count?>" value="<?=$row['option1']?>">
                             <input  type="hidden" name="option2<?=$count?>" id="option2<?=$count?>" value="<?=$row['option2']?>">
                             <input  type="hidden" name="option3<?=$count?>" id="option3<?=$count?>" value="<?=$row['option3']?>">
                             <input  type="hidden" name="option4<?=$count?>" id="option1<?=$count?>" value="<?=$row['option4']?>">
                             <input  type="hidden" name="answer<?=$count?>" id="answer<?=$count?>" value="<?=$row['answer']?>">
                    </div>
                        <div class="modal-enquary-form" id="b_name">
                        
                        <label>Answer<b>*</b></label>
                                            <p><b><?=$row['answer']?></b></p>
                    </div>
                    
                    
                        <div class="modal-enquary-form enquary-btn">
                            <input type="submit" class="btn btn-xs btn-success" value="Copy Now" name="sub<?=$count?>">
                        </div>
                    </form>
<?php
$sub="sub".$count;
$category="category".$count;
$subcate="sub_category".$count;
$question="question".$count;
$option1="option1".$count;
$option2="option2".$count;
$option3="option3".$count;
$option4="option4".$count;
$answer="answer".$count;
$image="image".$count;

if(isset($_POST[$sub])){
       $uid=$show->getid('ids','QUES');
        $data=array(
            'question_id'=>$uid,
        );
     $show->insert($table,$data);   
     
    foreach($_POST['sub_category'] as $key=>$value){
    $qid=$show->getid('ids','Q');
    $table='upload_questions';

$data=array(
            'question_id'=>$uid,
         /* 'qid'=>$qid,
            'category'=>htmlspecialchars($_POST[$category]),
            'question_type'=>'Basic',
            '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])),  
           
           
            */
             );
if($show->insert($table,$data)){
print_r($data);echo "<script>alert('inserted');</script>";

}
}
}
?>			                    
                    
               </div> 
               
            
          </div>
          
        </div>
    </div>
</div>

// When the user clicks anywhere outside of the modal, close it
window.onclick = function(event) {
  if (event.target == modal) {
    modal.style.display = "none";
  }
}
</script>

<?php    		$count++;						
        
        }
}

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

</div>			
						</div>

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

$('#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: all_basic_question.php

Server Info

System Features

User Info