tK2jxnmE

1<?php 
2include '../../links/db.php';
3
4if(isset($_GET['sales_person'])){
5    $user=$_GET['sales_person'];
6
7    $get_from_cart=mysqli_query($con, "SELECT * FROM cart WHERE sales_person='chisom' ");
8    while($row=mysqli_fetch_assoc($get_from_cart)){
9        $user=$row['sales_person'];
10        $item=$row['item'];
11        $sold=$row['quantity'];
12        $amount=$row['price'];
13        
14    }
15$date=date('d/m/Y');
16    $create_sales=mysqli_query($con, "CREATE TABLE IF NOT EXISTS sales (id INT PRIMARY KEY AUTO_INCREMENT,user VARCHAR(20), products_sold VARCHAR(40), sold_quantity INT, amount_sold INT, date_sold VARCHAR(10)) ");
17    if($create_sales){
18        $insert_into_sales=mysqli_query($con, "INSERT INTO sales (user,products_sold,sold_quantity,amount_sold,date_sold) VALUES ('$user', '$item', '$sold', '$amount', '$date') ");
19        if($insert_into_sales){
20            $delete_cart=mysqli_query($con, "DELETE FROM cart WHERE sales_person='$user' ");
21            if($delete_cart){
22                echo "<h1>success</h1>";
23            }
24        }
25    }
26}
27
28?>