<?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 != "Admin")
                print "go away.";
        else
        {


        $remove = $_POST['remove'];
print "$remove";
        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysql_connect($host, $user, $passwd);
        $query = "DELETE FROM EVALUATION WHERE ID='$remove'";
        mysql_select_db($database);

	if(mysql_query($query, $connect))
		print "<P>Removal successful.<P>";
	else
		print "<P>Removal failed.<P>";

	ALTER TABLE EVALUATION DROP ID;
ALTER TABLE EVALUATION AUTO_INCREMENT = 1;
ALTER TABLE EVALUATION ADD ID int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

?>
 <center>
<H2>Display Table</H2>
<HR>
<?php
        $host = 'localhost';
        $user = 'clang';
        $passwd = 'CS389';
        $database = 'clang';
        $connect = mysql_connect($host, $user, $passwd);
        $query = "select * from EVALUATION";
        mysql_select_db($database);
        $result_id = mysql_query($query, $connect);
        if($result_id)
        {
                print '<table border=1>';
                print '<TH> ID <TH> GENDER <TH> STATUS <TH> COURSE <TH> ENJOYMENT <TH> USEFULNESS <TH> WORKLOAD';
                while($row = mysql_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
                print '</table>';
}
}
?>