<?php
    require 'connect.forum.signup.php';

    $first_name = '';
    $last_name = '';
    $username = '';
    $date_of_birth = '';
    $email ='';
    $phone_number = '';
    $password = '';

    $first_name = @_POST['first_name'];
    $last_name = @_POST['last_name'];
    $username = @_POST['username'];
    $date_of_birth = @_POST['date_of_birth'];
    $email = @_POST['email'];
    $phone_number = @_POST['phone_number'];
    $password = @_POST['password'];


    if( isset($first_name, $last_name, $username, $email, $password, $phone_number, $date_of_birth)){
        if(!empty($first_name) and !empty($last_name) and !empty($username) and !empty($email) and !empty($phone_number) and !empty($password)){

            $query = "INSERT INTO user(user_id, first_name, last_name, user_name, date_of_birth, email, phone_number, password)
VALUES(NULL, '$first_name', '$last_name', '$username', '$date_of_birth' , '$email', '$phone_number', '$password')" ;

            if($query_run = mysqli_query($con, $query)){
                header('Location: index.php');
            }else{
                echo 'Sorry, something went wrong!';
            }
        }else{
            echo 'not good to go ';
        }
    }else{
        echo 'cannot set1';
    }
    ?>

<form method="post">
<input type="text" placeholder="First Name"  name="first_name"><br>
<input type="text" placeholder="Last Name" name="last_name"><br>
<input type="text" placeholder="Username" name="username"><br>
<input type="date" placeholder="Date Of Birth"  name="date_of_birth"><br>
<input type="email" placeholder="E-mail Id"  name="email"><br>
<input type="number" placeholder="Mobile Number" name="phone_number"><br>
<input type="password" placeholder="Password" class="form-control" name="password"><br>
<input type="password" placeholder="Confirm Password"><br>
<button type="submit" >Make me a member!</button><br>
</form>

$query = "INSERT INTO user(user_id, first_name, last_name, user_name, date_of_birth, email, phone_number, password)
VALUES(NULL, 'fname', 'lname', 'uname', '1998-06-30' , 'a@b.com', '9876543210', 'pass')" ;