-
Notifications
You must be signed in to change notification settings - Fork 0
/
userDashboardAccountSettings.php
187 lines (133 loc) · 5.97 KB
/
userDashboardAccountSettings.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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
<?php session_start();
if(!isset($_SESSION["username"]))
{
header("Location:blocked.php");
$_SESSION['url'] = $_SERVER['REQUEST_URI'];
}
?>
<!DOCTYPE html>
<html lang="en">
<!-- HEAD TAG STARTS -->
<head>
<meta charset="UTF-8">
<meta name="author" content="Joydeep Dev Nath">
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<link rel="shortcut icon" href="images/favicon.ico">
<title>Dashboard | Project Meteor</title>
<link href="css/main.css" rel="stylesheet">
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-select.css" rel="stylesheet">
<link href="css/bootstrap-datetimepicker.css" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Oswald:200,300,400|Raleway:100,300,400,500|Roboto:100,400,500,700" rel="stylesheet">
<link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet">
<script src="js/jquery-3.2.1.min.js"></script>
<script src="js/userDashboard.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/bootstrap-select.js"></script>
<script src="js/bootstrap-dropdown.js"></script>
<script src="js/jquery-2.1.1.min.js"></script>
<script src="js/moment-with-locales.js"></script>
<script src="js/bootstrap-datetimepicker.js"></script>
</head>
<!-- HEAD TAG ENDS -->
<!-- BODY TAG STARTS -->
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "projectmeteor";
// Creating a connection to projectmeteor MySQL database
$conn = new mysqli($servername, $username, $password, $dbname);
// Checking if we've successfully connected to the database
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
<body>
<div class="container-fluid">
<div class="col-sm-12 userDashboard text-center">
<?php include("common/headerDashboardTransparentLoggedIn.php"); ?>
<div class="col-sm-12">
<div class="heading">
My Dashboard
</div>
</div>
<div class="col-sm-1"></div>
<div class="col-sm-3 containerBoxLeft">
<a href="userDashboardProfile.php">
<div class="col-sm-12 menuContainer bottomBorder">
<span class="fa fa-user-o"></span> My Profile
</div>
</a>
<a href="userDashboardBookings.php">
<div class="col-sm-12 menuContainer bottomBorder">
<span class="fa fa-copy"></span> My Bookings
</div>
</a>
<a href="userDashboardETickets.php">
<div class="col-sm-12 menuContainer bottomBorder">
<span class="fa fa-clone"></span> My E-Tickets
</div>
</a>
<a href="userDashboardCancelTicket.php">
<div class="col-sm-12 menuContainer bottomBorder">
<span class="fa fa-close"></span> Cancel Ticket
</div>
</a>
<div class="col-sm-12 menuContainer active">
<span class="fa fa-bar-chart"></span> Account Stats
</div>
</div>
<div class="col-sm-7 containerBoxRight text-left">
<?php
$user = $_SESSION["username"];
$flightBookingsSQL = "SELECT COUNT(*) FROM `flightbookings` WHERE Username='$user'";
$flightBookingsQuery = $conn->query($flightBookingsSQL);
$noOfFlightBookings = $flightBookingsQuery->fetch_array(MYSQLI_NUM);
$hotelBookingsSQL = "SELECT COUNT(*) FROM `hotelbookings` WHERE Username='$user'";
$hotelBookingsQuery = $conn->query($hotelBookingsSQL);
$noOfHotelBookings = $hotelBookingsQuery->fetch_array(MYSQLI_NUM);
$cabBookingsSQL = "SELECT COUNT(*) FROM `cabbookings` WHERE Username='$user'";
$cabBookingsQuery = $conn->query($cabBookingsSQL);
$noOfCabBookings = $cabBookingsQuery->fetch_array(MYSQLI_NUM);
$busBookingsSQL = "SELECT COUNT(*) FROM `busbookings` WHERE Username='$user'";
$busBookingsQuery = $conn->query($busBookingsSQL);
$noOfBusBookings = $busBookingsQuery->fetch_array(MYSQLI_NUM);
$trainBookingsSQL = "SELECT COUNT(*) FROM `trainbookings` WHERE Username='$user'";
$trainBookingsQuery = $conn->query($trainBookingsSQL);
$noOfTrainBookings = $trainBookingsQuery->fetch_array(MYSQLI_NUM);
?>
<div class="col-sm-12 settings">
<div class="col-sm-6 settingsWrapper topMargin">
<span class="tag">No. of flight bookings: </span><span class="content"><?php echo $noOfFlightBookings[0]; ?> </span>
</div>
<div class="col-sm-6 settingsWrapper topMargin">
<span class="tag">No. of train bookings: </span><span class="content text"><?php echo $noOfTrainBookings[0];?> </span>
</div> <!-- change echo -->
<div class="col-sm-6 settingsWrapper">
<span class="tag">No. of bus bookings: </span><span class="content"><?php echo $noOfBusBookings[0]; ?> </span>
</div> <!-- change echo -->
<div class="col-sm-6 settingsWrapper">
<span class="tag">No. of cab bookings: </span><span class="content text"><?php echo $noOfCabBookings[0]; ?> </span>
</div> <!-- change echo -->
<div class="col-sm-12 settingsWrapper">
<span class="tag">No. of hotel bookings: </span><span class="content"><?php echo $noOfHotelBookings[0]; ; ?> </span>
</div> <!-- change echo -->
<div class="col-sm-6 settingsWrapper">
<span class="tag">Delete account: </span>
<input type="button" class="button" id="deleteAccount" name="deleteAccount" value="Delete Account">
</div> <!-- change echo -->
<div class="col-sm-6 settingsWrapper warning">
Please note that deleting an account is irreversible. If you delete an account, you will lose access to all the data and E-tickets asociated with that account. Proceed with caution.
</div>
</div>
</div>
<div class="col-sm-1"></div>
<div class="col-sm-12 spacer">a</div>
<div class="col-sm-12 spacer">a</div>
</div>
</div> <!-- container-fluid -->
<?php include("common/footer.php"); ?>
</body>
<!-- BODY TAG ENDS -->
</html>