<!--
	Corey Gray
	CS 480
	DUE: March 31, 2014
	Use mysql to make a table
	then show it on a webpage
-->


<center>
<font size = 5 color = green>
<?php
	print "Database Table.<br>";

	$host = 'localhost';
	$user = 'cngray';
	$passwd = 'vwccscngray';
	$database = 'cngray';

	$connect = mysqli_connect($host, $user, $passwd);
	$query = "select * from EVALUATION";
	print "The query is <i> $query </i> ";

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

	if($result_id)
	{	
		print '<table border=1>';
		print '<TH> GENDER <TH> GRADE <TH> COURSE <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>';
		}
	}
	else
		print "Fail.<p>";
	mysqli_close($connect);
?>
</font>
</center>