<!--
File name: displayEVAL5.php
Author: Abigail Shoop
Purpose: CS389-Assignment #5
	--!>

<center>
<h2>Display Evaluation Table</h2>
<HR>

<?php
	$host = 'localhost';
        $user = 'akshoop';
        $passwd = 'cs389';
        $database = 'akshoop';

        $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> Student Status <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>';
                }
                print '</table>';
        }
        else
                print "Fail.<p>";

        mysqli_close($connect);
?>
<BR>
<HR>
        <a href="evalForm5.php">Evaluation Form</a><BR>
        <a href="displayEVAL5.php">Display Table</a><BR>
        <a href="searchEval5.html">Search the Table</a><BR>

        <a href="assignment5.html">Assignment 5</a> |
        <a href="index.html">Home</a>
</center>