<!-- File Professor Display.php -->

<CENTER>

<style>
body {
       background-color: LawnGreen;
     }
</style>

<H2> Display Of Table </H2>
<HR>

<?php
       session_start();
       $userName = $_SESSION['un'];
       $password = $_SESSION['p'];

       if($userName != "professor" && $password != "6/29/2018")
             print "Go Away!!";
       else
       {
          $useName = $_POST['Sname'];
          $spass = $_POST['Spass'];
          $name = $_POST['name'];
          $course = $_POST['course'];
          $grade = $_POST['grade'];
          
          if(strlen($useName) == 0 || strlen($spass) == 0 || strlen($name) == 0 || strlen($course) == 0 || strlen($grade) == 0)
              print "one textbox is empty!";
          else
          {
             $host = 'localhost';
	     $user = 'kfmurray';
	     $passwd = 'cs480';
	     $database = 'kfmurray';
	     $connect = mysqli_connect($host, $user, $passwd);
	     $query = "insert into PROFESSOR values 
			('$useName', '$spass', '$name', '$course', '$grade')";
	     mysqli_select_db($connect, $database);
	     if(mysqli_query($connect, $query))
            mysqli_close($connect);
            include("PROFESSOR.php");
            }
          }
?>