php/dashboard.php
#shows events the user has not signed up for in tabular form
shows events the user has not signed up for in tabular form
shows events the user has not signed up for in tabular form
function displayNotGoing($connect, $username) {
	print"
	<h3> <center>Events you're not signed up for </center></h3>
	<table align = 'center' border = '1' width = 80%>
	<tr>
	<th>Event ID </th>
	<th>Event Name</th>
	<th>Date</th>
	<th>Start Time</th>
	<th>End Time</th>
	<th>Location</th>
	</tr>";
	$going = "
	SELECT EventID, Name, EventDate, StartTime, EndTime, Location
	FROM Events 
	WHERE EventID not in (SELECT EventID from Going WHERE Username = '".$username."')"; 
	$result = mysqli_query($connect, $going);
	while ($row = $result->fetch_row())
	{	
		print"
		<tr>
		<td>".$row[0]."</td>
		<td>".$row[1]."</td>
		<td>".$row[2]."</td>
		<td>".$row[3]."</td>
		<td>".$row[4]."</td>
		<td>".$row[5]."</td>
		</tr>";
	}
	$result->free();	
	print"
	</table>
	<br/><br/>";
}
function displayNotGoing ( $ connect , $ username ) { print " 
	<h3> <center>Events you're not signed up for </center></h3>
	<table align = 'center' border = '1' width = 80%>
	<tr>
	<th>Event ID </th>
	<th>Event Name</th>
	<th>Date</th>
	<th>Start Time</th>
	<th>End Time</th>
	<th>Location</th>
	</tr> " ; $ going = " 
	SELECT EventID, Name, EventDate, StartTime, EndTime, Location
	FROM Events 
	WHERE EventID not in (SELECT EventID from Going WHERE Username = ' " . $ username . " ') " ; $ result = mysqli_query ( $ connect , $ going ) ; while ( $ row = $ result -> fetch_row ( ) ) { print " 
		<tr>
		<td> " . $ row [ 0 ] . " </td>
		<td> " . $ row [ 1 ] . " </td>
		<td> " . $ row [ 2 ] . " </td>
		<td> " . $ row [ 3 ] . " </td>
		<td> " . $ row [ 4 ] . " </td>
		<td> " . $ row [ 5 ] . " </td>
		</tr> " ; } $ result -> free ( ) ; print " 
	</table>
	<br/><br/> " ; }
shows events the user has not signed up for in tabular form
shows events the user has not signed up for in tabular form