-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmy-account.php
120 lines (110 loc) · 5.24 KB
/
my-account.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
<?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" style="background: #ADA996; /* fallback for old browsers */
background: -webkit-linear-gradient(to top, #EAEAEA, #DBDBDB, #F2F2F2, #ADA996); /* Chrome 10-25, Safari 5.1-6 */
background: linear-gradient(to top, #EAEAEA, #DBDBDB, #F2F2F2, #ADA996); /* W3C, IE 10+/ Edge, Firefox 16+, Chrome 26+, Opera 12+, Safari 7+ */
">
<thead>
<tr>
<th>Order</th>
<th>Date</th>
<th>Status</th>
<th>Payment Mode</th>
<th>Total</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$ordsql = "SELECT * FROM orders WHERE uid='$uid'";
$ordres = mysqli_query($connection, $ordsql);
while($ordr = mysqli_fetch_assoc($ordres)){
?>
<tr>
<td>
<?php echo $ordr['id']; ?>
</td>
<td>
<?php echo $ordr['timestamp']; ?>
</td>
<td>
<?php echo $ordr['orderstatus']; ?>
</td>
<td>
<?php echo $ordr['paymentmode']; ?>
</td>
<td>
<?php echo $ordr['totalprice']; ?> BDT
</td>
<td>
<a href="view-order.php?id=<?php echo $ordr['id']; ?>">View</a>
<?php if($ordr['orderstatus'] != 'Cancelled'){ ?>
| <a href="cancel-order.php?id=<?php echo $ordr['id']; ?>">Cancel</a>
<?php } ?>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<br>
<br>
<br>
<div class="ma-address">
<h3>My Account Details</h3>
<p>The following information will be used on the checkout page by default.</p>
<div class="row">
<div class="col-md-6">
<h4>Details <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' ?>