<!--
File: Comptable2.php
-->

<?php session_start(); ?>

<?php
  session_start();

  if (!isset($_SESSION['username'])) {
        $_SESSION['msg'] = "You must log in first";
        header('location: https://zeus.vwu.edu/~ajwilcox/ResearchLogin.php');
  }
  if (isset($_GET['logout'])) {
        session_destroy();
        unset($_SESSION['username']);
        header("location: https://zeus.vwu.edu/~ajwilcox/ResearchLogin.php");
  }
else{
?>
<?php
        $name = $_POST['compname'];
        $email = $_POST['compemail'];
        $class = $_POST['compclass'];
        $year = $_POST['compyear'];

        $host = 'localhost';
        $user = 'ajwilcox';
        $passwd = 'CS389';
        $database = 'ajwilcox';
        $connect = mysqli_connect($host, $user, $passwd);
        $query = "insert into compsci values
                        ('$name', '$email', '$class', '$year')";

        mysqli_select_db($connect, $database);
         if(mysqli_query($connect, $query))
        {
        //      print "<P>Insert successful.<P>";
                // use include for showing the table content
                include ("CompDisplay1.php");
        }
        else
                print "<P>Insert fail.<p>";
        mysqli_close($connect);
?>
<?php
        }
?>