Sunday, 15 March 2015

ownerform.php

<?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>
<body>
<div align="center" style="background-color:#BC8F8F">
<form method="post" onsubmit="return chk();">
<h1 style="font-weight:1500"><i>OWNER-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"/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input type="reset" value="CANCEL" name="btn1"/>
 <form/>
</div>
 
<?php
if (isset($_POST['btn'])){
$query1="insert into property_owner (name,password,address,contact,email,security_id,security_answer) values ('".$_POST['name']."','".$_POST['password']."','".$_POST['address']."','".$_POST['contactno']."','".$_POST['email']."','".$_POST['securityquestion']."','".$_POST['answer']."')";
$data=mysql_query($query1);
if ($data)
{
echo"Data inserted";
}
else
{
echo"Data not inserted";
}}
?>
</body>
</html>

0 comments:

Post a Comment