DbLocal/ViewingHistory.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
163
164
165
166
167
168
169
170
171
172
173
<!--
Name: Matthew Williamson
CLID: MCW4553
Date: 4/29/2015
CoA: I certify this is entirely my work
-->

<?php
	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> Movie Viewing History</title>
		<style>
			hr {
				display: block;
				margin-top: 0.5em;
				margin-bottom: 0.5em;
				margin-left: auto;
				margin-right: auto;
				border-style: inset;
				border-width: 1px;
			}
		</style>
	</head>

<h3>Movie Viewing History</h3><hr>

<body>

<?php

	$sessionUser = $_SESSION['userType'];
	$date = $_SESSION["today"];
	$time = date('Y-m-d');
	$currentMember = $_SESSION['memberID'];

	echo "Logged in as: <b> $sessionUser </b><br>";
	echo "Member ID: <b>";
	if($currentMember == NULL)
		echo("NULL");
	else
		echo($currentMember);

	echo"</b> <br>";

	echo "Today's date: <b>$date</b> <br>";
	echo "<hr>";

?>

<!--
|Movie viewing history|
	-For either a selected individual or a selected account, show a list of the movies they have seen.
	-If the listing is for an account, list the movies seen by each member associated with the account.
	-The account history will be in alphabetical order by movie title within member (in alphabetical order).
-->
<form action = 'ViewingHistory.php' method = 'post'>
	<?php
    //did we click the Submit button without anything selected?
    if(isset($_POST['SubmitAccount']))
    {
    //do nothing
    }
    else//display the dropdown and set the AccountSelection post
    {
        //this is what gets posted to the next page from the action
        echo "<h1>Select Account</h1>";
        echo "<select name = 'AccountSelection'>";
        echo "<option selected='true' disabled='true' > Choose an Account...</option>";
        $AccountQuery = "select distinct AcctNum from Membership";
        $AccountResult = mysql_query($AccountQuery) or die(mysql_error());

        while($row = mysql_fetch_array($AccountResult))
        {
            $accountID = $row['AcctNum'];
            echo "<option value = '$accountID' align = center> $accountID";
            echo "</option>";
        }

        echo"</select>";
        echo "<input type= 'submit' value='Submit' name = 'SubmitAccount'>";
    }
    ?>

</form>
<form action = 'DatView.php' method = 'POST'>
<?php
    //if the user clicked the SubmitAccount button
    if(isset($_POST['SubmitAccount']))
    {   //if the AccountSelection was posted from ViewingHistory.php /this page/
        if(isset($_POST['AccountSelection']))
        {
            //alias for the AccountSelection post
            $acc = $_POST['AccountSelection'];

            echo "<h1>Select a Member from Account $acc</h1>";
            //selection name for the dropdown this is what gets sent to DatView.php
            echo"<select name = 'MemberSelection'>";
            //make all the default option
            //if this is selected then all entries are shown for the account
            echo "<option selected='true'> All </option>";
            //query the members where select all members that match the account posted
            $memberQuery = "SELECT * FROM Member where MemberAcctNum = $acc";
            $memberResult = mysql_query($memberQuery) or die(mysql_error());

            while($row = mysql_fetch_array($memberResult))
            {
                $memberID = $row['Name'];
                echo "<option value = '$memberID' > $memberID </option> style='height:25px; width:100px'> ";
            }

            echo"</select>";
            echo"<input type = 'hidden' value = '$acc' name = 'AccountSelection'>";
            echo"<input type = 'submit' value = 'Submit'>";

        }
        else
        {
            echo("<h1>No account selected please select an account...</h1>");

        }
    }

?>
</form>


<form action = 'ViewingHistory.php'>

	<?php

    if(isset($_POST['SubmitAccount']) )
    {
        echo"<input type = 'submit' value = 'Cancel' name = 'Cancel'  style='height:20px; width:100px'>  ";
    }

 	?>

</form>

<form action = 'index.php'>
	<?php
		echo"<input type ='submit' value = 'Go back to index' >";
	?>
</form>
</body>
</html>