DbLocal/ReserveSeat.php at master · dranelol/DbLocal · GitHub

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
<?php

// Author: Matt Wallace
// Last Edited: 04/28/2015
// I promise this is my code.
// Description:
// Checks reservation info for if it is a valid reservation


	include "login.php";

	if(isset($_SESSION["userType"]) == false)
	{
		echo "Not logged in!";
		echo '<br><br>';
		echo '<a href ="LoginPage.php">Go Log In</a>';

		die();
	}

?>
<html>
<head>
<title>
Reserve a Seat
</title>
</head>

<h3>Reserve a Seat</h3>
<body>

<?php

	$sessionUser = $_SESSION['userType'];

	if($sessionUser != "member")
	{
		echo 'Not logged in as a member!';
		echo '<br><br>';
		echo '<a href ="LoginPage.php">Go Log In</a>';

		die();
	}

	echo "Logged in as: $sessionUser";
	if($sessionUser == "member")
	{
		echo "<br>Membership ID: " . $_SESSION['memberID'] . "<br>";
	}

	$date = $_SESSION["today"];
	echo "<br>";
	echo "Today's date: $date";

?>

<br>
<br>

<?php


	if(isset($_POST['row']) && isset($_POST['column']) && isset($_POST['showingID']) && isset($_POST['memberInfo']))
	{
		$rowSelect = $_POST['row'];
		$column = $_POST['column'];
		$showingID = $_POST['showingID'];
		$membershipID = $_SESSION['memberID'];

		if($_POST['memberInfo'] == '')
		{
			echo "No member for account selected for reservation! <br>";
			echo '<br><a href ="index.php">Go to Index</a>';
			die();
		}

		$memberInfo = explode(":", $_POST['memberInfo']);

		$memberName = $memberInfo[0];
		$member = $memberInfo[1];

		$ageQuery = "select M.Age from Member M where M.ID = '$member'";
		$ageResult = mysql_query($ageQuery) or die(mysql_error());
		$age = '';

		if($row = mysql_fetch_array($ageResult))
		{
			$age = $row['Age'];

		}

		$ratingQuery = "select M.Rating from Movie M, MovieShowing S where S.ID = '$showingID' and S.MovieID = M.ID";
		$ratingResult = mysql_query($ratingQuery) or die(mysql_error());
		$rating = '';
		if($row = mysql_fetch_array($ratingResult))
		{
			$rating = $row['Rating'];
		}

		if($age < 17 && $rating == "R")
		{
			echo "Member is too young to reserve a seat for this movie! <br>";

			echo '<br><a href ="index.php">Go to Index</a>';
			die();
		}

		$memberCountQuery = "select count(*) as mCount from Member M where M.MemberAcctNum='$membershipID'";
		$memberCountResult = mysql_query($memberCountQuery) or die(mysql_error());

		$memberCountReservationsQuery = "select count(*) as rCount from Reservation R where R.MovieShowingID = '$showingID' and R.MembershipID = '$membershipID'";
		$memberCountReservationsResult = mysql_query($memberCountReservationsQuery) or die(mysql_error());

		$row1 = mysql_fetch_array($memberCountResult);
		$membersCount = $row1['mCount'];

		$row2 = mysql_fetch_array($memberCountReservationsResult);
		$reservationsCount = $row2['rCount'];

		if($reservationsCount < $membersCount)
		{
			echo "You selected a reservation for "
			. $memberName . " on row: "
			. $rowSelect . " and seat: "
			. $column;

			echo "<form action = 'ConfirmSeatReservation.php' method = 'post'>";
			echo "<input type ='hidden' value = '$rowSelect' name ='row'>";
			echo "<input type ='hidden' value = '$showingID' name ='showingID'>";
			echo "<input type ='hidden' value = '$column' name ='column'>";
			echo "<input type ='hidden' value = '$member' name ='memberID'>";
			echo "<input type='submit' value='Confirm Seat Reservation'>";

			echo "</form>";
		}

		else
		{
			echo '<br>Too many reservations for this showing have been made for your account!';
			echo "<br>";
			echo "<form action ='index.php'>";
			echo "<input type ='submit' value = 'Go back to index' >";
			echo "</form>";
			die();
		}


	}

	else
	{
		echo '<br>Got here illegally!';
		echo "<br>";
		echo "<form action ='index.php'>";
		echo "<input type ='submit' value = 'Go back to index' >";
		echo "</form>";
	}
?>

</body>
</html>