<!--

        EVALUATE_display.php
        Author: Jack Taylor
        Instructor: Dr. Wang
        Due: Sunday Apr. 21, 2024
-->
<center>
<FONT color=blue size=3>
<H2>
Course Evaluation Results
</H2>
<HR>


<?php
        $host = 'localhost';
        $user = 'jhtaylor';
        $passwd = 'cs389';
	$database = 'jhtaylor';
        $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);

?>
<P>

<A HREF= Assignment5.html> Home </A> | <A HREF= index.html> Main Page </A>
        | <A HREF=EVALUATE_insertForm.html> Evaluation Form </A> |
<A HREF=EVALUATE_search.html> Filter for different results </A>
<HR>
<P>
</center>