[removed]

 $(document).ready(function(){

 var loading = $("#loading");

 var response = $("#response");

 var button = $("#button");

 loading.hide();

 response.hide();

 $("#button").click(function(){

 var username = $("#username").val();

 var password1 = $("#password1").val();

 var password2 = $("#password2").val();

 var email = $("#email").val();

 var secnum = $("#secnum").val();

 var day = $("#day").val();

 var month = $("#month").val();

 var year = $("#year").val();

 var gender = $("#gender").val();

 button.hide();

 loading.fadeIn();

 response.hide();

 $.ajax({

 type: "POST",

 url:"inc/do_register.php",

 data:"username=" + username + 

 "&password1=" + password1 + 

 "&password2=" + password2 + 

 "&email=" + email + 

 "&secnum=" + secnum + 

 "&day=" + day + 

 "&month=" + month + 

 "&year=" + year + 

 "&gender=" + gender,

 success: function(data){

 loading.hide();

 response.fadeIn();

 button.fadeIn();

 $("#response").html(data);

 }

 });

 });

 });

 [removed]



 <div class="well"><button type="button" class="close" data-dismiss="alert">×</button>

 <legend>Register</legend>

 <form id="form1" class="form-horizontal">

 <div><center><span id="response"></span></center></div>

 <div class="control-group">

 <label class="control-label" for="username">Username</label>

 <div class="controls">

 <input name="username" type="text" id="username"/>

 <div class="help-inline">alphanumeric, min 6 max 8</div>

 </div>

 </div>

 <div class="control-group">

 <label class="control-label" for="password1">Password</label>

 <div class="controls">

 <input name="password1" type="password" id="password1"/>

 <div class="help-inline">alphanumeric, min 6 max 8</div>

 </div>

 </div>

 <div class="control-group">

 <label class="control-label" for="password2">Retype Password</label>

 <div class="controls">

 <input name="password2" type="password" id="password2"/>

 <div class="help-inline">alphanumeric, min 6 max 8</div>

 </div>

 </div>

 <div class="control-group">

 <label class="control-label" for="email">Email</label>

 <div class="controls">

 <input class="" type="email" id="email" required>

 </div>

 </div>

 <div class="control-group">

 <label class="control-label" for="secnum">Security Number</label>

 <div class="controls">

 <input name="secnum" type="text" id="secnum"/>

 <div class="help-inline">8 digit number</div>

 </div>

 </div>

 <div class="control-group">

 <label class="control-label" for="birth">Birthday</label>

 <div class="controls">

 <select class="span2" name="day" id="day">

 <option> </option>

 <option value="01"> 1 </option>

 <option value="02"> 2 </option>

 <option value="03"> 3 </option>

 <option value="04"> 4 </option>

 <option value="05"> 5 </option>

 <option value="06"> 6 </option>

 <option value="07"> 7 </option>

 <option value="08"> 8 </option>

 <option value="09"> 9 </option>

 <option value="10"> 10 </option>

 <option value="11"> 11 </option>

 <option value="12"> 12 </option>

 <option value="13"> 13 </option>

 <option value="14"> 14 </option>

 <option value="15"> 15 </option>

 <option value="16"> 16 </option>

 <option value="17"> 17 </option>

 <option value="18"> 18 </option>

 <option value="19"> 19 </option>

 <option value="20"> 20 </option>

 <option value="21"> 21 </option>

 <option value="22"> 22 </option>

 <option value="23"> 23 </option>

 <option value="24"> 24 </option>

 <option value="25"> 25 </option>

 <option value="26"> 26 </option>

 <option value="27"> 27 </option>

 <option value="28"> 28 </option>

 <option value="29"> 29 </option>

 <option value="30"> 30 </option>

 <option value="31"> 31 </option>

 </select>

 <select class="span3" name="month" id="month">

 <option> </option>

 <option value="01"> January </option>

 <option value="02"> February </option>

 <option value="03"> March </option>

 <option value="04"> April </option>

 <option value="05"> May </option>

 <option value="06"> June </option>

 <option value="07"> July </option>

 <option value="08"> August </option>

 <option value="09"> September </option>

 <option value="10"> October </option>

 <option value="11"> November </option>

 <option value="12"> December </option>

 </select>

 <select class="span2" name="year" id="year">

 <option> </option>

 <option value="2012"> 2012 </option>

 <option value="2011"> 2011 </option>

 <option value="2010"> 2010 </option>

 <option value="2009"> 2009 </option>

 <option value="2008"> 2008 </option>

 <option value="2007"> 2007 </option>

 <option value="2006"> 2006 </option>

 <option value="2005"> 2005 </option> 

 </select>

 </div>

 </div>

 <div class="control-group">

 <label class="control-label" for="gender">Gender</label>

 <div class="controls">

 <label class="radio inline">

 <input type="radio" name="gender" value="1" id="gender" checked/>Male

 </label>

 <label class="radio inline">

 <input type="radio" name="gender" value="2" id="gender"/>Female

 </label>

 </div>

 </div>

 <div class="form-actions">

 <span id="button">

 <button type="button" class="btn btn-info btn-small" data-loading-text="Loading...">Register</button>

 <input class="btn btn-small" type="reset" value="Reset" id="reset">

 </span>

 <span id="loading"><button type="button" class="btn btn-info btn-small disabled" disabled="disabled">Loading...</button></span>

 </div>

 </form>

 </div>

