<!--
        File: passonlinecourseevaluation4.php
        Assignment: 6 Part: 2
        Due: Apr. 16, 2019
        Author: Ikechukwu Etonyeaku
        Goal: Based on Part I, finalize the database system. The Online Course Evaluation DBMS should include the
following pages.

-->
<?php   session_start();


        $pass = $_SESSION['psw'];
        if($pass != "project")
                print "Sorry wrong password buddy.";
        else
        {
?>

<style>
body {
        border: 2px solid black;

        padding: 25px;
        background:url(https://media.npr.org/assets/img/2018/11/28/gettyimages-1054880284_wide-601448badafc510900f36311c540116cc54d42ec.jpg?s=1400);
        background-repeat:repeat;
        background-size: auto;
     }
.black_bg
{
    background-color: black;
    padding: 3px;
}
</style>

<h2>
Content Evaluation Form Page
</h2>
<hr>

<?php
	$Gender = $_POST['Gender'];
        $Status = $_POST['Status'];
        $Course = $_POST['Course'];
        $Attendance = $_POST['Attendance'];
	$Participation = $_POST['Participation'];
	$ExtraCredit = $_POST['ExtraCredit'];	

        $host = 'localhost';
        $user = 'idetonyeaku';
        $passwd = 'cs480';
        $database = 'idetonyeaku';
        $connect = mysql_connect($host, $user, $passwd);
        $query = "insert into EVALUATION values
                        ('$Gender', '$Status', '$Course', '$Attendance', '$Participation', '$ExtraCredit')";

        mysql_select_db($database);
        if(mysql_query($query, $connect))
        print "";
        else
        print "<P>Insert fail.<p>";
        mysql_close($connect);
        // use include for showing the table content
        include ("displayevaluationtable.php");
?>

<P>
<A HREF=passonlinecourseevaluation.php><span class = "black_bg"> Go Back</span></A>
<P>
<A HREF=index.html><span class = "black_bg">Go Home</span></A>

<?php
	}
?>