<form method="post" action="registerMember.php">
<div class="row">
    <div class="col-md-6">
        <div class="form-group">
            <label id="lblName" for="inputName" class="control-label">
                Name with Initials *</label>
            <input id="inputName"   name="name" type="text"
                   placeholder="" class="form-control" required/>


        </div>
    </div>
</div>

<div class="form-actions text-center ">
    <button style="width: 150px" type="submit" class="btn btn-success">
        Register
    </button>
</div>

<?php
if ($_POST) {


if (strlen($_POST['name']) < 3) {
    echo "<div class='alert alert-warning'>Name should be at least 3 characters</div>";

}
else if (strlen($_POST['name']) > 2) {

    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "library";

    $name = $admissionNumber = $telephone = $email = $class = $year = $address = "";
    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $dbname);

    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }


    $name = $_POST["name"];
    $admissionNumber = $_POST["admissionNumber"];
    $telephone = $_POST["telephone"];
    $email = $_POST["email"];
    $class = $_POST["class"];
    $year = $_POST["year"];
    $address = $_POST["address"];
    $fines = 0;
    $borrowedBooks = 0;

    $sql = "INSERT INTO member ( name, admissionNumber, telephone, email, class, year, address, noOfLoans, fines)
                            VALUES('$name','$admissionNumber','$telephone','$email','$class','$year','$address','$borrowedBooks','$fines')";

    if (mysqli_query($conn, $sql)) {
        echo "<div class='alert alert-success'>New record created successfully</div>";
    } else {
        echo "<div class='alert alert-danger'>Error: " . $sql . "<br>" . mysqli_error($conn) . "</div>";
    }

    mysqli_close($conn);
}