<div class="form-group label-floating is-select">
                                        <label class="control-label">Your Gender</label>
                                        <select class="selectpicker name="gender" form-control" size="auto">
                                            <option value="MA">Male</option>
                                            <option value="FE">Female</option>
                                        </select>
                                    </div>

if (isset($_POST['regButton'])) {

        $i = 0;

        $username = strtolower($_POST['fname'] . $_POST['lname'] . $i++ );
        $password = $_POST['password'];
        $FirstName = $_POST['fname'];
        $LastName = $_POST['lname'];
        $usermail = $_POST['email'];
        $dob = $_POST['datetimepicker'];
        $gender = $_POST['gender'];

        $query = "INSERT INTO users(username, password, FirstName, LastName, Email, dob, gender) ";
        $query .= "VALUES ('$username', '$password', '$FirstName', '$LastName', '$usermail', '$dob', '$gender')";

        $result = mysqli_query($con, $query);

        if(!$result){

            echo "<div class='alert alert-danger'>Query Failed.</div>";
        }else {

            echo "<div class='alert alert-danger'>Registraation Successful.</div>";
        }

    }