After Entering email id and password.
After Entering email id and password.
Thursday, 30 April 2015
Monday, 27 April 2015
Start Wamp Server.
Activate all services.
Open Browser
Enter address:http://localhost/ibuyhome/admin/ibuyhome/
login page
Start Wamp Server.
Activate all services.
Open Browser
Enter address:http://localhost/ibuyhome/admin/ibuyhome/
Thursday, 23 April 2015
<?php
session_start();
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select name,address,email,contact from property_owner where owner_id=".$_SESSION['id'];
$row=mysql_query($query);
$result=mysql_fetch_array($row);
if(isset($_POST['click']))
{
$query="update property_owner set name='".$_POST['name']."',address='".$_POST['address']."',email='".$_POST['emailid']."',contact='".$_POST['contact']."' where owner_id=".$_SESSION['id'];
$k=mysql_query($query);
if($k)
{
echo("information updated");
header('location:dashowner1.php');
}
else
{
mysql_error();
}
}
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
if(chk4())
{
if(chk5())
{
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");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter name!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
function chk4()
{
var elem=document.getElementById("txt3");
var alphaExp = /^([A-Za-z0-9\-\.\_])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/;
if(elem.value.match(alphaExp))
{
document.getElementById("c").innerHTML="";
return true;
}
else
{
document.getElementById("c").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk5()
{
var elem=document.getElementById("txt4");
var alphaExp=/^\d{10}$/;
if(elem.value.match(alphaExp))
{
document.getElementById("d").innerHTML="";
return true;
}
else
{
document.getElementById("d").innerHTML="enter mobile no of 10 digits !";
elem.focus();
return false;
}
}
</script>
</head>
<body><div>
<form method="post" onsubmit="return chk();"/>
<table border="0">
<tbody>
<tr>
<td>NAME:</td>
<?php "<td><input type='text' name='name' id='txt1' value=".$result['name']." /><span id='a'></span></td>";?>
</tr>
<tr>
<td>ADDRESS:</td>
<?php "<td><input type='text' name='address' id='txt2' value=".$result['address']." /><span id='b'></span></td>";?>
</tr>
<tr>
<td>EMAIL-ID:</td>
<?php "<td><input type='text' name='emailid' id='txt3' value=".$result['email']." /><span id='c'></span></td>";?>
</tr>
<tr>
<td>CONTACT:</td>
<?php "<td><input type='text' name='contact' id='txt4' value=".$result['contact']." /><span id='d'></span></td>";?>
</tr>
<tr>
<td><input type="submit" value="UPDATE" name="click" /></td>
<td><input type="reset" value="CANCEL" /></td>
</tr>
</tbody>
</table>
</form>
</div>
</body>
</html>
session_start();
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select name,address,email,contact from property_owner where owner_id=".$_SESSION['id'];
$row=mysql_query($query);
$result=mysql_fetch_array($row);
if(isset($_POST['click']))
{
$query="update property_owner set name='".$_POST['name']."',address='".$_POST['address']."',email='".$_POST['emailid']."',contact='".$_POST['contact']."' where owner_id=".$_SESSION['id'];
$k=mysql_query($query);
if($k)
{
echo("information updated");
header('location:dashowner1.php');
}
else
{
mysql_error();
}
}
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
if(chk4())
{
if(chk5())
{
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");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter name!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
function chk4()
{
var elem=document.getElementById("txt3");
var alphaExp = /^([A-Za-z0-9\-\.\_])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/;
if(elem.value.match(alphaExp))
{
document.getElementById("c").innerHTML="";
return true;
}
else
{
document.getElementById("c").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk5()
{
var elem=document.getElementById("txt4");
var alphaExp=/^\d{10}$/;
if(elem.value.match(alphaExp))
{
document.getElementById("d").innerHTML="";
return true;
}
else
{
document.getElementById("d").innerHTML="enter mobile no of 10 digits !";
elem.focus();
return false;
}
}
</script>
</head>
<body><div>
<form method="post" onsubmit="return chk();"/>
<table border="0">
<tbody>
<tr>
<td>NAME:</td>
<?php "<td><input type='text' name='name' id='txt1' value=".$result['name']." /><span id='a'></span></td>";?>
</tr>
<tr>
<td>ADDRESS:</td>
<?php "<td><input type='text' name='address' id='txt2' value=".$result['address']." /><span id='b'></span></td>";?>
</tr>
<tr>
<td>EMAIL-ID:</td>
<?php "<td><input type='text' name='emailid' id='txt3' value=".$result['email']." /><span id='c'></span></td>";?>
</tr>
<tr>
<td>CONTACT:</td>
<?php "<td><input type='text' name='contact' id='txt4' value=".$result['contact']." /><span id='d'></span></td>";?>
</tr>
<tr>
<td><input type="submit" value="UPDATE" name="click" /></td>
<td><input type="reset" value="CANCEL" /></td>
</tr>
</tbody>
</table>
</form>
</div>
</body>
</html>
updateowner.php
<?php
session_start();
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select name,address,email,contact from property_owner where owner_id=".$_SESSION['id'];
$row=mysql_query($query);
$result=mysql_fetch_array($row);
if(isset($_POST['click']))
{
$query="update property_owner set name='".$_POST['name']."',address='".$_POST['address']."',email='".$_POST['emailid']."',contact='".$_POST['contact']."' where owner_id=".$_SESSION['id'];
$k=mysql_query($query);
if($k)
{
echo("information updated");
header('location:dashowner1.php');
}
else
{
mysql_error();
}
}
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
if(chk4())
{
if(chk5())
{
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");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter name!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
function chk4()
{
var elem=document.getElementById("txt3");
var alphaExp = /^([A-Za-z0-9\-\.\_])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/;
if(elem.value.match(alphaExp))
{
document.getElementById("c").innerHTML="";
return true;
}
else
{
document.getElementById("c").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk5()
{
var elem=document.getElementById("txt4");
var alphaExp=/^\d{10}$/;
if(elem.value.match(alphaExp))
{
document.getElementById("d").innerHTML="";
return true;
}
else
{
document.getElementById("d").innerHTML="enter mobile no of 10 digits !";
elem.focus();
return false;
}
}
</script>
</head>
<body><div>
<form method="post" onsubmit="return chk();"/>
<table border="0">
<tbody>
<tr>
<td>NAME:</td>
<?php "<td><input type='text' name='name' id='txt1' value=".$result['name']." /><span id='a'></span></td>";?>
</tr>
<tr>
<td>ADDRESS:</td>
<?php "<td><input type='text' name='address' id='txt2' value=".$result['address']." /><span id='b'></span></td>";?>
</tr>
<tr>
<td>EMAIL-ID:</td>
<?php "<td><input type='text' name='emailid' id='txt3' value=".$result['email']." /><span id='c'></span></td>";?>
</tr>
<tr>
<td>CONTACT:</td>
<?php "<td><input type='text' name='contact' id='txt4' value=".$result['contact']." /><span id='d'></span></td>";?>
</tr>
<tr>
<td><input type="submit" value="UPDATE" name="click" /></td>
<td><input type="reset" value="CANCEL" /></td>
</tr>
</tbody>
</table>
</form>
</div>
</body>
</html>
session_start();
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select name,address,email,contact from property_owner where owner_id=".$_SESSION['id'];
$row=mysql_query($query);
$result=mysql_fetch_array($row);
if(isset($_POST['click']))
{
$query="update property_owner set name='".$_POST['name']."',address='".$_POST['address']."',email='".$_POST['emailid']."',contact='".$_POST['contact']."' where owner_id=".$_SESSION['id'];
$k=mysql_query($query);
if($k)
{
echo("information updated");
header('location:dashowner1.php');
}
else
{
mysql_error();
}
}
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
if(chk4())
{
if(chk5())
{
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");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter name!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
function chk4()
{
var elem=document.getElementById("txt3");
var alphaExp = /^([A-Za-z0-9\-\.\_])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/;
if(elem.value.match(alphaExp))
{
document.getElementById("c").innerHTML="";
return true;
}
else
{
document.getElementById("c").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk5()
{
var elem=document.getElementById("txt4");
var alphaExp=/^\d{10}$/;
if(elem.value.match(alphaExp))
{
document.getElementById("d").innerHTML="";
return true;
}
else
{
document.getElementById("d").innerHTML="enter mobile no of 10 digits !";
elem.focus();
return false;
}
}
</script>
</head>
<body><div>
<form method="post" onsubmit="return chk();"/>
<table border="0">
<tbody>
<tr>
<td>NAME:</td>
<?php "<td><input type='text' name='name' id='txt1' value=".$result['name']." /><span id='a'></span></td>";?>
</tr>
<tr>
<td>ADDRESS:</td>
<?php "<td><input type='text' name='address' id='txt2' value=".$result['address']." /><span id='b'></span></td>";?>
</tr>
<tr>
<td>EMAIL-ID:</td>
<?php "<td><input type='text' name='emailid' id='txt3' value=".$result['email']." /><span id='c'></span></td>";?>
</tr>
<tr>
<td>CONTACT:</td>
<?php "<td><input type='text' name='contact' id='txt4' value=".$result['contact']." /><span id='d'></span></td>";?>
</tr>
<tr>
<td><input type="submit" value="UPDATE" name="click" /></td>
<td><input type="reset" value="CANCEL" /></td>
</tr>
</tbody>
</table>
</form>
</div>
</body>
</html>
Monday, 20 April 2015
<?php
include ('connect.php');
?>
<html>
<head>
<style type="text/css">
span
{
font-size:20px;
font-family:Lucida Handwriting;
font-style:oblique;
font-weight:bold
}
</style>
</head>
<body>
<div>
<table border="0">
<thead>
<tr>
<th>PHOTO OF PROPERTY</th>
<th>ABOUT PROPERTY</th>
</tr>
</thead>
<tbody>
<?php
session_start();
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=property_owner.owner_id where owner_id='".$_SESSION ['id']."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>
<span><a href='editowner.php?oid=".$row['reg_id']."'>EDIT PROPERTY</a></span><br/>
<span><a href='deletepro.php?oid=".$row['reg_id']."'>DELETE PROPERTY</a></span></td>";
echo"</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
include ('connect.php');
?>
<html>
<head>
<style type="text/css">
span
{
font-size:20px;
font-family:Lucida Handwriting;
font-style:oblique;
font-weight:bold
}
</style>
</head>
<body>
<div>
<table border="0">
<thead>
<tr>
<th>PHOTO OF PROPERTY</th>
<th>ABOUT PROPERTY</th>
</tr>
</thead>
<tbody>
<?php
session_start();
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=property_owner.owner_id where owner_id='".$_SESSION ['id']."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>
<span><a href='editowner.php?oid=".$row['reg_id']."'>EDIT PROPERTY</a></span><br/>
<span><a href='deletepro.php?oid=".$row['reg_id']."'>DELETE PROPERTY</a></span></td>";
echo"</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
updateproperty.php
<?php
include ('connect.php');
?>
<html>
<head>
<style type="text/css">
span
{
font-size:20px;
font-family:Lucida Handwriting;
font-style:oblique;
font-weight:bold
}
</style>
</head>
<body>
<div>
<table border="0">
<thead>
<tr>
<th>PHOTO OF PROPERTY</th>
<th>ABOUT PROPERTY</th>
</tr>
</thead>
<tbody>
<?php
session_start();
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=property_owner.owner_id where owner_id='".$_SESSION ['id']."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>
<span><a href='editowner.php?oid=".$row['reg_id']."'>EDIT PROPERTY</a></span><br/>
<span><a href='deletepro.php?oid=".$row['reg_id']."'>DELETE PROPERTY</a></span></td>";
echo"</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
include ('connect.php');
?>
<html>
<head>
<style type="text/css">
span
{
font-size:20px;
font-family:Lucida Handwriting;
font-style:oblique;
font-weight:bold
}
</style>
</head>
<body>
<div>
<table border="0">
<thead>
<tr>
<th>PHOTO OF PROPERTY</th>
<th>ABOUT PROPERTY</th>
</tr>
</thead>
<tbody>
<?php
session_start();
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=property_owner.owner_id where owner_id='".$_SESSION ['id']."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>
<span><a href='editowner.php?oid=".$row['reg_id']."'>EDIT PROPERTY</a></span><br/>
<span><a href='deletepro.php?oid=".$row['reg_id']."'>DELETE PROPERTY</a></span></td>";
echo"</tr>";
}
?>
</tbody>
</table>
</div>
</body>
</html>
Friday, 17 April 2015
<?phpsession_start();?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
return true;
}
}
return false;
}
function chk1()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("a").innerHTML="please enter email!";
return false;
}
else
{
document.getElementById("a").innerHTML="";
return true;
}
}
function chk2()
{
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("a").innerHTML="";
return true;
}
else
{
document.getElementById("a").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk3()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter password!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
</script>
</head>
<body>
<div align="center" style="background-color:#87CEFA;width:400px;height:250px;margin-left:33.3%" >
<h1>LOGIN HERE</h1>
<form method="post" onsubmit="return chk();">
<table border="0" style="font-size:20px">
<tbody>
<tr>
<td><i>USER-NAME:</i></td>
<td><input type="text" name="username" value="" /><span id="a"></span></td>
</tr>
<tr>
<td><i>PASSWORD:</i></td>
<td><input type="password" name="password" value="" /><span id="b"></span></td>
</tr>
<tr>
<td><i>USER-TYPE:</i></td>
<td><select name="usertype">
<option>--SELECT--</option>
<option value="powner">PROPERTY OWNER</option>
<option value="pseekar">PROPERTY SEEKER</option>
</select></td>
</tr>
</tbody>
</table><br/>
<input type="submit" value="LOGIN" name="btn"/>
<br/>
</form>
<a href=""><i>FORGOT Password???</i></a>
</body>
</div>
</html>
<?php
if(isset($_POST['btn']))
{
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$data=$_POST['usertype'];
if($data=='powner')
{
$query="select * from property_owner where email='".$_POST ['username']."' and password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['owner_id'];
header ('location:dashowner1.php');
}
else
{
echo "Wrong email-id or password";
}}
else if($data=='pseeker')
{
$query="select * from propertyseeker where Emailid='".$_POST ['username']."' and Password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['Id'];
header ('location:dashseeker.php');
}
else
{
echo "Wrong email-id or password";
}}
}
else {
echo"PLEASE MAKE A SELECTION AS SEEKER OR OWNER";
}
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
return true;
}
}
return false;
}
function chk1()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("a").innerHTML="please enter email!";
return false;
}
else
{
document.getElementById("a").innerHTML="";
return true;
}
}
function chk2()
{
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("a").innerHTML="";
return true;
}
else
{
document.getElementById("a").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk3()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter password!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
</script>
</head>
<body>
<div align="center" style="background-color:#87CEFA;width:400px;height:250px;margin-left:33.3%" >
<h1>LOGIN HERE</h1>
<form method="post" onsubmit="return chk();">
<table border="0" style="font-size:20px">
<tbody>
<tr>
<td><i>USER-NAME:</i></td>
<td><input type="text" name="username" value="" /><span id="a"></span></td>
</tr>
<tr>
<td><i>PASSWORD:</i></td>
<td><input type="password" name="password" value="" /><span id="b"></span></td>
</tr>
<tr>
<td><i>USER-TYPE:</i></td>
<td><select name="usertype">
<option>--SELECT--</option>
<option value="powner">PROPERTY OWNER</option>
<option value="pseekar">PROPERTY SEEKER</option>
</select></td>
</tr>
</tbody>
</table><br/>
<input type="submit" value="LOGIN" name="btn"/>
<br/>
</form>
<a href=""><i>FORGOT Password???</i></a>
</body>
</div>
</html>
<?php
if(isset($_POST['btn']))
{
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$data=$_POST['usertype'];
if($data=='powner')
{
$query="select * from property_owner where email='".$_POST ['username']."' and password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['owner_id'];
header ('location:dashowner1.php');
}
else
{
echo "Wrong email-id or password";
}}
else if($data=='pseeker')
{
$query="select * from propertyseeker where Emailid='".$_POST ['username']."' and Password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['Id'];
header ('location:dashseeker.php');
}
else
{
echo "Wrong email-id or password";
}}
}
else {
echo"PLEASE MAKE A SELECTION AS SEEKER OR OWNER";
}
?>
loginform.php
<?phpsession_start();?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
return true;
}
}
return false;
}
function chk1()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("a").innerHTML="please enter email!";
return false;
}
else
{
document.getElementById("a").innerHTML="";
return true;
}
}
function chk2()
{
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("a").innerHTML="";
return true;
}
else
{
document.getElementById("a").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk3()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter password!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
</script>
</head>
<body>
<div align="center" style="background-color:#87CEFA;width:400px;height:250px;margin-left:33.3%" >
<h1>LOGIN HERE</h1>
<form method="post" onsubmit="return chk();">
<table border="0" style="font-size:20px">
<tbody>
<tr>
<td><i>USER-NAME:</i></td>
<td><input type="text" name="username" value="" /><span id="a"></span></td>
</tr>
<tr>
<td><i>PASSWORD:</i></td>
<td><input type="password" name="password" value="" /><span id="b"></span></td>
</tr>
<tr>
<td><i>USER-TYPE:</i></td>
<td><select name="usertype">
<option>--SELECT--</option>
<option value="powner">PROPERTY OWNER</option>
<option value="pseekar">PROPERTY SEEKER</option>
</select></td>
</tr>
</tbody>
</table><br/>
<input type="submit" value="LOGIN" name="btn"/>
<br/>
</form>
<a href=""><i>FORGOT Password???</i></a>
</body>
</div>
</html>
<?php
if(isset($_POST['btn']))
{
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$data=$_POST['usertype'];
if($data=='powner')
{
$query="select * from property_owner where email='".$_POST ['username']."' and password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['owner_id'];
header ('location:dashowner1.php');
}
else
{
echo "Wrong email-id or password";
}}
else if($data=='pseeker')
{
$query="select * from propertyseeker where Emailid='".$_POST ['username']."' and Password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['Id'];
header ('location:dashseeker.php');
}
else
{
echo "Wrong email-id or password";
}}
}
else {
echo"PLEASE MAKE A SELECTION AS SEEKER OR OWNER";
}
?>
<html>
<head>
<script type="text/javascript">
function chk()
{
if(chk1() && chk2())
{
if(chk3())
{
return true;
}
}
return false;
}
function chk1()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("a").innerHTML="please enter email!";
return false;
}
else
{
document.getElementById("a").innerHTML="";
return true;
}
}
function chk2()
{
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("a").innerHTML="";
return true;
}
else
{
document.getElementById("a").innerHTML="please enter valid email!";
elem.focus();
return false;
}
}
function chk3()
{
var elem=document.getElementById("txt1");
if(elem.value=="")
{
document.getElementById("b").innerHTML="please enter password!";
return false;
}
else
{
document.getElementById("b").innerHTML="";
return true;
}
}
</script>
</head>
<body>
<div align="center" style="background-color:#87CEFA;width:400px;height:250px;margin-left:33.3%" >
<h1>LOGIN HERE</h1>
<form method="post" onsubmit="return chk();">
<table border="0" style="font-size:20px">
<tbody>
<tr>
<td><i>USER-NAME:</i></td>
<td><input type="text" name="username" value="" /><span id="a"></span></td>
</tr>
<tr>
<td><i>PASSWORD:</i></td>
<td><input type="password" name="password" value="" /><span id="b"></span></td>
</tr>
<tr>
<td><i>USER-TYPE:</i></td>
<td><select name="usertype">
<option>--SELECT--</option>
<option value="powner">PROPERTY OWNER</option>
<option value="pseekar">PROPERTY SEEKER</option>
</select></td>
</tr>
</tbody>
</table><br/>
<input type="submit" value="LOGIN" name="btn"/>
<br/>
</form>
<a href=""><i>FORGOT Password???</i></a>
</body>
</div>
</html>
<?php
if(isset($_POST['btn']))
{
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$data=$_POST['usertype'];
if($data=='powner')
{
$query="select * from property_owner where email='".$_POST ['username']."' and password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['owner_id'];
header ('location:dashowner1.php');
}
else
{
echo "Wrong email-id or password";
}}
else if($data=='pseeker')
{
$query="select * from propertyseeker where Emailid='".$_POST ['username']."' and Password='".$_POST ['password']."'";
$d=mysql_query($query);
$row=mysql_fetch_array($d);
if(mysql_num_rows($d)==1)
{
$_SESSION ['id']=$row ['Id'];
header ('location:dashseeker.php');
}
else
{
echo "Wrong email-id or password";
}}
}
else {
echo"PLEASE MAKE A SELECTION AS SEEKER OR OWNER";
}
?>
Tuesday, 14 April 2015
<html>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
firstform.php
<html>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
Friday, 10 April 2015
<html>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
firstform.php
<html>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
<head>
</head>
<body>
<div style="height:300px; background-color:#F0FFFF">
<form method="post">
<u style="font-size:35px"><i>FIND YOUR PROPERTY</i></u>
<table border="0" style="font-size:30px">
<tbody>
<tr>
<td>State:</td>
<td><select name="state">
<option>--SELECT--</option>
<?php
$query1="select * from states";
$data=mysql_query($query1);
while ($row=mysql_fetch_array ($query1))
{
echo"<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>City:</td>
<td><select name="city">
<option>--SELECT--</option>
<?php
$query2="select * from city";
$data=mysql_query($query2);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Property Type:</td>
<td><select name="ptype">
<option>--SELECT--</option>
<?php
$query="select * from property_type";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<option value=".$row['p_id'].">".$row['p_type']."</option>";
}
?></td>
</tr><br/>
</tbody>
</table>
<input type="submit" value="SEARCH" name="btn">
</form>
</div>
</body>
</html>
<?php
if (isset($_POST['btn']))
{
header ('location:search.php');
$query="SELECT *,states.statename,city.cityname,property_owner.name as oname,property_type.p_type from property_registration join states on states.stateid=
property_registration.state_id join city on city.cityid=property_registration.city_id join property_type on property_type.p_id=
property_registration.p_type join property_owner on property_registration.p_owner=
property_owner.owner_id where p_id='".$_POST['ptype']."' and city_id='".$_POST['city']."' and state_id='".$_POST[state]."'";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{
echo"<table>";
echo"<tbody>";
echo"<tr>";
echo"<td><img src='properties\'".$row['photo']." width='200px' height='250px' alt='Sorry image cannot be displayed'/>
</td>";
echo"<td><span>OWNER NAME:".$row['oname']."</span><br/>
<span>PROPERTY ADDRESS:".$row['p_address']."</span><br/>
<span>STATE:".$row['statename']."</span><br/>
<span>CITY:".$row['cityname']."</span><br/>
<span>PROPERTY FOR:".$row['p_type']."</span><br/>
<span>CONTACT NO:".$row['contact']."</span><br/>";
echo"</tr>";
echo"</tbody>";
echo"</table>";
}
}?>
Sunday, 5 April 2015
<html>
<head>
</head>
<body>
<div align="center" style="background-color:#BDB76B">
<h1><i>Feedback</i></h1>
<form method="post">
<table border="0" style="font-size:20px;font-family:Lucida Handwriting;font-style:oblique;font-weight:bold">
<tbody>
<tr>
<td>NAME:</td>
<td><input type="text" name="name" value="" /></td>
</tr>
<tr>
<td>E-MAIL:</td>
<td><input type="text" name="email" value="" /></td>
</tr>
<tr>
<td>FEEDBACK</td>
<td><textarea name="feedback" rows="4" cols="20">
</textarea></td>
</tr>
</tbody>
</table>
<br/>
<input type="submit" value="ADD" name="btn"/> <input type="reset" value="CANCEL" name="btn1"/>
</form>
</div>
</body>
<?php
if (isset($_POST['btn']))
{
include ('connect.php');
$query="insert into feedback (name,email_id,feedback) values ('".$_POST [name]."','".$_POST[email]."','".$_POST [feedback]."')";
$data=mysql_query($query);
if ($data)
{
echo"Data ho gaya insert";
}
else
{
echo"Data nahi hoya insert";
}
}
?>
</html>
<head>
</head>
<body>
<div align="center" style="background-color:#BDB76B">
<h1><i>Feedback</i></h1>
<form method="post">
<table border="0" style="font-size:20px;font-family:Lucida Handwriting;font-style:oblique;font-weight:bold">
<tbody>
<tr>
<td>NAME:</td>
<td><input type="text" name="name" value="" /></td>
</tr>
<tr>
<td>E-MAIL:</td>
<td><input type="text" name="email" value="" /></td>
</tr>
<tr>
<td>FEEDBACK</td>
<td><textarea name="feedback" rows="4" cols="20">
</textarea></td>
</tr>
</tbody>
</table>
<br/>
<input type="submit" value="ADD" name="btn"/> <input type="reset" value="CANCEL" name="btn1"/>
</form>
</div>
</body>
<?php
if (isset($_POST['btn']))
{
include ('connect.php');
$query="insert into feedback (name,email_id,feedback) values ('".$_POST [name]."','".$_POST[email]."','".$_POST [feedback]."')";
$data=mysql_query($query);
if ($data)
{
echo"Data ho gaya insert";
}
else
{
echo"Data nahi hoya insert";
}
}
?>
</html>
feedbackform.php
<html>
<head>
</head>
<body>
<div align="center" style="background-color:#BDB76B">
<h1><i>Feedback</i></h1>
<form method="post">
<table border="0" style="font-size:20px;font-family:Lucida Handwriting;font-style:oblique;font-weight:bold">
<tbody>
<tr>
<td>NAME:</td>
<td><input type="text" name="name" value="" /></td>
</tr>
<tr>
<td>E-MAIL:</td>
<td><input type="text" name="email" value="" /></td>
</tr>
<tr>
<td>FEEDBACK</td>
<td><textarea name="feedback" rows="4" cols="20">
</textarea></td>
</tr>
</tbody>
</table>
<br/>
<input type="submit" value="ADD" name="btn"/> <input type="reset" value="CANCEL" name="btn1"/>
</form>
</div>
</body>
<?php
if (isset($_POST['btn']))
{
include ('connect.php');
$query="insert into feedback (name,email_id,feedback) values ('".$_POST [name]."','".$_POST[email]."','".$_POST [feedback]."')";
$data=mysql_query($query);
if ($data)
{
echo"Data ho gaya insert";
}
else
{
echo"Data nahi hoya insert";
}
}
?>
</html>
<head>
</head>
<body>
<div align="center" style="background-color:#BDB76B">
<h1><i>Feedback</i></h1>
<form method="post">
<table border="0" style="font-size:20px;font-family:Lucida Handwriting;font-style:oblique;font-weight:bold">
<tbody>
<tr>
<td>NAME:</td>
<td><input type="text" name="name" value="" /></td>
</tr>
<tr>
<td>E-MAIL:</td>
<td><input type="text" name="email" value="" /></td>
</tr>
<tr>
<td>FEEDBACK</td>
<td><textarea name="feedback" rows="4" cols="20">
</textarea></td>
</tr>
</tbody>
</table>
<br/>
<input type="submit" value="ADD" name="btn"/> <input type="reset" value="CANCEL" name="btn1"/>
</form>
</div>
</body>
<?php
if (isset($_POST['btn']))
{
include ('connect.php');
$query="insert into feedback (name,email_id,feedback) values ('".$_POST [name]."','".$_POST[email]."','".$_POST [feedback]."')";
$data=mysql_query($query);
if ($data)
{
echo"Data ho gaya insert";
}
else
{
echo"Data nahi hoya insert";
}
}
?>
</html>
Thursday, 2 April 2015
<html>
<head>
</head>
<body>
<div style="background-color:grey;float:left; height:455px;width:303px">
<span style="font-weight:1500;font-family:Lucida Handwriting;font-size:50px"><b>MANAGE</b></span><br/>
<ul style="font-weight:1500;font-family:Lucida Handwriting;font-size:30px">
<li><a href="dashowner2.php">ADD PROPERTY</a></li>
<li><a href="dashowner3.php">VIEW PROPERTY</a></li>
<li><a href="dashowner3.php">UPDATE OWNER</a></li>
<li><a href="dashowner4.php">CHANGE PASSWORD</a></li>
<li><a href="logout.php">LOGOUT</a></li>
</ul>
</div>
</body>
</html>
<head>
</head>
<body>
<div style="background-color:grey;float:left; height:455px;width:303px">
<span style="font-weight:1500;font-family:Lucida Handwriting;font-size:50px"><b>MANAGE</b></span><br/>
<ul style="font-weight:1500;font-family:Lucida Handwriting;font-size:30px">
<li><a href="dashowner2.php">ADD PROPERTY</a></li>
<li><a href="dashowner3.php">VIEW PROPERTY</a></li>
<li><a href="dashowner3.php">UPDATE OWNER</a></li>
<li><a href="dashowner4.php">CHANGE PASSWORD</a></li>
<li><a href="logout.php">LOGOUT</a></li>
</ul>
</div>
</body>
</html>
dashboard.php
<html>
<head>
</head>
<body>
<div style="background-color:grey;float:left; height:455px;width:303px">
<span style="font-weight:1500;font-family:Lucida Handwriting;font-size:50px"><b>MANAGE</b></span><br/>
<ul style="font-weight:1500;font-family:Lucida Handwriting;font-size:30px">
<li><a href="dashowner2.php">ADD PROPERTY</a></li>
<li><a href="dashowner3.php">VIEW PROPERTY</a></li>
<li><a href="dashowner3.php">UPDATE OWNER</a></li>
<li><a href="dashowner4.php">CHANGE PASSWORD</a></li>
<li><a href="logout.php">LOGOUT</a></li>
</ul>
</div>
</body>
</html>
<head>
</head>
<body>
<div style="background-color:grey;float:left; height:455px;width:303px">
<span style="font-weight:1500;font-family:Lucida Handwriting;font-size:50px"><b>MANAGE</b></span><br/>
<ul style="font-weight:1500;font-family:Lucida Handwriting;font-size:30px">
<li><a href="dashowner2.php">ADD PROPERTY</a></li>
<li><a href="dashowner3.php">VIEW PROPERTY</a></li>
<li><a href="dashowner3.php">UPDATE OWNER</a></li>
<li><a href="dashowner4.php">CHANGE PASSWORD</a></li>
<li><a href="logout.php">LOGOUT</a></li>
</ul>
</div>
</body>
</html>
Subscribe to:
Posts (Atom)