📄 search.asp
字号:
<% Response.Buffer=True %>
<!-- #include file="advoces.asp" -->
<% key=trim(request("key"))
'stype=request("stype")
living_room=request("living_room")
city=request("city") %>
<%
city=trim(request("city"))
selectid=request.form("select")
'stype=request("stype")
'city=request.form("city")
'district=request.form("district")
if living_room="noxz" then
sql="select * from bazhu where city & district like '%"&key&"%' order by id desc"
else
sql="select * from bazhu where city & district like '%"&key&"%' and living_room='"&living_room&"' order by id desc"
end if
'else
if living_room="noxz" then
sql="select * from bazhu where city & district like '%"&key&"%' order by id desc"
else
sql="select * from bazhu where city & district like '%"&key&"%' and living_room='"&living_room&"' order by id desc"
end if
'end if
%>
<%
'页面设置
set rs=server.createobject("ADODB.recordset")
if cp="" then
rs.open "select * from bazhu order by time desc",conn,1,1
else
rs.open sql,conn,1,1
end if
if rs.eof or rs.bof then
response.write "数据库为空"
response.end
end if
if rs.eof and cp<>"" then
response.write "对不起，没有查询到您需要的内容！"
response.end
end if
rs.pagesize=20
if request.querystring("page")="" then
rs.absolutepage=1
else
rs.absolutepage=request.querystring("page")
end if
%>
<html>
<head>
<title>搜寻</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!-- 霸猪乐园 E-mail：webmaster@bazhu.com 主页：http://www.bazhu.com QQ:309412-->
<title>房地产频道</title>
<style>
<!-- Style definitions:
.big: biggest font (used on the home page for the date)
.cur: the current channel
.chn: the rest of the channels
.dir: search directories
.sub: search subdirectories
.hdr: headers for sections in outer columns
.itm: items for sections in outer columns
.eng: English text
-->
.big {font-family: Arial, Helvetica, 宋体; font-size: 13pt; font-weight: bold}
.cur {font-family: 宋体; font-size: 9pt; color: #ff0000}
.chn {font-family: 宋体; font-size: 9pt}
.dir {font-family: 宋体; font-size: 11pt; font-weight: bold}
.sub {font-family: 宋体; font-size: 9pt}
.hdr {font-family: 宋体; font-size: 11pt; font-weight: bold}
.itm {font-family: 宋体; font-size: 9pt}
.eng {font-family: Arial, Helvetica, 宋体; font-size: 9pt}
a.hover {color: red}
</style>
</head>
<body bgcolor="#ffffff" link="#000099" alink="#cc0000" vlink="#000099" topmargin="8">
<center>
<table width="700" border="0" cellspacing="0" cellpadding="0" height="5" align="center">
<tr>
<td>
<table border=0 cellpadding=0 cellspacing=0 height=5 width=700>
<tbody>
<tr>
<td>
<table border=0 cellpadding=0 cellspacing=0 width=700>
<tbody>
<tr>
<td valign=center width="150" height="70"><img src="images/bazhu.gif" width="150" height="78"></td>
<td valign=center width="550" height="70">
<div align="center"><a href="http://www.bazhu.com" target="_blank"><img src="images/guanggao.gif" width="400" height="80" border="0"></a></div>
</td>
</tr>
<tr bgcolor=#009900>
<td align=middle class=chn colspan=3 height=24 noWrap>
<div align="center"><a href="http://www.bazhu.com"
target=_blank>霸猪首页</a> § <a href="http://adidas.home.chinaren/hack/index.htm"
target=_blank>网络安全乐园</a> § <a href="http://adidas.home.chinaren.com/asp/index.htm"
target=_blank>猪家ASP</a> § <a href="http://adidas.home.chinaren.com/pig/index.htm">猪猪影视库</a>
§ <a href="http://adidas.home.chinaren.com/joke/index.htm">猪猪笑话</a>
§ <a
href="http://adidas.home.chinaren.com/loto/index.htm" target=_blank>彩票工具园</a>
§ <a href="http://bbs.6to23.com/1/default.asp?name=bazhu">给我留言</a>
§ </div>
</td>
</tr>
<tr bgcolor=#ccffcc>
<td align=middle class=chn
colspan=3 height=25 noWrap>
<table border=0 cellpadding=0 cellspacing=0 width="100%" height="20">
<tr>
<form action=http://www.es123.com/asp/bz/search.asp>
<td colspan=3 align=middle height="4">
<div align="center">
<input type="text" name="look_for">
<input type="submit" value="猪站检索" name="submit22" style="height : 20; width : 80;">
<a href="http://adidas.home.chinaren.com/addjs.htm">网站登陆</a><font color=#0000ff size=2>
</font></div>
</td>
</form>
</tr>
<tbody> </tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</table>
<table width="700" border="0" cellspacing="0" cellpadding="0" height="5">
<tr> </tr>
</table>
<table border=0 cellpadding=0 cellspacing=0 width=700 align="center">
<tr>
<td width=132 bgcolor="#CCFFCC" valign=top>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="itm">
<form name="form1" method="post" action="search.asp">
<tr>
<td width="41%">搜索房源: <br>
户型:
<select name=living_room>
<option value="noxz" 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>
<br>
城市:
<input type=text name=key size="10" maxlength=16 value="">
<br>
<input type="image" name="Submit" src="images/jump.gif" width="31" height="15">
</td>
</tr>
</form>
</table>
</td>
<td width="10"> </td>
<td align=left valign=top width="588">
<table border="0" cellpadding="2" cellspacing="0" width="100%" height="20">
<tr bgcolor="#EBEBEB">
<td width="100%" height="20">
<p class="itm"><a href="http://www.bazhu.com"><font color="#000099">首页</font></a>><font color="#000099"><a href="index.asp">房地产</a>><a href="search.asp">租房需求查询</a>>查询结果列示</font></p>
</td>
</tr>
</table>
<table border=0 cellspacing=3 width="100%">
<tbody>
<tr>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h1.gif" width=32>租房查询</td>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h2.gif" width=32>买商品房</td>
<td class=itm width="25%"><img align=middle border=0 height=29
src="images/h3.gif" width=32>买二手房</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -