Html Code .............................................................................

<div id="mainheading" align="center">
            <form action="signuppage.php"  method="post" id="myform"  onsubmit="" >

<div id="registernow">
<h2 align="center"><h1>Sign up Here</h1></div>
 <table>

    <tr>
      <td><strong> Firstname&nbsp </strong></td>
      <td><input type="text" name="firstname" size="20"placeholder="First name" > </td>
    </tr>
    <br>
    <tr>
      <td><br/> <strong>Lastname&nbsp </strong></td>
      <td><br/> <input type="text" name="lastname" size="20" placeholder="Last name"></td>
    </tr>
   
   
    <tr>
      <td><br/><strong>Username&nbsp </strong></td>
      <td> <br/><input type="text" name="username" size="20" placeholder="User name"></td>
    </tr>
           
   
   
    <tr>
    <td> <br/><strong>Password&nbsp </strong></td>
    <td><br/><input type="password" name="password1" size="20" placeholder="Password"></td >
    </tr>

   

    <tr>
    <td><br/> <strong>Gender&nbsp </strong></td>
    <td><br/> <input type="radio" name="group1" value="Male"> Male&nbsp &nbsp &nbsp;
    <input type="radio" name="group1" value="Femal"> Female&nbsp &nbsp &nbsp;
    <input type="radio" name="group1" value="Other" checked="checked"> Other&nbsp &nbsp &nbsp;</td>
    </tr>




     <tr>
       <td><br/><input type="submit"value= "Sign Up" name="submit">  </td>
       <td><br/><input type="reset" value="Reset" name="reseter" > </td>
      
       
      
     </tr>
 </table>
</form>


 php code..............................................................................................................




<?php

   
if(isset($_POST['submit']))
{
       
$fname=$_POST['firstname'];
$lname=$_POST['lastname'];
$uname=$_POST['username'];
$password=$_POST['password1'];

$gender=$_POST['group1'];

       
$link = mysql_connect('localhost', 'root', '');
if (!$link)


{
    die('Not connected : ' . mysql_error());
}





$db_selected = mysql_select_db('signup_db', $link);
if (!$db_selected)


 {
    die ('Can\'t use foo : ' . mysql_error());
 }
 if ((!$fname||!$lname||!$uname||!$password ))

{

 
 


       echo "<script> alert('Kindly Fillout All Fields')</script>";
 
 
   
}
 else
 {
   
    $check = mysql_query("SELECT * FROM signup_tb WHERE username='$uname'");
   
    if (mysql_num_rows($check)>=1)
    {
       echo "<script> alert('Username Already Taken')</script>";

    }
    else
    {
   
          
           $link = mysql_query("INSERT INTO signup_tb(id, firstname, lastname, username,password1,gender) VALUES ('NULL','$fname','$lname','$uname','$password','$gender')")
or die (mysql_error());   

if (!mysql_query($link))
    {
echo "<script> alert('Your Account Has Been Created!! ')</script>";

echo "<script> window.open('loginpage.php','_self')</script>";
   
    }
   
   
    }
   
   
   
   
   
   

   
    }

   


   
}   
   


?>