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

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

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


<Center>
<H1>
Course Evaluation Table
</H1>
<HR>
<?php
	$ID = $_POST['ID'];
        $gen = $_POST['gen'];
        $sneak = $_POST['sneak'];
        $shoe  = $_POST['shoe'];
        $pr = $_POST['pr'];
	$sz = $_POST['sz'];

if($gen == "Mens")
        $gen = "Mens";
else if($gen == "Womens")
        $gen = "Womens";
else if($gen == "Boys")
        $gen = "Boys";
else
        $gen = "Girls";

if($sneak == "Power")
        $sneak = "Power";
else if($sneak == "Quick")
        $sneak = "Quick";
else 
        $sneak = "Budget";

if($pr == "*")
        $pr = "*";
else if($pr == "**")
        $pr = "**";
else if($pr == "***")       
        $pr = "***";  
else if($pr == "****")       
        $pr = "****";  
else
        $pr = "*****";


        $host = 'localhost';
        $user = 'ranicholson';
        $passwd = 'cs480';
        $database = 'ranicholson';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "insert into FOOT2 values
                        ('$ID', '$sneak', '$gen', '$shoe', '$pr','$sz')";
        mysqli_select_db($connect, $database);              
        if(mysqli_query($connect, $query))
                print "<P>Insert successful.<P>";
        else
                print "<P> Clothing insert failed. Make sure the clothing ID is unique. <p>";
	

	mysqli_close($connect);
        
        (include "footdisplay.php");
	


?>   


<P>

<a href="iybfootacc.php" class="w3-button w3-block w3-black">BACK</a>



</Center>         




<?php
        }
?>