-
Notifications
You must be signed in to change notification settings - Fork 4
/
action.php
110 lines (92 loc) · 3.46 KB
/
action.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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<?php
session_start();
require 'admin/includes/db.php';
if(isset($_POST['pid'])){
$pid = $_POST['pid'];
$pname = $_POST['pname'];
$pprice = $_POST['pprice'];
$pcode = $_POST['pcode'];
$pqty = 1;
$stmt = $connect->prepare("SELECT product_code FROM cart WHERE product_code=?");
$stmt->bind_param("s",$pcode);
$stmt->execute();
$res = $stmt->get_result();
$r = $res->fetch_assoc();
$code = $r['product_code'];
if(!$code){
$query = $connect->prepare("INSERT INTO cart(product_name,product_price,qty,total_price,product_code) VALUES (?,?,?,?,?)");
$query->bind_param("ssiss",$pname,$pprice,$pqty,$pprice,$pcode);
$query->execute();
echo '<div class="alert alert-success alert-dismissible">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong>Item added to your cart!</strong>
</div>';
}else{
echo '<div class="alert alert-danger alert-dismissible">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong>Item already added to your cart!</strong>
</div>';
}
}
if (isset($_GET['cartItem']) && isset($_GET['cartItem']) == 'cart_item') {
$stmt = $connect->prepare("SELECT * FROM cart");
$stmt->execute();
$stmt->store_result();
$rows = $stmt->num_rows;
echo $rows;
}
if (isset($_GET['remove'])){
$id = $_GET['remove'];
$stmt = $connect->prepare("DELETE FROM cart WHERE id=?");
$stmt->bind_param("i",$id);
$stmt->execute();
$_SESSION['showAlert'] = 'block';
$_SESSION['message'] = 'Item removed from the cart!';
header('location:order-cart.php');
}
if(isset($_GET['clear'])){
$stmt = $connect->prepare("DELETE FROM cart");
$stmt->execute();
$_SESSION['showAlert'] = 'block';
$_SESSION['message'] = 'All items removed from the cart!';
header('location:order-cart.php');
}
if (isset($_POST['qty'])) {
$qty = $_POST['qty'];
$pid = $_POST['pid'];
$pprice = $_POST['pprice'];
$tprice = $qty * $pprice;
$stmt = $connect->prepare("UPDATE cart SET qty=?, total_price=? WHERE id=?");
$stmt->bind_param('isi',$qty,$tprice,$pid);
$stmt->execute();
}
if(isset($_POST['action']) && isset($_POST['action']) == 'order'){
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$products = $_POST['products'];
$total = $_POST['total'];
$status = 'Not confirmed';
$data = '';
$stmt = $connect->prepare("INSERT INTO orders (firstname,lastname,email,contact,products,amount_paid,status) VALUES(?,?,?,?,?,?,?)");
$stmt->bind_param('sssisss',$fname,$lname,$email,$phone,$products,$total,$status);
$stmt->execute();
$data .= '<div class="text-center">
<h1 class="display-4 mt-2 text-danger">Thank You!</h1>
<h2 class="text-success">Your Order Is Placed Successfully!</h2>
<h2 class="text-danger">Admin Will Contact You When Your Order Is Ready!</h2>
<h4 class="bg-info text-light rounded p-2">Items Purchased : '.$products.'</h4>
<h4>Your First Name: '.$fname.'</h4>
<h4>Your Last Name: '.$lname.'</h4>
<h4>Your Email: '.$email.'</h4>
<h4>Your Phone Number: '.$phone.'</h4>
<h4>Total Amount Paid: '.number_format($total,2).'</h4><br><br>
<a href="Invoices/meal.php" class="btn btn-primary align-self-center mb-1" target="_blank">Generate Invoice</a>
<a href="index.php" class="btn btn-success btn-block">Back To Home</a>
</div>';
echo $data;
$stmt = $connect->prepare("DELETE FROM cart");
$stmt->execute();
}
?>