DbLocal/ViewMembershipInfo.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
<?php

// Author: Matt Wallace
// Last Edited: 04/28/2015
// I promise this is my code.
// Description:
// View the membership info for the currently logged-in membership


	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>
View Membership Information
</title>
</head>

<h3>
View Membership Information
</h3>
<body>

<?php

	$sessionUser = $_SESSION['userType'];

	// restrict access only to certain userTypes


	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

	// CODE STARTS HERE
	$membershipID = $_SESSION['memberID'];
	$membershipQuery = "select M.StartDate, M.EndDate from Membership M where M.AcctNum = '$membershipID'";
	$membershipResult = mysql_query($membershipQuery) or die (mysql_error());

	$startDate = '';
	$startDateFormatted = '';
	$endDate = '';
	$endDateFormatted = '';

	if($row = mysql_fetch_array($membershipResult))
	{
		$startDate = $row['StartDate'];
		$startDateFormatted = explode("-", $startDate );
		$startDateFormatted = date("m/d/Y", mktime(0,0,0, $startDateFormatted[1], $startDateFormatted[2], $startDateFormatted[0]));

		$endDate = $row['EndDate'];
		$endDateFormatted = explode("-", $endDate );
		$endDateFormatted = date("m/d/Y", mktime(0,0,0, $endDateFormatted[1], $endDateFormatted[2], $endDateFormatted[0]));

	}

	echo "Start date for your membership: " . $startDateFormatted . "<br>";
	echo "End date for your membership: " . $endDateFormatted . "<br>";

	$membersQuery = "select * from Member M where M.MemberAcctNum = '$membershipID' order by M.MemberAcctOrder";
	$membersResult = mysql_query($membersQuery) or die(mysql_error());

	$primaryMemberID = '';

	$primaryMemberQuery = "select M.PrimaryMemberID from Membership M where M.AcctNum = '$membershipID'";
	$primaryMemberResult = mysql_query($primaryMemberQuery) or die(mysql_error());

	if($rowResult = mysql_fetch_array($primaryMemberResult))
	{
		$primaryMemberID = $rowResult['PrimaryMemberID'];
	}

	echo "Members in membership: <br>";

	echo "<table border = \'1\' cellpadding = \'10\'>";
	echo "<tr>
			  <th>Name</th>
			  <th>Address </th>
			  <th>Email</th>
			  <th>Phone Number</th>
			  <th>Age</th
			  </tr>";

	while($row = mysql_fetch_array($membersResult))
	{
		$name = '';
		if($row['ID'] == $primaryMemberID)
		{
			$name = $row['Name'] . '*';
		}
		else
		{
			$name = $row['Name'] ;
		}

		echo "<tr>
						  <td>" . $name . "</td>
						  <td>" . $row['Address'] . "</td>
						  <td>" . $row['Email'] . "</td>
						  <td>" . $row['PhoneNumber'] . "</td>
						  <td>" . $row['Age'] . "</td>
			   </tr>";
	}

	echo "</table>";
	echo "* denotes primary member for membership account";
	echo "<br>";
	echo "<form action ='index.php'>";
	echo "<input type ='submit' value = 'Go back to index' >";
	echo "</form>";
?>

</body>
</html>