<?php include ('config.php');

 #error_reporting(0);

 $username = $_POST['username'];

 $username = stripslashes($username);

 $username = mysql_real_escape_string($username);

 $username = strtolower($username);



 $password1 = $_POST['password1'];

 $password1 = stripslashes($password1);

 $password1 = mysql_real_escape_string($password1);



 $password2 = $_POST['password2'];



 $email = $_POST['email'];

 $email = stripslashes($email);

 $email = mysql_real_escape_string($email);



 $secnum = $_POST['secnum'];

 $secnum = stripslashes($secnum);

 $secnum = mysql_real_escape_string($secnum);



 $day = $_POST['day'];

 $month = $_POST['month'];

 $year = $_POST['year'];

 $gender = $_POST['gender'];

 $bday = "$year-$month-$day";



 $ip = $_SERVER['REMOTE_ADDR'];

 

 function CalculateAge($BirthDate)

 {

 // Put the year, month and day in separate variables

 list($Year, $Month, $Day) = explode("-", $BirthDate);



 $YearDiff = date("Y") - $Year;



 // If the birthday hasn't arrived yet this year, the person is one year younger

 if(date("m") < $Month || (date("m") == $Month && date("d") < $DayDiff))

 {

 $YearDiff--;

 }

 return $YearDiff;

 }

 $age = CalculateAge($bday);



 if($username != "" && $email != ""){

 include 'find_tbl.php';

 $sql="SELECT * FROM seal_member.$tbl_name WHERE id='$username'";

 $result=mysql_query($sql);

 $count_id=mysql_num_rows($result);



 $sql="SELECT * FROM seal_member.$tbl_name WHERE email='$email'";

 $result=mysql_query($sql);

 $count_email=mysql_num_rows($result);

 }



 if($username == "" || $password1 == "" || $password2 == "" || $email == "" || $secnum == "" || $day == "" || $month == "" || $year == ""){

 $response = "<div class='alert alert-error'>Fill all the field!</div>";

 }else if($password1 != $password2){

 $response = "<div class='alert alert-error'>Password do not match!</div>";

 }else if(!preg_match("/^[a-z0-9]{6,8}$/", $username)){

 $response = "<div class='alert alert-error'>Fill username correctly, min 6 max 8!</div>";

 }else if(!preg_match("/^[a-z0-9]{6,8}$/", $password1)){

 $response = "<div class='alert alert-error'>Fill password correctly, min 6 max 8!</div>";

 }else if(!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/", $email)){

 $response = "<div class='alert alert-error'>Fill email correctly!</div>";

 }else if(!preg_match("/^[0-9]{8}$/", $secnum)){

 $response = "<div class='alert alert-error'>Fill security number correctly, 8 digit number!</div>";

 }else if($count_id > 0){

 $response = "<div class='alert alert-error'>Sorry username already used!</div>";

 }else if($count_email > 0){

 $response = "<div class='alert alert-error'>Sorry email already used!</div>";

 }else{



 $query = "INSERT INTO seal_member.$tbl_name (id, passwd, birthday, email, trueId, sex, age, web_ip, pass) 

 VALUES ('$username', PASSWORD('$password1'), '$bday', '$email', '$secnum', '$gender', '$age', '$ip', '$password1')";

 mysql_query($query) or die ("<div class='alert alert-error'>Something happen when registering your data, please contact Administrator.</div>");

 session_start();

 session_destroy();

 session_register("username");

 $_SESSION['username'] = $username;

 $response = "[removed][removed].href = 'index'[removed]<div class='alert alert-success'>Registration success!!</div>";



 }

 echo $response;

?>