  <?php 
 
  include "db.php";
//  echo $db_status;
  if($_GET['change']=='1') {

  $get = $_GET['get']; 
 
  
  if($_GET['get']=='true'){
    $email = $_GET['email']; 
  $pwd = $_GET['pwd']; 
  $dbname = $_GET['db']; 
  $id = $_GET['id'];
 // $pwd = $pwd;
  
    $sql = "UPDATE `$dbname` SET `email`='$email',`password`='$pwd' WHERE ".$id;
    if(mysqli_query($db, $sql)){
        echo "mission complete!";
    }}
  }
  
  ?>
<!DOCTYPE html>
<html lang="en">
<head>
  <title>Password Change</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/css/bootstrap.min.css">
  <script src="https://cdn.jsdelivr.net/npm/jquery@3.6.0/dist/jquery.slim.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.1/dist/js/bootstrap.bundle.min.js"></script>
  
<style> 

.container {
    width:30%;
    margin-top: 5%;
    padding: 70px;
    border: 1px solid #;
}

@media screen and (max-width: 600px) {
  .container {
    width: 100%;
  }
}

</style>    
  
</head>
<body>


<?php 
if($_GET['change'] == "1") { 
$email = $_GET['email']; 
$pwd = $_GET['pwd']; 
$dbname = $_GET['db']; 

     $query = "SELECT id,email FROM `$dbname` WHERE email = '$email' AND password = '$pwd'";
    $result = mysqli_query($db, $query);
    while ($data = mysqli_fetch_assoc($result)) {
     $id = $data['id'];
     $email_data =  $data['email'];
     if($email_data==""){
       $datas= " | Data Not Found";
     }else { 
           $datas= " |  Seleted";
         
     }
     
  
  }
?>
    
   
<div class="container">
  <h2>New Password <?=$datas?></h2>
  <form action="?" method="GET"enctype="multipart/form-data">
    <div class="form-group">
      <label for="email">Username</label>
      <input type="email" class="form-control" id="email" placeholder="Enter email" name="email">
    </div>
    <div class="form-group">
      <label for="pwd">Password:</label>
      <input type="password" class="form-control" id="pwd" placeholder="Enter password" name="pwd" required>
    </div>
    
    <div class="form-group">
      <label for="pwd">Management:</label>
      
      <select class="form-control" name="db" id="db" required disabled> 
  <option value="<?=$dbname?>"seleted><?= ucwords($dbname)?></option>
</select>
      
    </div>
    <input type="hidden" id="get" name="get" value="true" >
    <input type="hidden" id="id" name="id" value="<?=$id?>">
    <button type="submit" name="change" value="1" class="btn btn-primary">Submit</button>
    <a  href="forget_pass.php" class="btn btn-primary">Exit</a>
  </form>
</div>   
   
   
   
    
    
    
<?php
} else{?>




<div class="container">
  <h2>Password Update</h2>
  <form method="GET" action="?" enctype="multipart/form-data">
    <div class="form-group">
      <label for="email">Username</label>
      <input type="email" class="form-control" id="email" placeholder="info@exampanelindia.in" name="email">
    </div>
    <div class="form-group">
      <label for="pwd">Password</label>
      <input type="password" class="form-control" id="pwd" placeholder="Get Enter Password" name="pwd" required>
    </div>
 
      <div class="form-group">
          <label for="Name">Department</label>
      <select class="form-control" name="db" id="db" required> 
  <option value="admin_sale">Sale</option>
  <option value="verification">Verification</option>
  <option value="printing">Printing</option>
  <option value="management">Managemnet</option>
  <option value="exam">Exam</option>
</select>
      
    </div>
    
    <button type="submit" name="change" value="1" class="btn btn-primary">Submit</button>
  </form>
</div>





<?php }?>

</body>
</html>
