php/dashboard.php
#displays details of an event given EventID
displays details of an event given EventID
displays details of an event given EventID
function details($connect, $id) {
	$ID = mysqli_real_escape_string($connect, $id);
  	$sql = "SELECT * FROM Events WHERE EventID = '$ID';";
 	$ary = mysqli_fetch_array(mysqli_query($connect, $sql));
  	print"
  	<table border='1px'>
    <tr><td colspan='2' ALIGN=CENTER>Event Info</td></tr>
    <tr><td>"."Event Name</td><td>".$ary[1]."</td></tr>
    <tr><td>Event Date</td><td>".$ary[2]."</td></tr>
    <tr><td>Event Time</td><td>".$ary[3]." - ".$ary[4]."</td></tr>
    <tr><td>Event Location</td><td>".$ary[5]."</td></tr>
    <tr><td>Event Description</td><td>".$ary[6]."</td></tr>
    <tr><td>Event Cost</td><td>".$ary[9]."</td></tr>";
	$sql2 = "SELECT * FROM Users WHERE Username = '$ary[8]';";
	$ary2 = mysqli_fetch_array(mysqli_query($connect, $sql2));
	print "<tr><td>Officer's Name</td>
    <td>".$ary2[2]." ".$ary2[3]."</td></tr>
    <tr><td>Officer's Email</td>
    <td>".$ary2[5]."</td></tr>
    <tr><td>Officer's Number</td>
    <td>".$ary2[4]."</td></tr></table>";
}
function details ( $ connect , $ id ) { $ ID = mysqli_real_escape_string ( $ connect , $ id ) ; $ sql = " SELECT * FROM Events WHERE EventID = ' $ ID '; " ; $ ary = mysqli_fetch_array ( mysqli_query ( $ connect , $ sql ) ) ; print " 
  	<table border='1px'>
    <tr><td colspan='2' ALIGN=CENTER>Event Info</td></tr>
    <tr><td> " . " Event Name</td><td> " . $ ary [ 1 ] . " </td></tr>
    <tr><td>Event Date</td><td> " . $ ary [ 2 ] . " </td></tr>
    <tr><td>Event Time</td><td> " . $ ary [ 3 ] . "  -  " . $ ary [ 4 ] . " </td></tr>
    <tr><td>Event Location</td><td> " . $ ary [ 5 ] . " </td></tr>
    <tr><td>Event Description</td><td> " . $ ary [ 6 ] . " </td></tr>
    <tr><td>Event Cost</td><td> " . $ ary [ 9 ] . " </td></tr> " ; $ sql2 = " SELECT * FROM Users WHERE Username = ' $ ary [ 8 ] '; " ; $ ary2 = mysqli_fetch_array ( mysqli_query ( $ connect , $ sql2 ) ) ; print " <tr><td>Officer's Name</td>
    <td> " . $ ary2 [ 2 ] . " " . $ ary2 [ 3 ] . " </td></tr>
    <tr><td>Officer's Email</td>
    <td> " . $ ary2 [ 5 ] . " </td></tr>
    <tr><td>Officer's Number</td>
    <td> " . $ ary2 [ 4 ] . " </td></tr></table> " ; }
displays details of an event given EventID
displays details of an event given EventID