<!-- assig5FormAct.php - Assignment 5 evaluation confirmation page - Kristin Tillotson -->

<CENTER><H2><Font color=green>
Course Evaluation Form Confirmation Page
</H2></font><HR>

<?php
	$gender = $_POST['gender'];
        $grade = $_POST['grade'];
        $course = $_POST['course'];
        $lp = $_POST['lp'];
	$sp = $_POST['sp'];
	$os = $_POST['os'];

        $host = 'localhost';
        $user = 'kvtillotson';
        $passwd = 'cs389';
        $database = 'kvtillotson';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "insert into EVALUATION values ('$gender', '$grade', '$course', '$lp', '$sp', '$os')";
//      print "The query is <i> $query </i> ";          //debug
        mysqli_select_db($connect, $database);

        if(mysqli_query($connect, $query))
        {
                print "<P>Insert successful.<P>";
                // use include for showing the table content
                print "</center><HR>";
                include ("assig5Table.php");
        }
        else
                print "<P>Insert fail.</center> <A HREF=index.html> Course Home </A>";
        mysqli_close($connect);
?>

</center>
 | <A HREF=assig5Form.html> Course Evaluation Form