<!doctype html>
<html lang="en">
<head>
  <?php
    
    $db = mysqli_connect("localhost", "root", "", "sp");
   ?>
    <?php
  // Create database connection
  $db = mysqli_connect("localhost", "root", "", "sp");

  // Initialize message variable
  $msg = "";

  // If upload button is clicked ...
  if (isset($_POST['upload'])) {
  	// Get image name
  	$image = $_FILES['image']['name'];
  	// Get user_id
  	$user_id = mysqli_real_escape_string($db, $_POST['user_id']);
      // Get name
  	$name = mysqli_real_escape_string($db, $_POST['name']);
      // Get messa
  	$messa = mysqli_real_escape_string($db, $_POST['messa']);
      // Get pin
  	$pin = mysqli_real_escape_string($db, $_POST['pin']);
  	// image file directory
  	$target = "images/".basename($image);

  	$sql = "INSERT INTO `pin_request` (`user_id`, `name`, `messa`, `pin`, `image`) VALUES ('$user_id', '$name', '$messa', '$pin', '$image')";
  	// execute query
  	mysqli_query($db, $sql);

  	if (move_uploaded_file($_FILES['image']['tmp_name'], $target)) {
  		$msg = "Image uploaded successfully";
  	}else{
  		$msg = "Failed to upload image";
  	}
  }
  $result = mysqli_query($db, "SELECT * FROM `pin_request`");
?>
<!doctype html>
<html lang="en">
<?php
  include_once("../element/connection.php");
 ?>





<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title>Life X - Vie Pin</title>
  <meta content="" name="description">
  <meta content="" name="keywords">

  <!-- Favicons -->
  <link href="assets/img/favicon.png" rel="icon">
  <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">

  <!-- Google Fonts -->
  <link href="https://fonts.gstatic.com" rel="preconnect">
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Nunito:300,300i,400,400i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">

  <!-- Vendor CSS Files -->
  <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
  <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <link href="assets/vendor/quill/quill.snow.css" rel="stylesheet">
  <link href="assets/vendor/quill/quill.bubble.css" rel="stylesheet">
  <link href="assets/vendor/remixicon/remixicon.css" rel="stylesheet">
  <link href="assets/vendor/simple-datatables/style.css" rel="stylesheet">

  <!-- Template Main CSS File -->
  <link href="assets/css/style.css" rel="stylesheet">
    <link href="../assets\css/style.css" rel="stylesheet">

  <!-- =======================================================
  * Template Name: NiceAdmin - v2.3.1
  * Template URL: https://bootstrapmade.com/nice-admin-bootstrap-admin-html-template/
  * Author: BootstrapMade.com
  * License: https://bootstrapmade.com/license/
  ======================================================== -->
</head>

<body>
    
    <?php include 'element/header.php'; ?>
<?php include 'element/sidebar.php'; ?>
    
    <div class="dashboard-main-wrapper">

        <?php
        include_once("element/sidebar.php");
         ?>

        <main id="main" class="main">
        
         <div class="pagetitle">
      <h1>Dashboard</h1>
      <nav>
        <ol class="breadcrumb">
          <li class="breadcrumb-item"><a href="pin.php">View Pin</a></li>
          <li class="breadcrumb-item active">Epin</li>
        </ol>
      </nav>
    </div>
        
            <div class="dashboard-wrapper">
            <div class="container-fluid  dashboard-content">

                <div class="row">

