经过这么时间又开始写东西了,前段时间因为工作实习和毕业答辩没有时间写博客,乘着还在毕业答辩后在学校的最后一段时间写一下我的毕业设计《基于PHP的网上租房售房系统设计与实现》
我的本专业是渗透测试,但是在选课题的时候没有选到渗透测试的课题,只能选一个php代码编程的,在网上找了一个源码然后修改了一下,顺便复习之前学习的php知识。
网站的代码比较多,这里只写几个系统里面主要的功能和实现代码。
1、网站首页
代码:
<?php require("connection/conn.php"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>南阳房屋销售及租赁系统</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<script language="JavaScript" src="share/nei_fc.js"></script>
<script language="JavaScript">
<!--
function checklogin()
{
if (document.form1.username.value=="")
{
alert("请输入用户名!");
form1.username.focus();
return false;
}
if (document.form1.password.value=="")
{
alert("请输入密码!");
form1.password.focus();
return false;
}
return true;
}
//-->
</script>
<body bgcolor="#CCCCCC" text="#000000" leftmargin="0" topmargin="0">
<?php require ("top.php"); ?>
<div align="center"><marquee style='border:1px solid black;' hspace='30' vspace='10' align='left' behavior='scroll' direction='down' scrollamount='1' scrolldelay='2' width="970" height="50" bgcolor="#A6A6A6" >
<font color="red" size="5">公告:您在使用本网站有任何问题时,请联系网站管理员。联系电话:15038710533</font>
</marquee></div>
<table width="978" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="4" bgcolor="#000000"></td>
</tr>
</table>
<table width="978" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="topkuan">
<tr align="left" valign="top">
<td width="1" bgcolor="#CCCCCC"></td>
<td align="left" valign="top"> <table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr align="left" valign="top" bgcolor="#FFFFFF">
<td width="50%" height="174">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" bgcolor="#708090"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100" height="20"> <div align="center"><strong><font color="green">最新房屋出租信息</font></strong></div></td>
<td><div align="right"><a href="hack.php" target="_blank"><strong><font color="green">更多>></a> </div></td></font></strong>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2" background="images/index_r13_c7.gif">
<?php
$strSql="select * from house_hack where pass='是' order by id desc limit 0,6";
$res=mysql_query($strSql);
while($rs=mysql_fetch_array($res))
{
?>
<a href="sub_hack.php?id=<?php echo $rs["id"]?>" target="_blank">
<tr style="CURSOR: hand">
<td height="24" align="left" class="smallfont"><?php echo $rs["house_name"]?> <?php echo $rs["hx"]?> <font color="#FF6600"><?php echo $rs["pay"]?>(元/月)</font></td>
<td><font color="#666666"><?php echo $rs["date"]?></font></td>
</tr></a>
<tr>
<td height="1" background="../images/line.jpg" colspan="2"></td>
</tr>
<?php
}
?>
<!-- </table></td>
</tr>
</table>
</td>
<td height="174" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" bgcolor="#650103"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" height="20"> <div align="center"><strong><font color="#FFffff">求
租 房 屋</font></strong></div></td>
<td><div align="right"><a href="hire.php" target="_blank">更多>></a> </div></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2" background="images/index_r13_c7.gif">
<?php
$strSql="select * from house_hire where pass='是' order by id desc limit 0,6";
$res=mysql_query($strSql);
while($rs=mysql_fetch_array($res))
{
?>
<a href="sub_hire.php?id=<?php echo $rs["id"]?>" target="_blank">
<tr style="CURSOR: hand">
<td height="24" align="left" class="smallfont">[<?php echo $rs["qy"]?>] <?php echo $rs["hx"]?> <font color="#FF6600"><?php echo $rs["min_pay"]?></font>~<font color="#FF6600"><?php echo $rs["max_pay"]?>(元/月)</font></td>
<td><font color="#666666"><?php echo $rs["date"]?></font></td>
</tr></a>
<tr>
<td height="1" background="../images/line.jpg"></td>
</tr>
<?php
}
?>
</table></td>
</tr>
</table></td>
</tr>
</table> -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="99%" border="0" align="left" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
<tr align="left" valign="top" bgcolor="#FFFFFF">
<td width="50%" height="174" bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" bgcolor="#708090"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100" height="20"> <div align="left"><strong><font color="#006400">最新房屋出售信息</font></strong></div></td>
<td><div align="right"><a href="sell.php" target="_blank"><strong><font color="#006400">更多>></a> </div></td></font></strong>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2" background="images/index_r13_c7.gif">
<?php
$strSql="select * from house_sell where pass='是' order by id desc limit 0,6";
$res=mysql_query($strSql);
while($rs=mysql_fetch_array($res))
{
?>
<a href="sub_sell.php?id=<?php echo $rs["id"]?>" target="_blank">
<tr style="CURSOR: hand">
<td height="24" class="smallfont" align="left"><?php echo $rs["house_name"]?> <?php echo $rs["hx"]?> <font color="#FF6600"><?php echo $rs["pay"]?>(万)</font></td>
<td><font color="#666666"><?php echo $rs["date"]?></font></td>
</tr>
</a>
<tr>
<td height="1" background="../images/line.jpg" colspan="2"></td>
</tr>
<?php
}
?>
<!-- </table></td>
</tr>
</table>
</td>
<td height="174" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" bgcolor="#650103"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80" height="20"> <div align="center"><strong><font color="#FFFFFF" >求
购 房 屋</font></strong></div></td>
<td><div align="right"><a href="buy.php" target="_blank">更多>> </a></div></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="2" background="images/index_r13_c7.gif">
<?php
$strSql="select * from house_buy where pass='是' order by id desc limit 0,6";
$res=mysql_query($strSql);
while($rs=mysql_fetch_array($res))
{
?>
<a href="sub_buy.php?id=<?php echo $rs["id"]?>" target="_blank" >
<tr style="CURSOR: hand">
<td height="24" class="smallfont" align="left">[<?php echo $rs["qy"]?>] <?php echo $rs["hx"]?> <font color="#FF6600"><?php echo $rs["min_pay"]?></font>~<font color="#FF6600"><?php echo $rs["max_pay"]?>(万)</font></td>
<td><font color="#666666"><?php echo $rs["date"]?></font></td>
</tr></a>
<tr>
<td height="1" background="../images/line.jpg" colspan="2"></td>
</tr>
<?php
}
?>
</table></td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
</table> -->
<?php require ("foot.htm"); ?>
</body>
</html>
2、会员注册功能
前端代码:
<?php require("connection/conn.php"); ?>
<html>
<head>
<title>填写注册信息---房屋销售及租赁系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<script language="JavaScript" src="share/nei_fc.js"></script>
<script language="JavaScript">
<!--
function checkdata()
{
if(!CheckIsNull(user.username,"请输入用户名!")) return false;
if(!CheckIsNull(user.name,"请输入姓名!")) return false;
if(!CheckIsNull(user.password,"请输入密码!")) return false;
if(!CheckIsNull(user.qr_password,"请输入确认密码!")) return false;
if(!CheckIsNull(user.tel,"请输入您的联系电话!")) return false;
}
//-->
</script>
<body bgcolor="#cccccc" text="#000000" leftmargin="0" topmargin="0">
<?php require ("top.php"); ?>
<table width="978" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border-color: #FFFFFF black #FFFFFF black; border-style: solid; border-top-width: 2px; border-right-width: 0px; border-bottom-width: 2px; border-left-width: 0px">
<tr>
<td height="28" align="left" bgcolor="#d3d3d3">
<table width="978" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" width="7"> </td>
<td align="left" valign="top" width="459" class="font"><a href="index.php" class="linkfont">首页</a>
>> <a href="reg2.php" class="linkfont">会员注册</a> >> 填写会员资料</td>
<td align="right" valign="middle" width="312"> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="978" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="#FFD1A4">
<tr align="left" valign="top" bgcolor="#FFFFFF">
<form name="user" method="post" action="admin/save_user.php" onSubmit="return checkdata()">
<td width="612" height="147" align="center"> <br>
<span class="font"><font color="#666666"><font color="#999999">尊 敬 的 客
户,为 了 能 您 的 信 息 能 正 常 提 交,请 如 实 填 好 打 "<font color="#FF6600">*</font>"
号 的 部 分</font></font></span><br>
<br>
<table width="573" border="0" cellspacing="3" cellpadding="0" class="xu_kuan">
<tr align="left" valign="middle">
<td width="286" class="font" height="30"> 用 户 名:
<input name="username" type="text" class="textinput" size="20" maxlength="50">
<font color="#FF6600">**</font> </td>
<td width="278" class="font"> 密 码:
<input name="password" type="password" class="textinput" size="20" maxlength="50">
<font color="#FF6600">**</font></td>
</tr>
<tr align="left" valign="middle">
<td width="286" class="font" height="30"> 真实姓名:
<input name="name" type="text" class="textinput" size="20" maxlength="50">
<font color="#FF6600">**</font> </td>
<td width="278" class="font"> 确认密码:
<input name="qr_password" type="password" class="textinput" id="qr_password" size="20" maxlength="50">
<font color="#FF6600">**</font> </td>
</tr>
<tr align="left" valign="middle">
<td width="286" class="font" height="30"> 性 别:
<input type="radio" name="sex" value="男" checked>
<!--<img src="images/ic_male.gif" width="14" height="15">--><strong>男</strong>
<input type="radio" name="sex" value="女">
<!--<img src="images/ic_female.gif" width="14" height="15">--><strong>女</strong> </td>
</tr>
<tr align="left" valign="middle">
<td width="286" class="font" height="30"> 电 话:
<input name="tel" type="text" class="textinput" size="20" maxlength="50">
<font color="#FF6600">**</font> </td>
</tr>
</table>
<br>
<input type="submit" name="Submit42" value="提 交" class="textbotton">
<br>
<br>
</td>
</form>
<!-- <td width="163" height="147"></td>-->
</tr>
</table>
<?php require ("foot.htm"); ?>
</body>
</html>
php处理代码:
<?php
require("../connection/conn.php");
$password = $_POST["password"];
$repassword = $_POST["qr_password"];
if ($password != $repassword) {
echo "<script>alert('两次输入的密码不一致,请重新输入!')</script>";
echo "<script>window.location.href='../reg2.php'</script>";
}
$sql = "select * from house_user where username = \"$username\"";
//echo $sql;
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0)
{
echo "<script>alert('用户名已存在或未注册,请重新输入!')</script>";
echo "<script>window.location.href='../reg2.php'</script>";
}else{
$sql="INSERT INTO `house`.`house_user` (`username` ,`password` ,`name` ,
`sex` ,`tel`) values ('$username','$password','$name','$sex','$tel')";
$res=mysql_query($sql);
if ($res) {
echo "<script>alert('注册成功!')</script>";
echo "<script>window.location.href='../login.php'</script>";
}else{
echo "<script>alert('数据库错误!')</script>";
}
}
?>
3、会员登陆
前端代码:
<?php
session_start();
require("connection/conn.php"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>房屋销售及租赁系统</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<script language="JavaScript" src="share/nei_fc.js"></script>
<script language="JavaScript">
<!--
function checklogin()
{
if (document.form1.username.value=="")
{
alert("请输入用户名!");
form1.username.focus();
return false;
}
if (document.form1.password.value=="")
{
alert("请输入密码!");
form1.password.focus();
return false;
}
return true;
}
//-->
</script>
<body bgcolor="#CCCCCC" text="#000000" leftmargin="0" topmargin="0">
<?php require ("top.php"); ?>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<script language="JavaScript">
<!--
function checklogin()
{
if (document.form1.username.value=="")
{
alert("请输入用户名!");
form1.username.focus();
return false;
}
if (document.form1.password.value=="")
{
alert("请输入密码!");
form1.password.focus();
return false;
}
if (document.form1.user_class.value=="")
{
alert("请选择用户类型!");
form1.user_class.focus();
return false;
}
return true;
}
//-->
</script>
<?php
if ($_SESSION["userlogin"]!="ok")
{
?>
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26" bgcolor="#F9F7CE"> <div align="center"><strong><font color="#FF6600">会员登陆</font></strong></div></td>
</tr>
<tr>
<td bgcolor="#FF9900" height="3"></td>
</tr>
</table>
</div>
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="0">
<form action="checklogin.php" method=post name="form1" onSubmit="return checklogin()">
<tr valign="middle">
<td align="right" class="font">用户名:</td>
<td>
<input type="text" name="username" size="10"> </td>
</tr>
<tr valign="middle">
<td align="right" class="font">密 码:</td>
<td>
<input type="password" name="password" size="10">
</td>
</tr>
<tr align="center" valign="middle">
<td colspan="2">
<input type="submit" name="Submit" value="登陆">
<input type="button" name="Submit2" value="注册" onClick="window.location='reg2.php'" target="_blank"> </td>
</tr>
</form>
</table>
<?php
}
else
{
?>
<table width="154" border="0" align="center" cellpadding="6" cellspacing="0">
<tr>
<td align="left" valign="middle" bgcolor="#FFFFFF" class="xu_kuan"><div align="center"><span class="font">您好!<font color=red><?php echo $_SESSION["user_name"]?></font></span></div></td>
</tr>
<tr>
<td align="left" valign="middle" bgcolor="#FFFFFF" class="xu_kuan"><div align="center"><span class="font">欢迎您<?php echo $_SESSION["loginname"]?>回来...</span></div></td>
</tr>
<tr>
<td align="left" valign="middle" bgcolor="#FFFFFF" class="xu_kuan">
<div align="center"><a href="logout.php" target="_parent"><font color="red">退出登录</font></a></div></td>
</tr>
</table>
<table width="158" align="center" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="25" align="center" valign="middle" class="menu1"><a href="dj_hack.php" class="menu1">出 租 信 息 登 记</a></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="25" align="center" valign="middle"><a href="lyb.php" class="menu1">给 管 理 员 留 言</a></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="25" align="center" valign="middle"><a href="dj_sell.php" class="menu1">出 售 信 息 登 记</a></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="25" align="center" valign="middle"><a href="userchangepass.php" class="menu1">密 码 修 改</a></td>
</tr>
<tr>
<td height="3" align="center" valign="middle"><img src="images/member_small_line.gif" width="158" height="3"></td>
</tr>
<tr>
<td height="25" align="center" valign="middle"><a href="viewadmin_reply.php" class="ffbyfont2"> 查 看 回 复</a></td>
</tr>
</table>
<?php
}
?>
</td>
</tr>
</table>
4、房屋信息查询
代码:
<?php
session_start();
require("connection/conn.php"); ?>
<html>
<head>
<title>房屋出租信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<script language="JavaScript" src="share/nei_fc.js"></script>
<script language="JavaScript">
<!--
function checksearch()
{
if(!CheckIsNumeric(search.search_mj_min,"请在输入框中输入数值!")) return false;
if(!CheckIsNumeric(search.search_mj_max,"请在输入框中输入数值!")) return false;
if(!CheckIsNumeric(search.search_jg_min,"请在输入框中输入数值!")) return false;
if(!CheckIsNumeric(search.search_jg_max,"请在输入框中输入数值!")) return false;
}
//-->
</script>
<body bgcolor="#CCCCCC" leftmargin="0" topmargin="0">
<?php require ("top.php"); ?>
<table width="978" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr align="left" valign="top">
<td width="168">
<?php require ("notlogin.php"); ?>
<td width="1" bgcolor="#CCCCCC"></td>
<td>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="left" valign="top">
<td width="260" height="172"><img src="images/hack_r4_c6.jpg" width="260" height="172"></td>
<td width="10" background="images/hack_r4_c18.jpg"><img src="images/hack_r4_c11.jpg" width="6" height="172"></td>
<td background="images/hack_r4_c18.jpg"><img src="images/hack_r4_c12.gif" width="175" height="42"><br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<form action="hack.php" method=post name="search" onSubmit="return checksearch()">
<tr align="left" valign="middle">
<td width="163" height="25" class="font"><font color="#0066CC">区域:</font>
<select name="search_qy" style="FONT-SIZE: 9pt; WIDTH: 90px; FONT-FAMILY: 宋体; HEIGHT: 22px" >
<option value="" selected>-请选择-</option>
<?php
$Sql="select * from house_area order by id";
$res=mysql_query($Sql);
while($rs0=mysql_fetch_array($res))
echo " <option value=$rs0[area_name]>$rs0[area_name]</option>";
?>
</select> </td>
<td width="163" height="25" class="font"><font color="#0066CC">房屋编号:</font>
<input name="bh" type="text" class="textinput" id="bh" size="9" height="125" width="163">
<!--<select name=search_lx class="textinput">
<option value="" selected>-请选择-</option>
<option value="商品房">商品房</option>
<option value="集资房">集资房</option>
<option value="拆迁房">拆迁房</option>
<option value="写字楼">写字楼</option>
<option value="公房">公房</option>
<option value="店面">店面</option>
<option value="民房">民房</option>
<option value="别墅">别墅</option>
</select>-->
</td>
</tr>
<tr align="left" valign="middle">
<td height="25" class="font"><font color="#0066CC">户型:</font>
<select
name=search_hx style="FONT-SIZE: 9pt; WIDTH: 90px; FONT-FAMILY: 宋体; HEIGHT: 22px" >
<option value="" selected>-请选择-</option>
<option value="4室2厅2卫">4室2厅2卫</option>
<option value="4室2厅1卫">4室2厅1卫</option>
<option value="4室1厅1卫">4室1厅1卫</option>
<option value="3室2厅2卫">3室2厅2卫</option>
<option value="3室2厅1卫">3室2厅1卫</option>
<option value="3室1厅1卫">3室1厅1卫</option>
<option value="2室2厅1卫">2室2厅1卫</option>
<option value="2室1厅1卫">2室1厅1卫</option>
<option value="2室半1厅1卫">2室半1厅1卫</option>
<option value="1室1厅1卫">1室1厅1卫</option>
<option value="单间">单间</option>
<option value="复式">复式</option>
<option value="其他">其他</option>
</select> </td>
<td height="25" class="font"><font color="#0066CC">是否中介:</font>
<select name="search_zj" class="textinput">
<option value="" selected>-请选择-</option>
<option value="非中介">非中介</option>
<option value="中介">中介</option>
</select></td>
</tr>
<tr align="left" valign="middle">
<td height="25" class="font"><font color="#0066CC">面积:</font>
<input name="search_mj_min" type="text" class="textinput" id="min" size="1">
~
<input name="search_mj_max" type="text" class="textinput" id="max" size="1">
㎡</td>
<td height="25" class="font"><font color="#0066CC">价格:</font>
<input name="search_jg_min" type="text" class="textinput" id="min23" size="5">
~
<input name="search_jg_max" type="text" class="textinput" id="max23" size="5">
元</td>
</tr>
<tr align="center" valign="bottom" >
<td height="34" colspan="2" class="font"><input name="imageField" type="image" src="images/search.gif" width="60" height="23" border="0">
</td>
</tr>
</form>
</table> </td>
<td width="25" align="right"><img src="images/hack_r4_c20.jpg" width="25" height="172"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<form name="form4" method="post">
<tr align="center" valign="middle">
<td height="21" bgcolor="#F0F0F0" class="font"><strong>是否中介</strong></td>
<td height="25" bgcolor="#F0F0F0" class="font"><strong>小区名称</strong></td>
<td height="21" bgcolor="#F0F0F0" class="font"><strong>所属区域</strong></td>
<td height="21" bgcolor="#F0F0F0"><strong><font class="font">房型</font></strong></td>
<td height="21" bgcolor="#F0F0F0"><strong><font class="font">面积(㎡)</font></strong></td>
<td height="21" bgcolor="#F0F0F0"><strong><font class="font">租金(元)</font></strong></td>
<td bgcolor="#F0F0F0"><strong><font class="font">登记时间</font></strong></td>
</tr>
<?php
//构造查询条件
$where="";
if($search_qy!="")
$where.="and qy='$search_qy'";
if($bh!="")
$where.="and bh='$bh'";
if($search_zj!="")
$where.="and zj='$search_zj'";
if($search_hx!="")
$where.="and hx='$search_hx'";
if($search_mj_min!="" and $search_mj_max!="")
$where.="and jz_area>='$search_mj_min' and jz_area<='$search_mj_max'";
if($search_jg_min!="" and $search_jg_max!="")
$where.="and pay>='$search_jg_min' and pay<='$search_jg_max'";
$strSql="select * from house_hack where pass='是' $where order by id desc";
//echo $strSql;
$res=mysql_query($strSql);
while($rs=mysql_fetch_array($res))
{
?>
<tr align="center" valign="middle">
<td height="21" bgcolor="#FFFFFF" class="font" ><?php echo $rs["zj"]?></td>
<td height="21" bgcolor="#FFFFFF" ><a href="sub_hack.php?id=<?php echo $rs["id"]?>" target="_blank" class="linkfont"><font color="#FF6600"><?php echo $rs["house_name"]?>
</font></a></td>
<td height="21" bgcolor="#FFFFFF" class="font" ><?php echo $rs["qy"]?></td>
<td height="21" bgcolor="#FFFFFF" class="font" ><?php echo $rs["hx"]?></td>
<td height="21" bgcolor="#FFFFFF" class="font" ><?php echo $rs["jz_area"]?></td>
<td height="21" bgcolor="#FFFFFF" class="font" ><?php echo $rs["pay"]?></td>
<td bgcolor="#FFFFFF" class="font" >
<font color="#FF6600"><?php echo $rs["date"]?></font>
</td>
</tr>
<?php
}
?>
</form>
</table>
</td>
</tr>
</table>
<?php require ("foot.htm"); ?>
</body>
</html>
房屋出租和出售的代码差不多,代码很多可能贴出来的不够全面,后面还有后台管理的代码,有时间在贴出来。