<?php 
include ("include/makeSession.php");
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from admission_query where id='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=admission_query.php">';
	exit;
}
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Admission Query <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Admission Query</a></li>
    </ol>
  </section>
  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Admission Query Report</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
            <table id="example1" class="table table-bordered table-striped">
              <thead>
              <tr>                   
                    <th scope="col">Sr no</th>
                    <th scope="col">Name</th>
					<th scope="col">Email</th>
					<th scope="col">Mobile</th>
                     <th scope="col">Message</th>
                     <th scope="col">Datetime</th>
                    <th scope="col">Action</th>
                  </tr>                
              </thead>
              <tbody> 
                <?php $q=mysqli_query($con,"select * from admission_query");
			  		$i = 1;
	  				  while($r=mysqli_fetch_array($q)){ ?>
                <tr>
			
                  <td><?php echo $i; ?></td> 
                  <td><?=$r['name'];?></td> 
                  <td><?=$r['email'];?></td> 
                  <td><?=$r['mobile'];?></td> 
                  <td><?=$r['message'];?></td> 
                  <td><?=$r['created_at'];?></td> 
                  
                  <td> <a href="?did=<?php echo $r["id"]; ?>"><i class="fa fa-remove text-red"></i></a></td>
                </tr>
                <?php $i++;} ?>
              </tbody>
            </table>
          </div>
          <!-- /.box-body --> 
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col --> 
    </div>
    <!-- /.row --> 
  </section>
</div>
<?php include('include/footer.php');?>

<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.colVis.min.js"  type="text/javascript"></script>


<script  type="text/javascript">
$(document).ready(function() {
    $('#example1').DataTable( {
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>