📄 search.asp
字号:
<%if trim(request("search"))="" then
Response.Write ("<script>alert('对不起，内容不能为空！');javascript:history.back(1)</script>")
end if
%>
<%
n=request("n")
if trim(n)="" then n=0%>
<html>
<head>
<title>汕头商城—分类信息</title>
<STYLE>BODY {
FONT-SIZE: 9pt
}
TD {
FONT-SIZE: 9pt
}
A {
TEXT-DECORATION: none
}
A:hover {
TEXT-DECORATION: underline
}
</STYLE>
<SCRIPT language=javascript> </SCRIPT>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0">
<div align="center">
<table width="778" border="0" cellspacing="0" cellpadding="0" height="65">
<tr>
<td height="69" width="199"><a href="../"><img src="../pic/logo.jpg" width="195" height="60" border="0"></a></td>
<td height="69" width="496">
<div align="center"><a href="http://www.j3j4.net"><img src="../pic/banner.gif" width="468" height="60" border="0"></a></div>
</td>
<td height="69" width="83">
<table width="80" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><a href="../other/index.htm">关 于 本 站</a></td>
</tr>
<tr>
<td><a href="mailto:webmaster@0754b2c.com">联 系 我 们</a></td>
</tr>
<tr>
<td><a href="../other/shopadd.htm">网 店 建 设</a></td>
</tr>
<tr>
<td><a href="../myshop/login.asp">商 家 登 录</a></td>
</tr>
</table>
</td>
</tr>
</table>
<table border="0" width="770" cellspacing="1" cellpadding="0">
<tr>
<td width="754" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr bgcolor="#FFCC99">
<td 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 bgcolor="#FFFFE6">
<td width="754" height="1" bgcolor="#FFFFF4"> </td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="769" height="241" align="center">
<tr valign="top">
<td width="170" height="241" bgcolor="#FFECD9" style="border-right: 1 solid #FEAC37">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="150">
<tr>
<td background="bg.gif" height="19" valign="bottom">
<p align="center"><font color="#6600CC"><b>[ </b></font>专 题 栏 目
<b><font color="#6600CC">]</font> </b></p>
</td>
</tr>
<tr>
<td height="15">
<table align="center">
<tr>
<td bgcolor="#fffadf" height="20" width="100%"><font color="#bbbbff">◎</font><a href="#">汕头商城隆重推出</a></td>
</tr>
<tr>
<td bgcolor="#fffadf" height="20" width="100%"><font color="#bbbbff">◎</font><a href="#">免费建设网上商店</a></td>
</tr>
<tr>
<td bgcolor="#fffadf" height="20" width="100%"><font color="#bbbbff">◎</font><a href="#">汕头商城隆重推出</a></td>
</tr>
<tr>
<td bgcolor="#fffadf" height="20" width="100%"><font color="#bbbbff">◎</font><a href="#">汕头商城隆重推出</a></td>
</tr>
<tr>
<td bgcolor="#fffadf" height="20" width="100%"><font color="#bbbbff">◎</font><a href="#">汕头商城隆重推出</a></td>
</tr>
<tr>
<td bgcolor="#fffadf" height="20" width="100%"><font color="#bbbbff">◎</font><a href="#">汕头商城隆重推出</a></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="204">
<tr>
<td background="bg.gif" height="19" valign="bottom">
<p align="center"><font color="#6600CC"><b>[ </b></font>图 片 广 告
<font color="#6600CC"><b>]</b></font> </p>
</td>
</tr>
<tr>
<td height="64" align="center"> <img border="0" src="kingkow.gif">
</td>
</tr>
<tr>
<td height="59" align="center"> <img border="0" src="kingkow.gif">
</td>
</tr>
<tr>
<td height="60" align="center"><img border="0" src="kingkow.gif">
</td>
</tr>
</table>
</td>
<td width="7" height="241"></td>
<td width="428" height="241">
<table width="421" border="0" cellspacing="0" cellpadding="0" height="78">
<tr>
<td width="183" height="16"> <font color="#6600CC"><b>[</b></font><b><font color="#6600CC">
<%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 "其它信息"%>
]</font></b>——搜索结果 </td>
<td width="234" height="16"> </td>
</tr>
<tr>
<td colspan="2" background="bj.gif" height="28" width="419"> <form method="POST" action="search.asp">
搜索信息：
<input type="text" name="search" size="15">
<select size="1" name="n" >
<option value="0">所有信息</option>
<option value="1" >招租信息</option>
<option value="2" >招聘信息</option>
<option value="3" >转让信息</option>
<option value="4" >购物信息</option>
<option value="5" >饮食信息</option>
<option value="6" >家居信息</option>
<option value="7" >服饰信息</option>
<option value="8" >娱乐信息</option>
<option value="9" >医药信息</option>
<option value="10" >美容信息</option>
<option value="11" >教育信息</option>
<option value="12" >培训信息</option>
<option value="13" >旅游信息</option>
<option value="14" >交通信息</option>
<option value="15" >礼仪信息</option>
<option value="17" >咨询信息</option>
<option value="18" >印刷信息</option>
<option value="19" >搬迁信息</option>
<option value="20" >维修信息</option>
<option value="21" >广告信息</option>
<option value="22" >通讯信息</option>
<option value="23" >装修信息</option>
<option value="24" >家政信息</option>
<option value="16" >其它信息</option>
</select>
<input type="submit" name="Submit1" src style="BACKGROUND-COLOR: #FEAC37; BORDER-BOTTOM: #000875 1px solid; BORDER-LEFT: #9aa3ff 1px solid; BORDER-RIGHT: #000875 1px solid; BORDER-TOP: #9aa3ff 1px solid; COLOR: #efefef; HEIGHT: 20px" value="模糊查询">
</td>
</tr>
<tr>
<td colspan="2" height="17" width="419">
<table width="100%" border="0" cellspacing="3" cellpadding="2">
<tr bgcolor="#FFCC99">
<td width="53%"> 题 目</td>
<td width="32%"> 时 间</td>
<td width="15%"> 地 点</td>
</tr>
<%set com=server.createobject("adodb.connection")
com.open "DBQ="& server.mappath("erdfg.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"
if request("n")=0 then
set rs=com.execute("select*from msg where tit like '%"& request("search") &"%' ORDER BY id DESC")
else
set rs=com.execute("select*from msg where tit like '%"& request("search") &"%' and kin='" & request("n") &"' ORDER BY id DESC")
end if
page=request("page")
newpage=0
if page="" then page=1
do while newpage<page*14-14
newpage=newpage+1
rs.movenext
loop
do while not rs.eof
i=i+1%>
<tr bgcolor="#FFFFCC">
<td width="53%" bgcolor="#FFF5EC"> <a href="show.asp?n=<%response.write rs(0)%>">
<%response.write rs(1)%>
</a></td>
<td width="32%" bgcolor="#FFF5EC">
<%response.write rs(4)%>
</td>
<td width="15%" bgcolor="#FFF5EC">
<%response.write rs(7)%>
</td>
<%if i=13 then exit do
rs.movenext
loop%>
</table>
</td>
</tr>
<tr>
<td colspan="2" height="17" width="419">
<div 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=13 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%>
</div>
</td>
</tr>
</table>
</td>
<td width="10" height="241"></td>
<td width="154" height="241"><a href="fabu.asp"><img src="fapu.gif" width="151" height="360" border="0"></a></td>
</tr>
</table>
<table border="0" width="769" cellspacing="1" cellpadding="0" align="center">
<tr>
<td width="763" bgcolor="#FEAC37" height="1"></td>
</tr>
<tr>
<td bgcolor="#FFCC99" align="center" width="763">
<hr>
</td>
</tr>
<tr>
<td width="763" bgcolor="#FEAC37" height="1"></td>
</tr>
</table>
<%rs.close
com.close%>
<br>
<table width="778" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center"> 版权所有：汕头商城 www.0754b2c.com 客户服务电话：800-830-9740<br>
<br>
如果您对我们的服务有任何意见或建议，请惠赐E-mail至:<a href="mailto:webmaster@0754b2c.com">webmaster@0754b2c.com</a>欢迎社会各界洽谈合作事宜</div>
</td>
</tr>
</table>
<br>
</div>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -