<?php   session_start();

/*      evalForm2.php

        Author: Casey Lang
        Instructor: Dr. Wang
        Due: April 3, 2022
        Goal: Create a form that shows the content of the evaluation table. 
*/


       
        $pass = $_SESSION['psw'];
        if($pass != "hw4")
                print "go away.";
        else
        {



        
        $score = $_POST['score'];
        $status = $_POST['status'];
        $course = $_POST['course'];

        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "insert into EVAL values 
                        ('$status', '$course', '$score')";
        mysqli_select_db($connect, $database);

        
if(mysqli_query($connect, $query))
	{
		?>
        	<center>
<H2>Display Table</H2>
<HR>
<?php
        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from EVAL";
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> STATUS <TH> COURSE <TH> SCORE';
                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);
?>
</center>
<?PHP
	}
	else
	{
		 ?>
                <center>
<H2>Display Table</H2>
<HR>
<?php
        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "select * from EVAL";
        mysqli_select_db($connect, $database);
        $result_id = mysqli_query($connect, $query);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> STATUS <TH> COURSE <TH> SCORE';
                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);
?>
</center>
<?PHP

	}
	mysqli_close($connect);
?>
<HR>
<P>
<?php
}
?>