-
Notifications
You must be signed in to change notification settings - Fork 0
/
purchase.php
41 lines (35 loc) · 1.07 KB
/
purchase.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<?php
include('conn.php');
if(isset($_POST['productid'])){
$customer=$_POST['customer'];
$sql="insert into purchase (customer, date_purchase) values ('$customer', NOW())";
$conn->query($sql);
$pid=$conn->insert_id;
$total=0;
foreach($_POST['productid'] as $product):
$proinfo=explode("||",$product);
$productid=$proinfo[0];
$iterate=$proinfo[1];
$sql="select * from product where productid='$productid'";
$query=$conn->query($sql);
$row=$query->fetch_array();
if (isset($_POST['quantity_'.$iterate])){
$subt=$row['price']*$_POST['quantity_'.$iterate];
$total+=$subt;
$sql="insert into purchase_detail (purchaseid, productid, quantity) values ('$pid', '$productid', '".$_POST['quantity_'.$iterate]."')";
$conn->query($sql);
}
endforeach;
$sql="update purchase set total='$total' where purchaseid='$pid'";
$conn->query($sql);
header('location:sales.php');
}
else{
?>
<script>
window.alert('Please select a product');
window.location.href='order.php';
</script>
<?php
}
?>