            <!-- Exportable Table -->
             <div class="container-fluid">
            <div class="block-header">
                <h2>
                     <ol class="breadcrumb breadcrumb-bg-teal">
                           <li><a href="index.php?home"><i class="material-icons">home</i> Home</a></li>
                           <li class="active"><i class="material-icons">person</i> user</li>
                     </ol>
                </h2>
            </div>
<?php 
if(isset($_GET['del'])){
$del=noninjection($koneksi,$_GET['del']);
			$qry_del=mysqli_query($koneksi,"DELETE FROM `tb_user` WHERE id='".$del."'");
				$koneksi_host=open_connection2();
			$res=mysqli_query($koneksi_host,"DELETE FROM tbregistrasi  WHERE (nis='".$del."') AND (npns='".$_SESSION['npsn']."')");
			if($qry_del){echo ' <div class="alert bg-green alert-dismissible" role="alert">
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                                <strong>Well done!</strong> Hapus Data Sukses.
                            </div>';
							}else {
							echo '<div class="alert bg-pink alert-dismissible" role="alert">
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
                               <strong>Warning!</strong> Hapus Data Gagal.
                            </div>';
							}
}
?>
            <!-- Exportable Table -->
            <div class="row clearfix">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="card">
                        <div class="header">
                            <h2>
                                DATA USER
                            </h2>
                            <ul class="header-dropdown m-r--5">
                              
                                    <a href="index.php?user&mn=user_add" >
										<button type="button" class="btn bg-green btn-circle-lg waves-effect waves-circle waves-float"  data-toggle="tooltip"
                                            data-placement="left" title="Input Data Member">
                                    		<i class="material-icons">add_circle_outline</i> 
                               			</button>
                                    </a>
                                   <!--
								    <a href="index.php?user&mn=user_upload" >
									<button type="button" class="btn bg-green btn-circle-lg waves-effect waves-circle waves-float" data-toggle="tooltip"
                                            data-placement="left" title="Upload Data Member Template Ms.Excel">
                                    	<i class="material-icons">file_upload</i> 
                                	</button>
                                    </a>
                                    -->
                                
                            </ul>
                        </div>
                        <div class="body">
						
						
						
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped table-hover dataTable js-exportable">
                                    <thead>
                                        <tr>
                                            <th>IDUser</th>
                                            <th>Nama</th>
                                            <th>Phone</th>
											<th>Email</th>
                                            <th>Kategori</th>
											<th>Status</th>
											<th></th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                           <th>IDUser</th>
                                           <th>Nama</th>
                                           <th>Phone</th>
                                           <th>Email</th>
                                           <th>Kategori</th>
										   <th>Status</th>
										   <th></th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
									<?php 
									$qry_cari=mysqli_query($koneksi,"SELECT * FROM `tb_user` order by id");
									while($row=mysqli_fetch_array($qry_cari)){
									?>
                                        <tr>
										 <td><?php echo $row['id'];?></td>
										 
										
                                            <td><?php echo $row['nama'];?></td>
                                          
                                            <td><?php echo $row['phone'];?></td>
											 <td><?php echo $row['email'];?></td>
                                            
                                            <td><?php echo $row['kategori'];?></td>
                                            <td><?php echo $row['status'];?></td>
											<td>
								<div align="right">
									<a href="index.php?user&mn=user_edit&edit=<?php echo $row['id'];?>">
									<button type="button" class="btn bg-green btn-circle waves-effect waves-circle waves-float" data-toggle="tooltip" data-placement="left" title="Edit Data">
                                    	<i class="material-icons">create</i>
                                	</button>
									</a>
									
									<a href="index.php?user&mn=user_view&id=<?php echo $row['id'];?>">
								 	<button  type="button" data-toggle="modal" data-target="#defaultModal"  class="btn bg-light-blue btn-circle waves-effect waves-circle waves-float" data-placement="left" title="View Data">
                                    	<i class="material-icons">search</i>
                                	</button>
									</a>
									
									<a href="index.php?user&del=<?php echo $row['id'];?>" onclick="return confirm('Yakin ingin Hapus data ini?');">
								  	<button type="button" class="btn bg-red btn-circle waves-effect waves-circle waves-float" data-toggle="tooltip" data-placement="left" title="Hapus Data">
                                    	<i class="material-icons">delete_sweep</i>
                                	</button>
									</a>
									<div style="font-size:12px; color:#003300;" align="right"><?php echo $row['tgl'];?></div>
								</div>
											</td>
                                        </tr>
                                      <?php }?>
                                    </tbody>
                                </table>
								
							 
								
								
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- #END# Exportable Table -->
<!-- Small Size -->

            