<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>";
}
}?>
0 comments:
Post a Comment