Untitled

<<!DOCTYPE html>
<html>
<head>
    <title>Add Member</title>
</head>
<body>
<form method="POST" action="add.php">
<h1 style="font-family: Comic Sans MS; color: blue; text-align: center">Add Member</a></h1>
  <br>
  <br>
    <td><input  type="radio" name="Level" value="Teacher">Teacher</td><tr>
    <td><input  type="radio" name="Level" value="College">College</td><tr>
    <td><input  type="radio" name="Level" value="Senior High">Senior High</td><tr>
 <table border="0">
  <tr>
  </tr>
  <tr>
    <td>ID No:</td>
    <td><input type="text" name="ID"></td>
  </tr>
  <tr>
    <td>Last Name:</td>
    <td><input type="text" name="Lname"></td>
  </tr>
  <tr>
    <td>First Name:</td>
    <td><input type="text" name="Fname"></td>
  </tr>
  <tr>
    <td>Middle Name:</td>
    <td><input type="text" name="Mname"></td>
  </tr>
  <tr>
    <td>Birthdate:</td>
    <td><input type="number" name="Bdate"></td>
  </tr>
  <tr>
    <td>Address:</td>
    <td><input type="text" name="Address"></td>
  </tr>
  <tr>
    <td>Contact No:</td>
    <td><input type="number" placeholder="09xxxxxxxxx" name="Contact"></td>
  </tr>
  <tr>
    <td>Department:</td><tr>
    <td><input type="radio" name="Dept" value="CAS">CAS</td>
    <td><input type="radio" name="Dept" value="BSBA">BSBA</td>
    <td><input type="radio" name="Dept" value="BSED">BSED</td>
  </tr>
  <TR>
    <TD class = "select">Course</TD>
    <TD>
       <select>
            <option name="Course" value="I.T">I.T</option>
            <option name="Course" value="HRM">HRM</option>
            <option name="Course" value="Psychology">Psychology</option>
            <option name="Course" value="Criminology">Criminology</option>
       </select>
    </TD>
</TR>
  <br><br>
  </tr>
  <TR>
    <TD class = "select">Year</TD>
    <TD>
       <select>
            <option name="Year" value="1st">1st</option>
            <option name="Year" value="2nd">2nd</option>
            <option name="Year" value="3rd">3rd</option>
            <option name="Year" value="4th">4th</option>
       </select>
    </TD>
</TR>
  <tr>
    <td>Gender:</td>
    <td><input type="radio" name="Gender" value="Male">Male</td>
    <td><input type="radio" name="Gender" value="Female">Female</td>
  </tr>
</table>
 <br>
 <br>
  <button class="button" type="submit">Submit</button>
  <input type="reset" value="Reset">
  </form>
</body>
</html>

<?php


$host = "localhost";
$username = "root";
$password = "";
$dbname = "library_system";

$conn = new mysqli ($host, $username, $password, $dbname);


if ($conn->connect_error) {


    die("Connection failed: " . $conn->connect_error);
}

     $ID = $_POST['ID'];
     $Course = $_POST['Course'];
     $Lname = $_POST["Lname"];
     $Fname = $_POST['Fname'];
     $Mname = $_POST['Mname'];
     $Bdate = $_POST['Bdate'];
     $Dept = $_POST['Dept'];
     $Address = $_POST['Address'];
     $Contact = $_POST['Contact'];
     $Year = $_POST['Year'];
     $Gender = $_POST['Gender'];
     $Level = $_POST['Level'];

     if($ID  =='' OR $Course  =='' OR $Lname == '' OR $Fname == '' OR  $Mname =='' OR  $Bdate == '' OR $Address =='' OR $Contact =='' OR $Gender  =='' OR $Year  =='' OR $Level  =='' OR $Dept =='')
    {
        $form = "Fill in all the forms";
                echo "<script type='text/javascript'>alert('$form');</script>";
    }
    else {


    $sql = "INSERT INTO members (ID, Course, Lname, Fname, Mname, Bdate, Dept, Address, Contact, Gender, Year, Level)

    VALUES ('$ID', '$Course', '$Lname', '$Fname', '$Mname', '$Bdate', '$Dept', '$Address', '$Contact', '$Gender', '$Year', '$Level')";
    if ($conn->query($sql) === TRUE)
        {
                $message = "Member has been added successfully";
                echo "<script type='text/javascript'>alert('$message');</script>";

        }
    else
    {
  $message = "Student Registration Failed";
  echo "<script type='text/javascript'>alert('$message');</script>";
    }

        }

$conn->close();
?>