<?php
// If the name field is filled in
    if (isset($_GET['name']))
    {
        $name = $_GET['name'];
        $password = $_GET['password'];
        $department = $_GET['group'];

        $con = mysql_connect("localhost","root","");
        if (!$con){
            die('Could not connect: ' . mysql_error());
          }
         
        // Select database
        mysql_select_db("Library", $con);       
       
        // Insert users to the Users table   
        $sql = "INSERT INTO Users(Name, Password, UserType) VALUES ('".$name."','".$password."','".$department."')";   
        $result = mysql_query ($sql);
       
        // if successfully insert data into database, displays message "Successful".
        if($result){
            echo "Insert Command: $sql is successfully executed";
        }
        else {
            echo "ERROR While Inserting Data!! " .mysql_error();
        }

        /* read data from the database*/
        $query="SELECT * FROM Users";
        $result=mysql_query($query);
        $num=mysql_numrows($result);

        mysql_close();

        echo "<b><center>Database Output</center></b><br><br>";
        echo "Name     UserType     UserId <br />";
        while($row = mysql_fetch_array($result)){
            echo $row['Name'] . "     " . $row['UserType']. "     " . $row['UserId'];
            echo "<br />";
        }

    }
?>
    <form action="addnewuser.php" method="get">
    <p>
    Name:<br />
    <input type="text" id="name" name="name" size="20" maxlength="40" />
    </p>
    <p>
    Password Field:<br />
    <input type="password" id="password" name="password" size="20" maxlength="40" />
    </p>

    <p>
    User Group:<br />
        <select name="group">
            <option value="Student">Student</option>
            <option    value="Admin">Admin</option>
            <option    value="Faculty">Faculty</option>
        </select>

    <p>


    <input type="submit" id="submit" name = "submit" value="Go!" />

    </form>