📄 search.asp
字号:
<%if trim(request("search"))="" then response.redirect "javascript:histroy.go(-1)"
n=request("n")
if trim(n)="" then n=0%>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<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>武义热线--供求热线专栏</title>
<style>
<!--
td { font-size: 9pt }
A:link {text-decoration: none; color:#000000}
A:visited {text-decoration: none; color: #000000}
A:active {text-decoration: none; color: #FF0000}
A:hover {text-decoration: underline; color: FF0000}
-->
</style>
</head>
<body topmargin="10" leftmargin="0" bgcolor="#FFFFFF">
<div align="center">
<center>
<table border="0" width="760" cellspacing="1" cellpadding="0">
<tr>
<td width="228" valign="middle"><img border="0" src="wyrx.gif"></td>
<td width="522" valign="middle" align="center"><img border="0" src="ggt.gif"></td>
</tr>
<tr>
<td width="754" bgcolor="#FEAC37" height="1" colspan="2"></td>
</tr>
<tr>
<td bgcolor="#FFCC99" colspan="2" align="center"><a href="index.asp">首页</a>
<a href="wh.asp?n=1">求租</a>
<a href="wh.asp?n=2"> 求购</a> <a href="wh.asp?n=3"> 招租</a> <a href="wh.asp?n=4">
招聘</a> <a href="wh.asp?n=5"> 转让</a> <a href="wh.asp?n=6"> 印刷</a>
<a href="wh.asp?n=7"> 运输</a> <a href="wh.asp?n=8"> 搬迁</a> <a href="wh.asp?n=9"> 维修</a>
<a href="wh.asp?n=10"> 装修</a> <a href="wh.asp?n=11"> 咨询</a> <a href="wh.asp?n=12"> 礼仪</a>
<a href="wh.asp?n=13"> 翻译</a> <a href="wh.asp?n=14">
家政</a> <a href="wh.asp?n=15"> 求职</a>
<a href="wh.asp?n=17"> 招生</a> <a href="wh.asp?n=18"> 声明</a> <a href="wh.asp?n=19"> 启事</a>
<a href="wh.asp?n=20"> 征婚</a> <a href="wh.asp?n=21"> 培训</a> <a href="wh.asp?n=22"> 旅游</a>
<a href="wh.asp?n=23">
生日</a> <a href="wh.asp?n=24"> 娱乐</a> <a href="wh.asp?n=16"> 其它</a></td>
</tr>
<tr>
<td width="754" bgcolor="#FEAC37" height="1" colspan="2"></td>
</tr>
<tr>
<td width="754" height="5" colspan="2"></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" width="760" cellspacing="0" cellpadding="0">
<tr>
<td width="157" valign="top">
<div align="center">
<center>
<table border="0" width="90%" cellspacing="0">
<tr>
<td width="100%" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr>
<td width="100%"><form method="POST" action="addmesg.asp">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%" background="bk1.gif">
信息添加</td>
</tr>
<tr>
<td width="100%" align="center">
<select size="1" name="adwh" style="background-color: #FFFFE6">
<option <%if request("n")=1 then response.write "selected"%>>求租信息</option>
<option <%if request("n")=2 then response.write "selected"%>>求购信息</option>
<option <%if request("n")=3 then response.write "selected"%>>招租信息</option>
<option <%if request("n")=4 then response.write "selected"%>>招聘信息</option>
<option <%if request("n")=5 then response.write "selected"%>>转让信息</option>
<option <%if request("n")=6 then response.write "selected"%>>印刷信息</option>
<option <%if request("n")=7 then response.write "selected"%>>运输信息</option>
<option <%if request("n")=8 then response.write "selected"%>>搬迁信息</option>
<option <%if request("n")=9 then response.write "selected"%>>维修信息</option>
<option <%if request("n")=10 then response.write "selected"%>>装修信息</option>
<option <%if request("n")=11 then response.write "selected"%>>咨询信息</option>
<option <%if request("n")=12 then response.write "selected"%>>礼仪信息</option>
<option <%if request("n")=13 then response.write "selected"%>>翻译信息</option>
<option <%if request("n")=14 then response.write "selected"%>>家政信息</option>
<option <%if request("n")=15 then response.write "selected"%>>求职信息</option>
<option <%if request("n")=17 then response.write "selected"%>>招生信息</option>
<option <%if request("n")=18 then response.write "selected"%>>声明信息</option>
<option <%if request("n")=19 then response.write "selected"%>>启事信息</option>
<option <%if request("n")=20 then response.write "selected"%>>征婚信息</option>
<option <%if request("n")=21 then response.write "selected"%>>培训信息</option>
<option <%if request("n")=22 then response.write "selected"%>>旅游景点</option>
<option <%if request("n")=23 then response.write "selected"%>>生日信息</option>
<option <%if request("n")=24 then response.write "selected"%>>娱乐信息</option>
<option <%if request("n")=16 then response.write "selected"%>>其它信息</option>
</select><input type="submit" value="添加" name="B1" style="background-color: #FFFFE6; font-size: 9pt; border-style: solid; border-color: #000000"></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td width="100%" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr>
<td width="100%"> <form method="POST" action="search.asp">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%" background="bk1.gif">
信息搜索</td>
</tr>
<tr>
<td width="100%" align="center">
<input type="hidden" name="n" value="<%if request("n")=0 then
response.write "0"
else
response.write request("n")
end if%>">
<input type="text" name="search" size="15"></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td width="100%" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr>
<td width="100%">
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td width="100%" background="bk1.gif">
搜索帮助</td>
</tr>
<tr>
<td width="100%">
您现在使用的是本站的智能搜索器，如果您在首页上使用信息搜索，搜索器将搜索站内全部信息资源；如果您在各类信息页上使用信息搜索，搜索器将搜索您所在信息类别的信息资源。</td>
</tr>
<tr>
<td width="100%" align="center" valign="top"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%" bgcolor="#FEAC37" height="1"></td>
</tr>
</table>
</center>
</div>
</td>
<td width="599" valign="top">
<div align="center">
<center>
<table border="0" width="90%">
<tr>
<td width="100%" colspan="3"><span style="background-color: #FFCC99"><font color="#FFFFE6">||
</font><%if request("n")=0 then response.write "全部信息"
if request("n")=1 then response.write "求租信息"
if request("n")=2 then response.write "求购信息"
if request("n")=3 then response.write "招租信息"
if request("n")=4 then response.write "招聘信息"
if request("n")=5 then response.write "转让信息"
if request("n")=6 then response.write "印刷信息"
if request("n")=7 then response.write "运输信息"
if request("n")=8 then response.write "搬迁信息"
if request("n")=9 then response.write "维修信息"
if request("n")=10 then response.write "装修信息"
if request("n")=11 then response.write "咨询信息"
if request("n")=12 then response.write "礼仪信息"
if request("n")=13 then response.write "翻译信息"
if request("n")=14 then response.write "家政信息"
if request("n")=15 then response.write "求职信息"
if request("n")=17 then response.write "招生信息"
if request("n")=18 then response.write "声明信息"
if request("n")=19 then response.write "启事信息"
if request("n")=20 then response.write "征婚信息"
if request("n")=21 then response.write "培训信息"
if request("n")=22 then response.write "旅游景点"
if request("n")=23 then response.write "生日信息"
if request("n")=24 then response.write "娱乐信息"
if request("n")=16 then response.write "其它信息"%>-搜索结果 </span><font color="#FFFFE6"><span style="background-color: #FFCC99">||</span></font></td>
</tr>
<tr>
<td width="100%" height="5" colspan="3"></td>
</tr>
<%set com=server.createobject("adodb.connection")
com.open "DBQ="& server.mappath("joh20msg.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"
if request("n")=0 then
set rs=com.execute("select*from msg where tit like '%"& request("search") &"%' and edt>=#" & date & "# ORDER BY id DESC")
else
set rs=com.execute("select*from msg where tit like '%"& request("search") &"%' and kin='" & request("n") &"' and edt>=#" & date & "# ORDER BY id DESC")
end if
page=request("page")
newpage=0
if page="" then page=1
do while newpage<page*21-21
newpage=newpage+1
rs.movenext
loop
do while not rs.eof
i=i+1%>
<tr>
<td width="65%"><a href="show.asp?n=<%response.write rs(0)%>"><%response.write rs(1)%></a></td>
<td width="25%"><%response.write rs(4)%></td>
<td width="10%">
<%response.write rs(7)%></td>
</tr>
<%if i=20 then exit do
rs.movenext
loop%>
</table><p align="right"><%if page=1 then %>上一页<%else%><a href="search.asp?search=<%=request("search")%>&page=<%=page-1%>&n=<%=n%>"><font color="#0000FF">上一页</font></a>
<%end if%> <%if i=20 and not rs.eof then %><a href="search.asp?search=<%=request("search")%>&page=<%=page+1%>&n=<%=n%>"><font color="#0000FF">下一页</font></a><%else%>下一页<%end if%>
<p>
</center>
</div>
</td>
</tr>
<tr>
<td width="758" colspan="2"></td>
</tr>
</table>
</center>
</div>
<div align="center">
<center>
<table border="0" width="760" cellspacing="1" cellpadding="0">
<tr>
<td width="754" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr>
<td bgcolor="#FFCC99" align="center"><a href="index.asp">首页</a>
<a href="wh.asp?n=1">求租</a>
<a href="wh.asp?n=2"> 求购</a> <a href="wh.asp?n=3"> 招租</a> <a href="wh.asp?n=4">
招聘</a> <a href="wh.asp?n=5"> 转让</a> <a href="wh.asp?n=6"> 印刷</a>
<a href="wh.asp?n=7"> 运输</a> <a href="wh.asp?n=8"> 搬迁</a> <a href="wh.asp?n=9"> 维修</a>
<a href="wh.asp?n=10"> 装修</a> <a href="wh.asp?n=11"> 咨询</a> <a href="wh.asp?n=12"> 礼仪</a>
<a href="wh.asp?n=13"> 翻译</a> <a href="wh.asp?n=14">
家政</a> <a href="wh.asp?n=15"> 求职</a>
<a href="wh.asp?n=17"> 招生</a> <a href="wh.asp?n=18"> 声明</a> <a href="wh.asp?n=19"> 启事</a>
<a href="wh.asp?n=20"> 征婚</a> <a href="wh.asp?n=21"> 培训</a> <a href="wh.asp?n=22"> 旅游</a>
<a href="wh.asp?n=23">
生日</a> <a href="wh.asp?n=24"> 娱乐</a> <a href="wh.asp?n=16"> 其它</a></td>
</tr>
<tr>
<td width="754" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr>
<td height="21" align="center"><%rs.close
com.close%>武义热线版权所有</td>
</tr>
</table>
</center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -