-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathview-order.php
150 lines (139 loc) · 6.43 KB
/
view-order.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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<?php
ob_start();
session_start();
require_once "config/connect.php";
if(!isset($_SESSION['customer']) & empty($_SESSION['customer'])){
header('location: login.php');
}
include 'inc/header.php';
include 'inc/nav.php';
$uid = $_SESSION['customerid'];
// $cart = $_SESSION['cart'];
$cart=[ ];
if(isset($_SESSION['cart'])){
$cart = $_SESSION['cart'];
}
?>
<!-- SHOP CONTENT -->
<section id="content">
<div class="content-blog content-account">
<div class="container">
<div class="row">
<div class="page_header text-center">
<h2>My Account</h2>
</div>
<div class="col-md-12">
<h3>Recent Orders</h3>
<br>
<table class="cart-table account-table table table-bordered">
<thead>
<tr>
<th>Product Name</th>
<th>Quantity</th>
<th>Price</th>
<th></th>
<th>Total Price</th>
</tr>
</thead>
<tbody>
<?php
if(isset($_GET['id']) & !empty($_GET['id'])){
$oid = $_GET['id'];
}else{
header('location: my-account.php');
}
$ordsql = "SELECT * FROM orders WHERE uid='$uid' AND id='$oid'";
$ordres = mysqli_query($connection, $ordsql);
$ordr = mysqli_fetch_assoc($ordres);
$orditemsql = "SELECT * FROM orderitems o JOIN products p WHERE o.orderid='$oid' AND o.pid=p.id";
$orditemres = mysqli_query($connection, $orditemsql);
while($orditemr = mysqli_fetch_assoc($orditemres)){
?>
<tr>
<td>
<a href="single.php?id=<?php echo $orditemr['pid']; ?>"><?php echo substr($orditemr['name'], 0, 25); ?></a>
</td>
<td>
<?php echo $orditemr['pquantity']; ?>
</td>
<td>
<?php echo $orditemr['productprice']; ?> BDT
</td>
<td></td>
<td>
<?php echo $orditemr['productprice'] * $orditemr['pquantity']; ?> BDT
</td>
</tr>
<?php } ?>
<tr>
<td></td>
<td></td>
<td></td>
<td>
Order Total
</td>
<td>
<?php echo $ordr['totalprice']; ?>
</td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td>
Order Status
</td>
<td>
<?php echo $ordr['orderstatus']; ?>
</td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td>
Order Placed On
</td>
<td>
<?php echo $ordr['timestamp']; ?>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<div class="ma-address">
<h3>My Addresses</h3>
<p>The following addresses will be used on the checkout page by default.</p>
<div class="row">
<div class="col-md-6">
<h4>My Address <a href="update-details.php">Edit</a></h4>
<?php
$csql = "SELECT u1.firstname, u1.lastname, u1.address1, u1.address2, u1.city, u1.state, u1.country, u1.company, u.email, u1.phone, u1.zip FROM users u JOIN usersmeta u1 WHERE u.id=u1.uid AND u.id=$uid";
$cres = mysqli_query($connection, $csql);
if(mysqli_num_rows($cres) == 1){
$cr = mysqli_fetch_assoc($cres);
echo "<p>". $cr['firstname'] ." ". $cr['lastname'] ."</p>";
echo "<p>". $cr['address1'] ."</p>";
echo "<p>". $cr['address2'] ."</p>";
echo "<p>". $cr['city'] ."</p>";
echo "<p>". $cr['state'] ."</p>";
echo "<p>". $cr['country'] ."</p>";
echo "<p>". $cr['company'] ."</p>";
echo "<p>". $cr['zip'] ."</p>";
echo "<p>". $cr['phone'] ."</p>";
echo "<p>". $cr['email'] ."</p>";
}
?>
</div>
<div class="col-md-6">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</section>
<?php include 'inc/footer.php' ?>