$host="localhost";
$username="root";
$password="";
$link=mysqli_connect($host,$username,$password,"a8172058_portal");
if(isset($_POST["submit"]))
 {
    $name=$_POST["name"];
    $email=$_POST["email"];
    $username=$_POST["username"];
    $pass=$_POST["password"];
    $contactno=$_POST["contact1"];
    $cont2=$_POST["contact2"];
    $dob=$_POST["date"];
    $role=$_POST["rle"];
    $gender=$_POST["s"];
    $qry="insert users          values('$name','$email','$username','$pass','$contactno','$cont2','$dob','$role','$gender')";
    $res=mysqli_query($link,$qry);
    if(mysqli_query_rows($link)=false)
    {
        echo 'you have registered successfully';
    }
    else
    {
        echo 'registration failed';
    }


?>`