Edit: index.php

Editing: index.php

Kembali

<?php

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

session_start();

$client_email = $_SESSION['client_email'];
$client_category=$_SESSION['client_category'];
$client_contact=$_SESSION['client_contact'];

if(!isset($client_email)){
   header('location:client_login.php');
}
// echo($_SESSION['client_contact']);

<!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">

}
  
  }

</style>

</head>

<?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!';
         }

}
   
   
   
   ?>

<?php
     $select_request = mysqli_query($conn,"SELECT * FROM `request_quotation` WHERE category='$client_category'"); 
     if(mysqli_num_rows($select_request) > 0){
      while($fetch_request =mysqli_fetch_assoc($select_request)){
         $p_id=$fetch_request['id'];

$select_average=mysqli_query($conn,"SELECT AVG(quotation_product) FROM `quotataion_from_client` WHERE product_id='$p_id'");
         
         if($select_average){
            $fetch_average=mysqli_fetch_assoc($select_average);
            $average=$fetch_average['AVG(quotation_product)'];
         }
         else{
            echo(mysqli_error($conn));
         }

?>
   <div class="box">

<div class="flex">
         
         Product:<?= $fetch_request['product_name']?><br>

Message:<?= $fetch_request['message']?><br>
         
   </div>
         <div class="flex">
         
         Category:<?= $fetch_request['category']?><br>
         Average Quotation Price:<br> <?= $average ?><br> 
         
         <div>
            
            </div>
         </div >
      </div>
      <div class="buttons-box">

<button name="quotebtn" class=" btn" id="modal-btn" style="text-align:center">Get Quote</button>
      </div>
   </div>

<?php
   include './client_modal.php';

}
   }else{
      echo '<p class="empty">No Request!</p>';
   }
   if (isset($_POST['price'])) {
      $quotataion=$_POST['price'];
      $msg = $_POST['msg'];
      $client_contact = $_POST['client_contact'];
      $client_email = $_POST['client_email'];
      $product_id=$_POST['pid'];
         // print_r($shipping_term,$inspection,$packaging_term);
      // echo($product_name);
      
      
      $insert_quote = mysqli_query($conn, "INSERT INTO quotataion_from_client (client_contact,client_email,quotation_product,message,product_id) 
      VALUES('$client_contact','$client_email',$quotataion,'$msg','$product_id')");
      if($insert_quote){
         $message='Done';
         //  echo('done');
      }else{
      echo(mysqli_error($conn));
      }
      
      }

</div>

</section>

</body>
</html>