<!-- Assignment 5, Aleya Roberts, displayEval2.php--!>
<CENTER>
<H2> Display Table </H2>
<HR>


<?php
        $host = 'localhost';
        $user = 'atrobert';
        $passwd = 'cs389';
        $database = 'atrobert';
        $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> Lecture
Preparation <TH> Student Participation <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">Back to Index</A>   
|
<A HREF="evalForm2.html">Form</A>
|
<A HREF="displayEval.php">Display table</A>     
</CENTER>