bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

hjkhhjhjol;io;ioio;ioiio;ioreererereio;;iooi;i;o;oii;o;ioo;iio;oi; bnmbnmbnmnbmbio;io;irererereeo;o;oi;;oi;oioi;oi;oio;;oovn

<?php
    require_once 'header.php';
    require_once 'navbar.php';

$sql="SELECT * from queries ORDER BY `id` DESC";
     $res=$conn->query($sql);
     if($res->num_rows > 0)
     {
        while($row=$res->fetch_assoc())
        {
            $queries[]=$row;
        }
     }

if (isset($_POST['delete_id'])) {
        $id = $_POST['delete_id'];

$query = "DELETE FROM queries WHERE id = " . $id;

if ($conn->query($query)) {
            echo "Success";
        } 
    }
?>

<style>
	.vendor_pass{
		background-color: #ffc800;
		color: #fff;
	}
	.confirmed{
		background-color: #0aa50a;
		color: #fff;
	}
	.cancelled{
		background-color: red;
		color: #fff;
	}
    .booked{
        background-color: #3485b6;
        color: #fff;
    }
</style>

<div class="container-fluid pt-8">
    <div class="page-header mt-0 p-3">
        <h3 class="mb-sm-0">All Queries</h3>
    </div>
    <div id="alert2" class="col-md-12"></div>
    	
    <div class="row">
        <div class="col-12">
        
           <div class="alert alert-success" id="success" style="display:none">Success! Your Request has been submited.</div>
            
              
            <div class="card shadow">
                
                
                                        
 <div class="card-body">
                    <div class="grid-margin">
                        <div class="">
                            <div class="table-responsive">
                                <table id="example" class="text-center table card-table table-vcenter text-nowrap  align-items-center table-bordered">
                                    <thead>              
                                    <tr>                         	
                                            				<th>S.No</th>
                                            				<th>Name</th>
                                                            <th>Contact</th>
                                                            <th>Email </th>
                                                            <th>Message</th>
                                                            <th>Action</th>
                                                            
                                          </tr>
                                    </thead>
                                      <tbody>
										  <?php
										  if(isset($queries))
										  {
											  $x=1;
											  foreach($queries as $query)
											  {
												?>
										  <tr>
                                            <td><?=$x?></td>
                                            <td><?=$query['name'];?></td>
                                            <td><?=$query['contact'];?></td>
                                            <td><?=$query['email'];?></td>
                                            <td><?=$query['message'];?></td>
                                            <td><button type="button" name="del" class="btn btn-danger" value="${data.id}" onclick="del(<?=$query['id'];?>)">
                                    <i class="fa fa-trash"></i></button></td>
                                            
                                          </tr>
										  <?php
												$x++;  
											  }
										  }
										  ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<?php 
require_once 'footer.php';
//require_once 'jslinks.php';
?>

<script src="assets/plugins/jquery/dist/jquery.min.js"></script>
    <script src="assets/js/popper.js"></script>
    <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>

<script src="assets/plugins/chart.js/dist/Chart.min.js"></script>
    <script src="assets/plugins/chart.js/dist/Chart.extension.js"></script>

<script src="assets/plugins/datatable/jquery.dataTables.min.js"></script>
    <script src="assets/plugins/datatable/dataTables.bootstrap4.min.js"></script>
    <script src="assets/plugins/datatable/dataTables.responsive.min.js"></script>
    <script src="assets/plugins/datatable/responsive.bootstrap4.min.js"></script>

<script src="assets/plugins/toggle-sidebar/js/sidemenu.js"></script>

<script src="assets/plugins/customscroll/jquery.mCustomScrollbar.concat.min.js"></script>

<script src="assets/js/custom.js"></script>
    <script src="assets/js/datatable.js"></script>

</script>
<script>
    function del(e) {
      var verify = confirm("Do you really want to delete!!!");
      if(verify) {
           $("#global-loader").show();
          $.ajax({
              url: "queries.php",
              type: "POST",
              data: {
                  delete_id: e,
              },
              success: function(response){
                  location.reload();
              },
          })
      }
  }
</script>