<!-- Gabriella Snowman
	Assignment 5
	searchRes.php
	Shows users search results matching their course name input
	-->

<CENTER>
<?php

	$course = $_POST['course'];

	$host = 'localhost';
	$user = 'gmsnowman';
	$passwd = 'cs389';
	$database = 'gmsnowman';

	$connect = mysqli_connect($host, $user, $passwd);
	$query = "select GENDER, GRADE, LECT_PREP, STU_PART, OVERALL from EVALUATION where COURSE = '$course' ";

	mysqli_select_db($connect, $database);
	$result_id = mysqli_query($connect, $query);

	if($result_id)
	{
		print '<table border=1>';
		print '<TH> GENDER <TH> GRADE <TH> LECT_PREP <TH> STU_PART <TH> OVERALL ';
		while($row = mysqli_fetch_row($result_id))
		{
			print '<TR>';
			foreach ($row as $field)
				print "<TD> $field </TD> ";
			print '</TR>';
		}
		print '</table>';
	}
	else
		print "Fail.<P>";
	mysqli_close($connect);
?>

<HR>
<A HREF=index.html> HOME </A> | <A HREF=evalForm.html> EVALUATION </A>

</CENTER>