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";
}

?>

loginform.php

Posted on by Unknown with No comments
<?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";
}

?>

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>";
}
}?>

firstform.php

Posted on by Unknown with No comments
<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>";
}
}?>

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>";
}
}?>

firstform.php

Posted on by Unknown with No comments
<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>";
}
}?>

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"/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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

Posted on by Unknown with No comments
<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"/> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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>

dashboard.php

Posted on by Unknown with No comments
<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>

Tuesday, 31 March 2015

<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
</head>
<body>
<div>
<table border="0">
          <thead>
              <tr>
                  <th>property type</th>
              </tr>
          </thead>
 <tbody>
<?php
$query="SELECT * from property_type where p_id=";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{

         
          echo"<tr>";
           echo"<td><img src='properties\'".$row['photo']." width='200px' height='200px' 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/></td>";
            echo"</tr>";
}
?>
          </tbody>
      </table>

</div>
</body>
</html>

viewtype.php

Posted on by Unknown with No comments
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
</head>
<body>
<div>
<table border="0">
          <thead>
              <tr>
                  <th>property type</th>
              </tr>
          </thead>
 <tbody>
<?php
$query="SELECT * from property_type where p_id=";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{

         
          echo"<tr>";
           echo"<td><img src='properties\'".$row['photo']." width='200px' height='200px' 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/></td>";
            echo"</tr>";
}
?>
          </tbody>
      </table>

</div>
</body>
</html>

Friday, 27 March 2015

<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
</head>
<body>
<div>
<table border="0">
          <thead>
              <tr>
                  <th>PHOTO OF PROPERTY</th>
                  <th>ABOUT PROPERTY</th>
              </tr>
          </thead>
 <tbody>
<?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";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{

         
          echo"<tr>";
           echo"<td><img src='properties\'".$row['photo']." width='200px' height='200px' 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/></td>";
            echo"</tr>";
}
?>
          </tbody>
      </table>

</div>
</body>
</html>

view.php

Posted on by Unknown with No comments
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
?>
<html>
<head>
</head>
<body>
<div>
<table border="0">
          <thead>
              <tr>
                  <th>PHOTO OF PROPERTY</th>
                  <th>ABOUT PROPERTY</th>
              </tr>
          </thead>
 <tbody>
<?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";
$data=mysql_query($query);
while ($row=mysql_fetch_array ($data))
{

         
          echo"<tr>";
           echo"<td><img src='properties\'".$row['photo']." width='200px' height='200px' 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/></td>";
            echo"</tr>";
}
?>
          </tbody>
      </table>

</div>
</body>
</html>

Tuesday, 24 March 2015

<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$id;
$row=mysql_query("select p_type from property_type where p_id=".$_GET['id']);
$result=mysql_fetch_array($row);
if(isset($_POST['update']))
{
mysql_query("update property_type set p_type='".$_POST['txt1']."'where p_id=".$_GET['id']);
header('location:delete.php');
}
?>
<html>
<form method="POST">
<body>
<center>
<h2>Enter Proprty Type</h2>
</body>
<table border="2" width="60%"align="center" style="background-color:#E0FFFF">
<tr><td>Enter Proprty Type</td><td><input type="text"name="txt1"value="<?php echo$result['p_type']?>"/>
</tr></td>


</table>
<br/>
<input type="submit"name="update"value="update"/>
</center>
</form>
</html>

typeproperty.php

Posted on by Unknown with No comments
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$id;
$row=mysql_query("select p_type from property_type where p_id=".$_GET['id']);
$result=mysql_fetch_array($row);
if(isset($_POST['update']))
{
mysql_query("update property_type set p_type='".$_POST['txt1']."'where p_id=".$_GET['id']);
header('location:delete.php');
}
?>
<html>
<form method="POST">
<body>
<center>
<h2>Enter Proprty Type</h2>
</body>
<table border="2" width="60%"align="center" style="background-color:#E0FFFF">
<tr><td>Enter Proprty Type</td><td><input type="text"name="txt1"value="<?php echo$result['p_type']?>"/>
</tr></td>


</table>
<br/>
<input type="submit"name="update"value="update"/>
</center>
</form>
</html>
Subscribe to: Posts (Atom)