<?php   session_start(); ?>
<!-- File name: a12pg4.php -->

<?php
       $pass =  $_SESSION['psw'];
       $_SESSION['psw'] = $pass;	

        if($pass != "project")  print "Go away.";
        else
        {
?>


<Center>
<H1>
Course Evaluation Table
</H1>
<HR>
<?php
	$gen = $_POST['gen'];
        $status = $_POST['status'];
        $course  = $_POST['course'];
        $lect = $_POST['lect'];
	$sp = $_POST['sp'];
        $ov = $_POST['ov'];

if($gen == "Male")
	$gen = "Male";
else 
	$gen = "Female"; 

if($status == "Freshman")
	$status = "Freshman";
else if($status == "Sophmore")
	$status = "Sophmore";
else if($status == "Junior")
	$status = "Junior";
else 
	$status = "Senior";

        $host = 'localhost';
        $user = 'ranicholson';
        $passwd = 'cs480';
        $database = 'ranicholson';
        $connect = mysql_connect($host, $user, $passwd);
        $query = "insert into EVALUATION values
                        ('$gen', '$status', '$course', $lect, $sp, $ov)";
        mysql_select_db($database);
        if(mysql_query($query, $connect))
                print "<P>Insert successful.<P>";
        else
                print "<P>Insert fail.<p>";
        mysql_close($connect);
        include ("a12display.php");


?>


<P>
<Font color=red  size=4.5> Click the link below to fill out and insert a Course Evaluation Form to the Course Evaluation Table.
</font>
<P>
<A HREF=a12pg3.php><Font size=4> Fill out Course Evaluation Form </A>


</Center>




<?php
        }
?>