<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
if(chk4() && chk5() && chk6())
{
if(chk7())
{
if(chk8())
{
return true;
}
}
}
}
}
return false;
}
function chk1()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("a").innerHTML="please enter name!";
return false;
}
else
{
document.getElementById("a").innerHTML="";
return true;
}
}
function chk2()
{
var elem=document.getElementById("txt1");
var alphaExp=/^[a-zA-Z]+$/;
if(elem.value.match(alphaExp))
{
document.getElementById("a").innerHTML="";
return true;
}
else
{
document.getElementById("a").innerHTML="please enter only alphabets!";
elem.focus();
return false;
}
}
function chk3()
{
var elem=document.getElementById("txt2");
var alphaExp = /^([A-Za-z0-9\-\.\_])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/;
if(elem.value.match(alphaExp))
{
document.getElementById("b").innerHTML="";
return true;
}
else
{
document.getElementById("b").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk4()
{
var elem=document.getElementById("txt3");
if(elem.value=="")
{
document.getElementById("c").innerHTML="please enter password!";
return false;
}
else
{
document.getElementById("c").innerHTML="";
return true;
}
}
function chk5()
{
var elem=document.getElementById("txt4");
if(elem.value=="")
{
document.getElementById("d").innerHTML="please confirm your password!";
return false;
}
else
{
document.getElementById("d").innerHTML="";
return true;
}
}
function chk6()
{
var elem=document.getElementById("txt3");
var elem2=document.getElementById("txt4");
if(elem.value==elem2.value)
{
document.getElementById("d").innerHTML="";
return true;
}
else
{
document.getElementById("d").innerHTML="password you entered not match !";
elem.focus();
return false;
}
}
function chk7()
{
var elem=document.getElementById("txt5");
var alphaExp=/^\d{10}$/;
if(elem.value.match(alphaExp))
{
document.getElementById("e").innerHTML="";
return true;
}
else
{
document.getElementById("e").innerHTML="enter mobile no of 10 digits !";
elem.focus();
return false;
}
}
function chk8()
{
var elem=document.getElementById("sec");
if(elem.value=="please choose")
{
document.getElementById("f").innerHTML="please select a question!";
elem.focus();
return false;
}
else
{
document.getElementById("f").innerHTML="";
return true;
}
}
</script>
</head>
</head>
<body>
<div style="background-color:white;
background-image:url('property.jpg');width:1000px;height:450px;
color:red"/>
<form method="post" onsubmit="return chk();">
<h1 style="font-weight:1500"><i>SEEKER-REGISTRATION</i></hi>
<table border="0" style="font-size:20px;font-family:Segoe Print;font-style:italic;font-weight:bold">
<tbody>
<tr>
<td>NAME</td>
<td><input type="text" name="name" value="" id="txt1" /><span id="a"></span></td>
</tr>
<tr>
<td>E-MAIL</td>
<td><input type="text" name="email" value="" id="txt2"/><span id="b"></span></td>
</tr>
<tr>
<td>PASSWORD</td>
<td><input type="password" name="password" value="" id="txt3" /><span id="c"></span></td>
</tr>
<tr>
<td>CONFIRM-PASSWORD</td>
<td><input type="password" name="conpassword" value="" id="txt4" /><span id="d"></span></td>
</tr>
<tr>
<td>ADDRESS</td>
<td><input type="text" name="address" value="" /></td>
</tr>
<tr>
<td>CONTACT NO</td>
<td><input type="text" name="contactno" value="" id="txt5"/><span id="e"></span></td>
</tr>
<tr>
<td>SECURITY QUESTION</td>
<td><select name="securityquestion" id="sec">
<option>--SELECT--</option>
<?php
$query="select * from security_question";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row ['security_id'].">".$row ['question']."</option>";
}
?>
</select><span id="f"></span></td>
</tr>
<tr>
<td>SECURITY ANSWER</td>
<td><input type="text" name="answer" value="" /></td>
</tr>
</tbody>
</table>
<br/>
<input type="submit" value="ADD" name="btn"/> <input type="reset" value="CANCEL" name="btn1"/>
<form/>
</div>
<?php
if (isset($_POST['btn'])){
$query1="insert into propertyseeker (Name,Emailid,Address,Password,Sec_ques,Answer,Contact) values ('".$_POST['name']."','".$_POST['email']."','".$_POST['address']."','".$_POST['password']."','".$_POST['securityquestion']."','".$_POST['answer']."','".$_POST['contactno']."')";
$data=mysql_query($query1);
if ($data)
{
echo"Data inserted";
}
else
{
echo mysql_error();
}}
?>
</body>
</html>
