<?php
include('topmenu.php');
include('leftmenu.php');
?>
<html>
<body>
<div style="background-color:white;
background-image:url('homeee.jpg');width:1000px;height:500px;
color:orange"/>
<form method="post" enctype="multipart/form-data">
<br/>
Add property
<br/>
Name<input type="text" name="name"/>
</br>
Address<input type="text" name="paddress"/>
<br/>
state <select name="state">
<option>...select...</option>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select * from states";
$data=mysql_query($query);
while($row=mysql_fetch_array($data))
{
echo "<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select>
</br>
city <select name="city" >
<option>...select...</option>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select * from city";
$data=mysql_query($query);
while($row=mysql_fetch_array($data))
{
echo "<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select>
<br/>
Property type<select name="ptype" />
<option>...select...</option>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$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>";
}
?>
</select>
</br>
Price<input type="text" name="price"/>
</br>
choose file<input type="file" name="photo"/><br/>
<input type="submit" value="add" name="btn"/>
<br/>
<?php
if(isset($_POST['btn']))
{
move_uploaded_file($_FILES['photo']['tmp_name'],"upload/".$_FILES['photo']['name']);
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="insert into property_registration(name,p_address,state_id,city_id,p_type,p_owner,price,photo)values('".$_POST['name']."','".$_POST['paddress']."',".$_POST['state'].",".$_POST['city'].",".$_POST['ptype'].",01,'".$_POST['price']."','".$_FILES['photo']['name']."')";
$data=mysql_query($query);
if($data)
{
echo "property submit";
}
else
{
echo mysql_error();
}
}
?>
<br/>
</form>
</div>
</body>
</html>
include('topmenu.php');
include('leftmenu.php');
?>
<html>
<body>
<div style="background-color:white;
background-image:url('homeee.jpg');width:1000px;height:500px;
color:orange"/>
<form method="post" enctype="multipart/form-data">
<br/>
Add property
<br/>
Name<input type="text" name="name"/>
</br>
Address<input type="text" name="paddress"/>
<br/>
state <select name="state">
<option>...select...</option>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select * from states";
$data=mysql_query($query);
while($row=mysql_fetch_array($data))
{
echo "<option value=".$row['stateid'].">".$row['statename']."</option>";
}
?>
</select>
</br>
city <select name="city" >
<option>...select...</option>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="select * from city";
$data=mysql_query($query);
while($row=mysql_fetch_array($data))
{
echo "<option value=".$row['cityid'].">".$row['cityname']."</option>";
}
?>
</select>
<br/>
Property type<select name="ptype" />
<option>...select...</option>
<?php
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$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>";
}
?>
</select>
</br>
Price<input type="text" name="price"/>
</br>
choose file<input type="file" name="photo"/><br/>
<input type="submit" value="add" name="btn"/>
<br/>
<?php
if(isset($_POST['btn']))
{
move_uploaded_file($_FILES['photo']['tmp_name'],"upload/".$_FILES['photo']['name']);
mysql_connect('localhost','root');
mysql_select_db('ibuyhome');
$query="insert into property_registration(name,p_address,state_id,city_id,p_type,p_owner,price,photo)values('".$_POST['name']."','".$_POST['paddress']."',".$_POST['state'].",".$_POST['city'].",".$_POST['ptype'].",01,'".$_POST['price']."','".$_FILES['photo']['name']."')";
$data=mysql_query($query);
if($data)
{
echo "property submit";
}
else
{
echo mysql_error();
}
}
?>
<br/>
</form>
</div>
</body>
</html>
0 comments:
Post a Comment