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