<?php 
    include 'header.php';


 
 ?>

<!-- Card start -->
     <div class="card">
                  <div class="card-header">
                    <div class="card-title"></div>
                  </div>
                  <div class="card-body">
                    <div class="table-responsive">
                      <table id="scrollVertical" class="table custom-table">
                        <thead>
                          <tr>
                            <th>#</th>
                            <th>Fname</th>
                            <th>Email</th>
                            <th>Username</th>
                            <th>Password</th>
                            <th>Phone</th>
                            <th>Gender</th>
                            <th>Address</th>
                            <th>City</th>
                            <th>country</th>
                            <th>Date Registerd</th>
                            <th>Action</th>
                          </tr>
                        </thead>
                        <tbody>
                 <?php
                      $i = 0;
                        $select = mysqli_query($link, "SELECT * FROM  users WHERE status = 'Unverified'  ");
                          if (mysqli_num_rows($select) > 0) {
                            while ($row = mysqli_fetch_assoc($select)) {
                              $id = $row ['id'];
                             
                     $i++         
                   ?>  
                          <tr>
                            <td><?php echo $i  ?></td>
                            <td><?php echo $row['fname']  ?></td>
                            <td><?php echo $row['email']  ?></td>
                            <td><?php echo $row['username']  ?></td>
                            <td><?php echo $row['phone']?></td>
                            <td>phote</td>
                            <td><?php echo $row['gender']?></td>
                            <td><?php echo $row['address']?></td>
                            <td><?php echo $row['city']?></td>
                            <td><?php echo $row['country']?></td>
                            <td><?php echo $row['date']?></td>
                            
                        
                            <td>
                               <a class="btn btn-sm btn-success" style="color: white;" href="edituser.php?edit=<?php echo $id  ?>">Edit</a>
                            </td>

                           <td>
                               <a class="btn btn-sm btn-danger" style="color: white;" href="all-menu.php?delete=<?php echo $id  ?>">Delete</a>
                          </td>


                          
                     
                        </tr>
                    
                      <?php }} ?>
                      </tbody>
                  </table>
              </div>
          </div>
      </div>
  </div>
<?php
    include 'footer.php';
?>