<?php
                          $details=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `pin_request` WHERE `user_id`"));
                          ?>

                   <div class="col-12">
                         <div class="card">
                             <h5 class="card-header">Pin Requests</h5>
                             <div class="card-body">
                                 <div class="table-responsive">
                                     <table class="table table-striped table-bordered first">
                                         
                                         <thead>
                                             
          
                                            
                                             <tr>
                                                 <th>Sr no</th>
                                                 <th>Payment Reciept</th>
                                                 <th>User ID</th>
                                                 <th>Name</th>
                                                 <th>Message</th>
                                                 <th>Pin Amount</th>
                                                 <th>Request Date</th>
                                                 <th>Action</th>
                                             </tr>
                                         </thead>
                                          
                                         <tbody>
                                             <?php
                                           $a=0;
                                               $data=mysqli_query($conn,"SELECT * FROM `pin_request` WHERE `status`='0'");
                                               while ($d=mysqli_fetch_array($data)) {
                                                 ?>
                                            
                                             
                                <style>
                                    .php-image img{
                                        width:90px
                                    }
                                             </style>
                                             <script>
  new Zooming().listen('img')
</script>
                                                 <tr>
                                                    
                                                   <th><?php   echo "<p>". ++$a ."</p>"; ?></th>
                                                   <th><div class="php-image"><?php  echo "<img <img id='img' data-action='zoom' style='width:90px' src='../images/".$d['image']."' >"; ?></div></th>
                                                     <th><?php echo $d['user_id'] ?></th>
                                                   <th><?php echo $d['name'] ?></th>
                                                   <th><?php echo $d['messa'] ?></th>
                                                   <th><?php echo $d['pin'] ?></th>
                                                   <th><?php echo $d['timestamp'] ?></th>                                        
                                                   <th>
                                                       <form class="" action="element/redirect.php" method="post">
                                                           
                                                       <div class="form-group">
                                              <label for="inputPassword">ID</label>
                                              <input id="inputPassword" type="tel" required="" class="form-control" value="<?php echo $d['user_id'] ?>" name="id">
                                          </div>
                                          <div class="form-group">
                                              <label for="inputRepeatPassword">Pin count</label>
                                              <input id="inputRepeatPassword" data-parsley-equalto="#inputPassword" name="pin_count" type="text" placeholder="Enter Pin" class="form-control" oninput="this.value = this.value.toUpperCase()" value="<?php echo $d['pin'] ?>" required >
                                             
                                          </div>
                                                     
                                                       <input type="text" name="res_id" value="<?php echo $d['id'] ?>" hidden>
                                                       <button type="submit" class="btn btn-sm btn-secondary" name="send_epin">Approve</button>
                                                     </form>
                                                   </th>
                                                 </tr>
                                                 <?php
                                               }
                                                                                        
                                            ?>

                                         </tbody>
                                        
                                     </table>
                                 </div>
                             </div>
                         </div>
                     </div>

                 </div>

            </div>


        </div>
        
        </main>
    </div>
    
    
    
    

  <!-- ======= Footer ======= -->
  <footer id="footer" class="footer">
    <div class="copyright">
      &copy; Copyright <strong><span>Healthy Life Mission</span></strong>. All Rights Reserved
    </div>
    <div class="credits">
      <!-- All the links in the footer should remain intact. -->
      <!-- You can delete the links only if you purchased the pro version. -->
      <!-- Licensing information: https://bootstrapmade.com/license/ -->
      <!-- Purchase the pro version with working PHP/AJAX contact form: https://bootstrapmade.com/nice-admin-bootstrap-admin-html-template/ -->
      Designed by <a href="https://antiradiationchip.in/">Healthy Life Mission</a>
    </div>
  </footer><!-- End Footer -->

  <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

  <!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
    <!-- Optional JavaScript -->
    <script src="assets/vendor/jquery/jquery-3.3.1.min.js"></script>
    <script src="assets/vendor/bootstrap/js/bootstrap.bundle.js"></script>
    <script src="assets/vendor/slimscroll/jquery.slimscroll.js"></script>
    <script src="assets/vendor/multi-select/js/jquery.multi-select.js"></script>
    <script src="assets/libs/js/main-js.js"></script>
    <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
    <script src="assets/vendor/datatables/js/dataTables.bootstrap4.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
    <script src="assets/vendor/datatables/js/buttons.bootstrap4.min.js"></script>
    <script src="assets/vendor/datatables/js/data-table.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.colVis.min.js"></script>
    <script src="https://cdn.datatables.net/rowgroup/1.0.4/js/dataTables.rowGroup.min.js"></script>
    <script src="https://cdn.datatables.net/select/1.2.7/js/dataTables.select.min.js"></script>
    <script src="https://cdn.datatables.net/fixedheader/3.1.5/js/dataTables.fixedHeader.min.js"></script>

  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>

</html>