bnmbnmbnmnbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbn

]nbmbmbnmbnmbnmnbnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn bnmbnmbnmnbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbn

<?php 
require_once("../config.php");
require_once("function-file.php");
require_once("function-menu.php");
cookiecheck();
if((!empty($_GET['action']))&&($_GET['action']=='delete')){
	$test_id=$_GET['test_id'];
	$conn->exec("delete from testimonials where test_id='$test_id'");
	header("location:testimonials.php");
}?>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Testimonials</title>
    
    <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    <?php  cssfile();datatablecss();?>
    <style>.selected{color:red;}</style>
  </head>
  <body class="hold-transition skin-blue layout-top-nav">
    
    <div class="wrapper">
<?php headermenu();?>
      
      
      <div class="content-wrapper">
        
        
        <div class="col-sm-12">
        <section class="content">
          
          <div class="box">
            <div class="box-header with-border">
              <h3 class="box-title">Testimonials</h3>
              <div class="box-tools pull-right">
                <a href="testimonials-new.php" class="btn btn-primary btn-sm" ><i class="fa fa-plus"></i> Add Testimonials</a>
              </div>
            </div>
            <div class="box-body">
              <table class="table table-bordered table-striped dataTable" id="data-table">
                <thead><tr><th>Image</th><th>Name</th><th>Message</th><th>Action</th></tr></thead>
                 <tbody>
                 	<?php  $data=$conn->prepare("select * from testimonials");
					$data->execute();$result=$data->fetchall();$i=1;
					foreach($result as $row){
						echo "<tr>";
						echo "<td><img src='img/test/$row[test_img]' width='100'></td>";
						echo "<td>$row[test_name]</td>";
						echo "<td>$row[test_msg]</td>";
						echo "<td><a href='testimonials-edit.php?test_id=$row[test_id]' title='Edit Testimonials' class='btn btn-info btn-xs'>Edit</a>&nbsp;&nbsp;";?><a href='testimonials.php?action=delete&test_id=<?php echo $row['test_id'];?>' onclick="return confirm('Are you sure you want to delete?')" title='Delete Testimonials' class='btn btn-danger btn-xs'>Delete</a></td><?php
						echo "</tr>";
						$i++;
					}
					?>
                 </tbody>
                 </table>
            </div>
          </div>
        </section>
        </div>
      </div></div>
      <?php footer();?>
    </div>
   <?php jsfile();datatablejs();?>
   <script>
$('#data-table').dataTable({
     responsive: true,
     "dom": 'T<"clear">lfrtip',
	  "ordering": false,
     "tableTools": {
           "sSwfPath": "../apptheme/plugins/datatables/extensions/TableTools/swf/copy_csv_xls_pdf.swf",
		   "aButtons": [
            {
                "sExtends": "copy",
                "mColumns": [0, 1, 2]
            },
   			{
                "sExtends": "xls",
                "mColumns": [0, 1, 2]
            },
                        {
                "sExtends": "pdf",
                "mColumns": [0, 1, 2]
            },
        ]
      }
});
</script>

</body>
</html>