<?php
session_start();
include('db.php');
$username=$_POST['username'];

$result  =  mysqli_query($db,"SELECT  *  FROM  member  WHERE
username='$username'");
$num_rows  =  mysqli_num_rows($result);

if  ($num_rows)  {
header("location:  register.php?remarks=failed");
}
else
{


$date = date("Y-m-d");
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$address=$_POST['address'];
$username=$_POST['username'];
$password=$_POST['password'];
$secretpin = $_POST['secretpin'];
mysqli_query($db,"INSERT  INTO  member(date, fname, lname, address,
username, password, secretpin)VALUES('$date', '$fname', '$lname','$address',
'$username',  '$password', '$secretpin')");
header("location:  register.php?remarks=success");
}
?>

<fieldset>

<input autocomplete="off" maxlength="8" pattern=".{8,}" type="text" id="tb-
box" name="secretpin" placeholder="Secret PIN">

</fieldset>
<button name="forgotpass" value="st-btn" type="submit" class="submit">
<span>Find Password</span></button>