<?php
include("include/header.php");
include("include/sidebar.php");
?>
<!-- DataTables -->
<link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            Crud Sample
            <small>Double Page</small>
        </h1>
        <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Level</a></li>
            <li class="active">Crud Sample</li>
        </ol>
    </section>
    <!-- Main content -->
    <section class="content container-fluid">
        <div class="row">
            <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Data Table With Full Features</h3>
            </div>
            <!-- /.box-header -->
            <div class="box-body">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                    <th>Action</th>
                    <th>#ID</th>
                    <th>Name</th>
                    <th>Email</th>
                    <th>Mobile</th>
                    <th>City</th>
                </tr>
                </thead>
                <tbody>
                    <?php
                        $q=mysqli_query($con,"select * from crud_sample2 order by id desc");
                        $i=0;
                        while($r=mysqli_fetch_array($q)){$i++;
                    ?>
                <tr>
                  <td>
                      <a href="crud_sample2.php?upid=<?=$r['id'];?>"><i class="fa fa-pencil"></i></a>
                      <a href="crud_sample2.php?did=<?=$r['id']?>" onclick="return confirm_click();"><i class="fa fa-close"></i></a>
                  </td>
                  <td><?=$i;?></td>
                  <td><?=$r['name'];?></td>
                  <td><?=$r['email'];?></td>
                  <td><?=$r['mobile'];?></td>
                  <td><?=$r['city'];?></td>
                </tr>
                <?php
                        }
                ?>
                </tbody>
              </table>
            </div>
            <!-- /.box-body -->
          </div>
        </div>
    </section>
</div>
<?php include("include/footer.php"); ?>
<!-- DataTables -->
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<!-- page script -->
<script>
  $(function () {
    $('#example1').DataTable({
      'paging'      : true,
      'lengthChange': true,
      'searching'   : true,
      'ordering'    : true,
      'info'        : true,
      'autoWidth'   : true
    });
  });
</script>
</body>
</html>