Edit: accept_clients.php

Editing: accept_clients.php

Kembali

<?php

include '../components/connect.php';

session_start();

$admin_id = $_SESSION['admin_id'];

if(!isset($admin_id)){
   header('location:admin_login.php');
};

<!DOCTYPE html>
<html lang="en">
<head>
   <meta charset="UTF-8">
   <meta http-equiv="X-UA-Compatible" content="IE=edge">
   <meta name="viewport" content="width=device-width, initial-scale=1.0">
   <title>Products</title>
   
   
   <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.1.1/css/all.min.css">

<link rel="stylesheet" href="../css/admin_style.css">

</head>
<body>
   
<?php include '../components/admin_header.php'; ?>

<?php
   if(isset($_POST['Accept'])){

$client_id = $_POST['client_id'];
      $client_id = filter_var($client_id, FILTER_SANITIZE_STRING);
      $client_name = $_POST['client_name'];
      $client_name = filter_var($client_name, FILTER_SANITIZE_STRING);
      $client_contact = $_POST['client_contact'];
      $client_contact = filter_var($client_contact, FILTER_SANITIZE_STRING);
      $client_email = $_POST['client_email'];
      $client_email = filter_var($client_email, FILTER_SANITIZE_STRING);
      $client_password = $_POST['client_password'];
      $client_password = filter_var($client_password, FILTER_SANITIZE_STRING);
      $category = $_POST['category'];
      $category = filter_var($category, FILTER_SANITIZE_STRING);

$select_clients =mysqli_query($conn,"SELECT * FROM client_login WHERE client_email = '$client_email';");
   // $select_careers->execute([$name]);

if(mysqli_num_rows($select_clients)> 0){
      $message[] = 'client already exist!';
   }else{

$insert_clients = mysqli_query($conn,"INSERT INTO `client_login`(client_id,client_name,client_contact,client_email,client_password,category) VALUES($client_id,'$client_name','$client_contact','$client_email','$client_password','$category')");
      // $insert_careers->execute([$name, $details, $link, $image_01, $image_02, $image_03]);
      echo(mysqli_error($conn));

if($insert_clients){
         $delete_buffer=mysqli_query($conn,"DELETE FROM `client_login_buffer` WHERE client_id='$client_id'");
         if($delete_buffer){
            $message[] = 'new Client added!';
         }

}
         else{
            $message[] = mysqli_error($conn);
         }

}
   
      
   
   };

if(isset($_POST['Drop'])){
      $client_id = $_POST['client_id'];
      $client_id = filter_var($client_id, FILTER_SANITIZE_STRING);

$delete_buffer=mysqli_query($conn,"DELETE FROM `client_login_buffer` WHERE client_id='$client_id'");
         if($delete_buffer){
            $message[] = 'Client Deleted!';
         }

}
   
   
   
   ?>

<h1 class="heading">Requested Clients</h1>

<?php
     $select_buffer_client = mysqli_query($conn,"SELECT * FROM `client_login_buffer`"); 
     if(mysqli_num_rows($select_buffer_client) > 0){
      while($fetch_buffer_client =mysqli_fetch_assoc($select_buffer_client)){
   ?>
   <form action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" method="post" class="box">
    
       <div class="flex">
      
      Name:<?= $fetch_buffer_client['client_name']?><br>
      Contact:<?= $fetch_buffer_client['client_contact']?><br>
      Email:<?= $fetch_buffer_client['client_email']?><br>
      Category:<?= $fetch_buffer_client['category']?><br>

</div>
      <div class="buttons-box">
         <input type="text"  name="client_id" value="<?= $fetch_buffer_client['client_id'] ?>" hidden/>
         <input type="text"  name="client_name" value="<?= $fetch_buffer_client['client_name'] ?>" hidden/>
         <input type="text"  name="client_contact" value="<?= $fetch_buffer_client['client_contact'] ?>" hidden/>
         <input type="text"  name="client_email" value="<?= $fetch_buffer_client['client_email'] ?>" hidden/>
         <input type="text"  name="client_password" value="<?= $fetch_buffer_client['client_password'] ?>" hidden/>
         <input type="text"  name="category" value="<?= $fetch_buffer_client['category'] ?>" hidden/>

</form>

<?php
      }
   }else{
      echo '<p class="empty">No Request!</p>';
   }

</div>

</section>

</body>
</html>