-
Notifications
You must be signed in to change notification settings - Fork 0
/
buycartproducts.php
75 lines (70 loc) · 2.22 KB
/
buycartproducts.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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
<!DOCTYPE>
<html>
<script type="text/javascript">
var store_name = 'E-Store Management System'
document.title=store_name;
document.write("<center><h1>",store_name,"<h1></center>");
</script>
<?php
include 'connection.php';
$conn = OpenCon();
if (mysqli_connect_errno())
{
echo "Unable to connect to server " . mysqli_connect_error();
}
$insert_conn = OpenCon();
if (mysqli_connect_errno())
{
echo "Unable to connect to server " . mysqli_connect_error();
}
session_start();
$username = $_SESSION["username"];
if($_SESSION['admin'] == true)
{
echo '<script>window.history.back()</script>';
exit;
}
if($_SESSION['logged_in'] == false)
{
echo '<script>alert("You are not logged in. You must be logged in to view this page.")</script>';
echo '<script>window.history.back()</script>';
exit;
}
$query='SELECT order_id from orders ORDER by order_id DESC';
$result=mysqli_query($conn,$query);
$row = $result->fetch_assoc();
$order = $row['order_id'];
$order = $order+1;
$query='INSERT INTO orders(user_id,order_id,status) VALUES('.$username.','.$order.',\'pending\')';
$result = mysqli_query($conn, $query);
$query = 'SELECT product_id,quantity,total FROM cart where user_id = '.$username;
$result = mysqli_query($conn, $query);
if($result->num_rows == 0)
{
echo '<script>alert("No products in cart");</script>';
echo '<script>window.history.back();</script>';
exit;
}
else
{
while($row = $result->fetch_assoc())
{
$prod_id = $row['product_id'];
$quan = $row['quantity'];
$tot = $row['total'];
$insert_query = 'INSERT INTO buy(user_id,product_id,quantity,total,order_id) VALUES('.$username.','.$prod_id.','.$quan.','.$tot.','.$order.')';
$insert_result = mysqli_query($insert_conn,$insert_query);
if($insert_result == 0)
{
echo '<script>alert("Error ordering products. Please try later")</script>';
exit;
}
}
$query = 'DELETE FROM cart where user_id='.$username;
$result = mysqli_query($conn, $query);
echo '<script>alert("Your products has been ordered. Your ORDERID = '.$order.'. You will soon have your order at door step");</script>';
echo '<script>window.history.back();</script>';
exit;
}
?>
</html>