<?php
session_start();
include'dbconnection.php';
// checking session is valid for not 
if (strlen($_SESSION['id']==0)) {
  header('location:logout.php');
  } else{

// for deleting user
if(isset($_GET['id']))
{
$adminid=$_GET['id'];
$msg=mysqli_query($con,"delete from kyc where id='$adminid'");
if($msg)
{
echo "<script>alert('Data deleted');</script>";
}
}
?><!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="Dashboard">
    <meta name="keyword" content="Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina">

    <title>Admin | Manage Users</title>
    <link href="assets/css/bootstrap.css" rel="stylesheet">
    <link href="assets/font-awesome/css/font-awesome.css" rel="stylesheet" />
    <link href="assets/css/style.css" rel="stylesheet">
    <link href="assets/css/style-responsive.css" rel="stylesheet">
  </head>

  <body>

  <section id="container" >
      <header class="header black-bg">
              <div class="sidebar-toggle-box">
                  <div class="fa fa-bars tooltips" data-placement="right" data-original-title="Toggle Navigation"></div>
              </div>
            <a href="#" class="logo"><b>Admin Dashboard</b></a>
            <div class="nav notify-row" id="top_menu">
               
                         
                   
                </ul>
            </div>
            <div class="top-menu">
              <ul class="nav pull-right top-menu">
                    <li><a class="logout" href="logout.php">Logout</a></li>
              </ul>
            </div>
        </header>
      <aside>
          <div id="sidebar"  class="nav-collapse ">
              <ul class="sidebar-menu" id="nav-accordion">
              
                  <p class="centered"><a href="#"><img src="assets/img/ui-sam.jpg" class="img-circle" width="60"></a></p>
                  <h5 class="centered"><?php echo $_SESSION['login'];?></h5>
                    
                  <li class="mt">
                      <a href="change-password.php">
                          <i class="fa fa-file"></i>
                          <span>Change Password</span>
                      </a>
                  </li>

                  <li class="sub-menu">
                      <a href="manage-users.php" >
                          <i class="fa fa-users"></i>
                          <span>Manage Users</span>
                      </a>
                   
                  </li>
                   <li class="sub-menu">
                      <a href="copytrade.php" >
                          <i class="fa fa-users"></i>
                          <span>Copy Trading</span>
                      </a>
                   
                  </li>
                   <li class="sub-menu">
                      <a href="copytrade.php" >
                          <i class="fa fa-users"></i>
                          <span>Trading</span>
                      </a>
                   
                  </li>

                  <li class="sub-menu">
                      <a href="plans.php" >
                          <i class="fa fa-users"></i>
                          <span>Plans</span>
                      </a>
                   
                  </li>
                   <li class="sub-menu">
                      <a href="kyc.php" >
                          <i class="fa fa-users"></i>
                          <span>KYC Verification</span>
                      </a>
                   
                  </li>
              
                 
              </ul>
          </div>
      </aside>
      <section id="main-content">
          <section class="wrapper">
            <h3><i class="fa fa-angle-right"></i> Manage Users</h3>
        <div class="row">
        
                  
                    
                  <div class="col-md-12">
                      <div class="content-panel">
                          <table class="table table-striped table-advance table-hover">
                            <h4><i class="fa fa-angle-right"></i> All User Details</i>
 </h4>
                            <hr>
                              <thead>
                              <tr>
                                  <th>Sno.</th>
                                 
                                  <th>House Address</th>
                                  <th>Phone</th>
                                  <th>File</th>
                        
                              </tr>
                              </thead>
                              <tbody>
                             <?php 
$ret = mysqli_query($con, "SELECT * FROM kyc");
$cnt = 1;
while ($row = mysqli_fetch_array($ret)) {
?>
<tr>
    <td><?php echo $cnt; ?></td>
    <td><?php echo $row['houseadd']; ?></td>
    <td><?php echo $row['phone']; ?></td>
    <td>
        <?php 
        if (!empty($row['file'])) {
            echo "<img src='uploads/{$row['file']}' alt='KYC Image' width='100' height='100'>";
        } else {
            echo "No image";
        }
        ?>
    </td>
    <td>
        <a href="kyc.php?id=<?php echo $row['id']; ?>">
            <button class="btn btn-danger btn-xs" onClick="return confirm('Do you really want to delete');">
                <i class="fa fa-trash-o "></i>
            </button>
        </a>
    </td>
</tr>
<?php 
    $cnt = $cnt + 1; 
} 
?>
                              </tbody>
                          </table>
                      </div>
                  </div>
              </div>
    </section>
      </section
  ></section>
    <script src="assets/js/jquery.js"></script>
    <script src="assets/js/bootstrap.min.js"></script>
    <script class="include" type="text/javascript" src="assets/js/jquery.dcjqaccordion.2.7.js"></script>
    <script src="assets/js/jquery.scrollTo.min.js"></script>
    <script src="assets/js/jquery.nicescroll.js" type="text/javascript"></script>
    <script src="assets/js/common-scripts.js"></script>
  <script>
      $(function(){
          $('select.styled').customSelect();
      });

  </script>

  </body>
</html>
<?php } ?>