📄 search.asp
字号:
<!--#include file="conn.asp"-->
<%
sql="select * from counst"
set rs=conn.execute(sql)
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title><% =rs("W_name") %></title>
<link href="css/css.css" rel="stylesheet" type="text/css">
</head>
<body topmargin="0" leftmargin="0" bgcolor="#EEEEEE"><table width="779" border="0" align="center" cellpadding="0" cellspacing="0">
<!-- fwtable fwsrc="1 ??±′.png" fwbase="ok2.png" fwstyle="Dreamweaver" fwdocid = "1365122013" fwnested="0" -->
<tr>
<td><img src="images/spacer.gif" width="12" height="1" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="153" height="1" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="604" height="1" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="10" height="1" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td>
</tr>
<tr>
<td rowspan="13"><img name="ok2_r1_c1" src="images/ok2_r1_c1.png" width="12" height="956" border="0" alt=""></td>
<td colspan="2"><img name="ok2_r1_c2" src="images/ok2_r1_c2.png" width="757" height="12" border="0" alt=""></td>
<td rowspan="13"><img name="ok2_r1_c4" src="images/ok2_r1_c4.png" width="10" height="956" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="12" border="0" alt=""></td>
</tr>
<tr>
<td colspan="2"><img name="ok2_r2_c2" src="images/ok2_r2_c2.png" width="757" height="94" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="94" border="0" alt=""></td>
</tr>
<tr>
<td colspan="2"><img src="images/ok2_r3_c2.png" width="757" height="38" border="0" usemap="#Map"></td>
<td><img src="images/spacer.gif" width="1" height="38" border="0" alt=""></td>
</tr>
<tr>
<td><img name="ok2_r4_c2" src="images/ok2_r4_c2.png" width="153" height="32" border="0" alt=""></td>
<td bgcolor="#FFFFFF"><table border="0" width="100%" cellspacing="1">
<tr>
<td width="4%"><img border="0" src="imag/002.gif">
</td>
<td width="96%"><MARQUEE onmouseover="if (document.all!=null){this.stop()}" onmouseout="if (document.all!=null){this.start()}"
scrollAmount=2 scrollDelay=5 color=#000000><% =rs("W_bulletin") %></MARQUEE></td>
</tr>
</table></td>
<td><img src="images/spacer.gif" width="1" height="32" border="0" alt=""></td>
</tr>
<tr>
<td><img name="ok2_r5_c2" src="images/ok2_r5_c2.png" width="153" height="51" border="0" alt=""></td>
<td rowspan="8" valign="top"> <table border="0" width="100%" cellpadding="5">
<tr>
<td width="50%" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="1%"><img border="0" src="imag/k-001.jpg"></td>
<td width="98%" valign="top">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" background="imag/k-002-1.jpg"><img border="0" src="imag/k-002-1.jpg"></td>
</tr>
<tr>
<td width="100%">
<table border="0" width="100%" cellspacing="0" cellpadding="0" bgcolor="#71B51C">
<tr>
<td width="50%">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="33%" bgcolor="#5F5F5F">
<p align="right"><img border="0" src="imag/k-003.jpg"></td>
<td width="33%" bgcolor="#616161">
<p align="center"><b><font style="font-size: 14px" color="#FFFFFF">搜索结果</font></b></td>
<td width="34%" bgcolor="#616161"><img border="0" src="imag/k-004.jpg"></td>
</tr>
</table>
</td>
<td width="50%">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr bgcolor="#616161">
<td width="50%">
</td>
<td width="50%">
<p align="right"><img border="0" src="imag/k-008.jpg"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="1%"><img border="0" src="imag/k-005.jpg"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="1%" background="imag/k-006.jpg"><img border="0" src="imag/k-006.jpg"></td>
<td width="98%">
<%
H_lx=trim(request("lx"))
H_qy=trim(request("qy"))
H_mj=trim(request("mj"))
H_mj1=trim(request("mj1"))
H_jg=trim(request("jg"))
H_jg1=trim(request("jg1"))
set rs=server.createobject("adodb.recordset")
sql="select * from house where mytype='"& H_lx &"' and fw_quyu='"& H_qy &"' and fw_mianji >= "&H_mj&" and fw_mianji <= "&H_mj1&" and fw_jiage >= "&H_jg&" and fw_jiage <= "&H_jg1&" order by id desc"
rs.open sql,conn,1
%>
<TABLE cellSpacing=7 cellPadding=0 width=100% align=center bgColor=#ffffff border=0>
<TBODY>
<TR vAlign=top>
<TD>
<div align="center">
<center><TABLE width="100%" border=0 cellPadding=0 cellSpacing=0 borderColor=#111111 style="BORDER-COLLAPSE: collapse">
<TR>
<TD width="100%"><DIV align=center>
<TABLE cellSpacing=1 cellPadding=0 width="101%" border=0 bgcolor="#CCCCCC">
<TR>
<TD width="11%" bgcolor="#F3F3F3" align="center">类型</TD>
<TD align=center width="13%" bgcolor="#F3F3F3">区域</TD>
<TD align=center width="16%" bgcolor="#F3F3F3">房型</TD>
<TD align=center width="20%" bgcolor="#F3F3F3"> 价格</TD>
<TD align=center width="10%" bgcolor="#F3F3F3">浏览</TD>
<TD align=center width="18%" bgcolor="#F3F3F3">发布时间</TD>
<TD align=center width="12%" bgcolor="#F3F3F3">查看</TD>
</TR>
<%
if rs.bof and rs.eof then
response.write "对不起！没搜索到您要的信息！"
else
page=clng(request.querystring("page"))
if page<1 then page=1
if page>rs.pagecount then page=rs.pagecount
rs.absolutepage=page '跳到多少页
for i=1 to rs.pagesize
%>
<TR>
<TD width="11%" bgcolor="#FFFFFF"><span class="matrix matrix"> <img src="imag/001.gif">
<% =rs("mytype")%>
</span></TD>
<TD align=right width="13%" bgcolor="#FFFFFF"><div align="center" class="matrix matrix">
<% =rs("fw_quyu")%>
</div></TD>
<TD align=left width="16%" bgcolor="#FFFFFF"><div align="center" class="matrix matrix">
<% =rs("fw_jiegou")%>
</div></TD>
<TD align=middle width="20%" bgcolor="#FFFFFF"> <div align="center" class="matrix matrix">
<% =rs("fw_jiage") %>
<% =rs("fw_jiageLX") %>
</div></TD>
<TD align=left width="10%" bgcolor="#FFFFFF"><div align="center" class="matrix matrix"><font color="#666666">
<% =rs("fw_lls") %>
</font></div></TD>
<TD align=left width="18%" bgcolor="#FFFFFF"><div align="center" class="matrix matrix"><font color="#666666">
<% =rs("fw_fbri") %>
</font></div></TD>
<TD align=left width="12%" bgcolor="#FFFFFF"><div align="center" class="matrix matrix"><a href="h_open.asp?id=<%=rs("id")%>">查看</a>
</div></TD>
</TR>
<%
rs.movenext
if rs.eof then exit for
next
end if
%>
</TABLE>
</DIV></TD>
</TR>
<TR>
<TD><div align="right"></div></TD>
</TR>
</TABLE></center>
</div>
</TD>
</TR>
</TBODY>
</TABLE>
</td>
<td width="1%" background="imag/k-006-2.jpg"><img border="0" src="imag/k-006-2.jpg"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%">
<table border="0" width="100%" cellspacing="0" cellpadding="0" background="imag/k-009-2.jpg">
<tr>
<td width="50%"><img border="0" src="imag/k-009-1.jpg"></td>
<td width="50%">
<p align="right"><img border="0" src="imag/k-009-3.jpg"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table></td><td><img src="images/spacer.gif" width="1" height="51" border="0" alt=""></td>
</tr>
<tr>
<td><table width="153" height="120" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top"><!--#include file="huiyuan.asp"--></td>
</tr>
</table></td>
<td><img src="images/spacer.gif" width="1" height="120" border="0" alt=""></td>
</tr>
<tr>
<td><img name="ok2_r7_c2" src="images/ok2_r7_c2.png" width="153" height="20" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="20" border="0" alt=""></td>
</tr>
<tr>
<td><table width="153" height="170" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top"><!--#include file="shousuo.asp"--></td>
</tr>
</table></td>
<td><img src="images/spacer.gif" width="1" height="170" border="0" alt=""></td>
</tr>
<tr>
<td><img name="ok2_r9_c2" src="images/ok2_r9_c2.png" width="153" height="21" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="21" border="0" alt=""></td>
</tr>
<tr>
<td><table width="153" height="77" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top"><!--#include file="tongji.asp"--></td>
</tr>
</table></td>
<td><img src="images/spacer.gif" width="1" height="77" border="0" alt=""></td>
</tr>
<tr>
<td><img name="ok2_r11_c2" src="images/ok2_r11_c2.png" width="153" height="19" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="19" border="0" alt=""></td>
</tr>
<tr>
<td><table width="153" height="205" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top" bgcolor="#E9E7DB"><!--#include file="link.asp"--></td>
</tr>
</table></td>
<td><img src="images/spacer.gif" width="1" height="205" border="0" alt=""></td>
</tr>
<tr>
<td colspan="2"><img name="ok2_r13_c2" src="images/ok2_r13_c2.png" width="757" height="97" border="0" alt=""></td>
<td><img src="images/spacer.gif" width="1" height="97" border="0" alt=""></td>
</tr>
</table>
<map name="Map">
<area shape="rect" coords="180,15,210,30" href="index.asp">
<area shape="rect" coords="229,14,280,31" href="gsjj.asp">
<area shape="rect" coords="306,13,360,30" href="house.asp?lb=出售">
<area shape="rect" coords="376,14,432,30" href="house.asp?lb=求购">
<area shape="rect" coords="459,16,510,30" href="house.asp?lb=出租">
<area shape="rect" coords="529,14,581,31" href="house.asp?lb=求租">
<area shape="rect" coords="602,14,654,30" href="house.asp?lb=合租">
<area shape="rect" coords="678,13,732,32" href="house.asp?lb=留言">
</map>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -