基于PHP的网上租房售房系统设计与实现

经过这么时间又开始写东西了,前段时间因为工作实习和毕业答辩没有时间写博客,乘着还在毕业答辩后在学校的最后一段时间写一下我的毕业设计《基于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">更多&gt;&gt;</a>&nbsp;</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"]?>&nbsp;<?php echo $rs["hx"]?>&nbsp;<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">更多&gt;&gt;</a>&nbsp;</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"]?>]&nbsp;<?php echo $rs["hx"]?>&nbsp;<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">更多&gt;&gt;</a>&nbsp;</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"]?>&nbsp;<?php echo $rs["hx"]?>&nbsp;<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">更多&gt;&gt;&nbsp;</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"]?>]&nbsp;<?php echo $rs["hx"]?>&nbsp;<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">&nbsp;</td>
          <td align="left" valign="top" width="459" class="font"><a href="index.php" class="linkfont">首页</a>
            &gt;&gt; <a href="reg2.php" class="linkfont">会员注册</a> &gt;&gt; 填写会员资料</td>
          <td align="right" valign="middle" width="312">&nbsp;</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">尊 敬 的 客
        户,为 了 能 您 的 信 息 能 正 常 提 交,请 如 实 填 好 打 &quot;<font color="#FF6600">*</font>&quot;
        号 的 部 分</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">&nbsp;用 户 名:
              <input name="username" type="text" class="textinput" size="20" maxlength="50">
              <font color="#FF6600">**</font> </td>
            <td width="278" class="font">&nbsp;密  码:
              <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">&nbsp;真实姓名:
              <input name="name" type="text" class="textinput" size="20" maxlength="50">
              <font color="#FF6600">**</font> </td>
            <td width="278" class="font">&nbsp;确认密码:
              <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">&nbsp;性  别:
              <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">&nbsp;电  话:
              <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>

房屋出租和出售的代码差不多,代码很多可能贴出来的不够全面,后面还有后台管理的代码,有时间在贴出来。

  • 3
    点赞
  • 40
    收藏
    觉得还不错? 一键收藏
  • 17
    评论
一、项目简介本课程演示的是一套基于SSM实现房屋租赁系统,主要针对计算机相关专业的正在做毕设的学生与需要项目实战练习的Java学习者。课程包含: 1. 项目源码、项目文档、数据库脚本、软件工具等所有资料2. 带你从零开始部署运行本套系统3. 该项目附带的源码资料可作为毕设使用4. 提供技术答疑和远程协助指导二、技术实现 后台框架:Spring、SpringMVC、MyBatisUI界面:jQuery 、JSP数据库:MySQL 三、系统功能系统分为前台用户界面和后台系统管理:1. 前台用户界面    用户注册、用户登录、用户中心、浏览房源、房源搜索    查看房源明细、发布房源、提交合同、新闻公告、留言交流2. 后台系统管理    用户管理:用户列表、用户删除、用户查询    新闻管理:新闻列表、添加新闻、修改新闻、删除新闻、查询新闻    房屋管理:房屋列表、房屋删除、分页查看    留言管理:留言列表、留言删除、留言查询、留言回复列表、回复查询    租赁合同管理:合同列表、查看合同、删除合同    管理员管理:管理员管理、新增管理员、编辑管理员、删除管理员等 四、项目截图1)前台用户界面 2)后台系统管理    更多Java毕设项目请关注【毕设系列课程】https://edu.csdn.net/lecturer/2104   点击 我的百科 ,通过百度百科更多了解我 ^_^ 

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 17
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值