?? search.asp
字號(hào):
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="sub/config.asp"-->
<!--#include file="sub/conn.asp"-->
<!--#include file="sub/inc.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title><%=Sitename%>-全站搜索</title>
<link href="index.css" rel="stylesheet" type="text/css" />
</head>
<body>
<!--#include file="top.asp"-->
<table width="780" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="200" valign="top" bgcolor="#EEFFFF"><table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="images/websearch.gif" width="200" height="30" /></td>
</tr>
<tr>
<td align="center"><% '調(diào)用全站搜索表單
'翱翔designz.cn制作
call websearch()%> </td>
</tr>
</table></td>
<td colspan="2" valign="top"> <table width="580" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="29"><marquee behavior=alternate onmouseover=stop() onmouseout=start() direction="center" scrollamount="1" scrolldelay="8" >
<font class="top"><%=ad1%></font>
</marquee></td>
</tr>
<tr>
<td height="1" bgcolor="#FF9900"></td>
</tr>
</table>
<table width="580" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<%dim a,b
a=request("search")
b=request("key")
if b<>"" then
if a="搜索動(dòng)態(tài)" then
call snews()
elseif a="搜索圖片" then
call sworks()
elseif a="搜索會(huì)員" then
call suser()
elseif a="搜索下載" then
call sdown()
elseif a="搜索文摘" then
call sbook()
end if
else
response.Write "<ul><li>本搜索引擎可以搜索站內(nèi)各欄目中的相關(guān)內(nèi)容；<li>使用方法如下：<ul ><li>第一步：輸入要搜索的欄目。<li>第二步：輸入要搜索的方式。<li>第三步：輸入要搜索的關(guān)鍵詞。<li>然后點(diǎn)擊提交即可快速搜索到本站相關(guān)資訊。</ul><p> </p><p> </p><p> </p><p> </p><p> </p><p> </p>"
end if%>
<% sub snews()
response.write "全站搜索--"&a&"<br/>"
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from news where title like '%"&b&"%' order by id desc"
rs.open sql,cn,2,1
while not(rs.eof or rs.bof)
response.write("<br/> <a href='shownews.asp?id="&rs("id")&"'><font color='"&rs("color")&"'>"&rs("title")&"</font></a> 發(fā)布日期: "&rs("date")&"<br/>")
rs.movenext
wend
rs.close
set rs=nothing
end sub
sub sworks()
response.write "全站搜索--"&a&"<br/>"
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from pic where title like '%"&b&"%' order by id desc"
rs.open sql,cn,2,1
while not(rs.eof or rs.bof)
response.write("<br/> <a href='showpic.asp?id="&rs("id")&"'>"&rs("title")&"</a> 發(fā)布日期: "&rs("date")&"<br/>")
rs.movenext
wend
rs.close
set rs=nothing
end sub
sub suser()
response.write "全站搜索--"&a&"<br/>"
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from ax_user where name like '%"&b&"%' order by id desc"
rs.open sql,cn,2,1
response.write "<table>"
while not(rs.eof or rs.bof)
response.write "<tr>"
response.write("<td> "&rs("name")&" </td><td>性別:"&rs("sex")&"</td><td>QQ號(hào):"&rs("userqq")&"</td><td>注冊(cè)日期: "&rs("regtime")&"</td>")
response.write "</tr>"
rs.movenext
wend
response.write "</table>"
rs.close
set rs=nothing
end sub
sub sdown()
response.write "全站搜索--"&a&"<br/>"
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from down where title like '%"&b&"%' order by id desc"
rs.open sql,cn,2,1
while not(rs.eof or rs.bof)
response.write("<br/> <a href='showdown.asp?id="&rs("id")&"'>"&rs("title")&"</a> 發(fā)布日期: "&rs("date")&"<br/>")
rs.movenext
wend
rs.close
set rs=nothing
end sub
sub sbook()
response.write "全站搜索--"&a&"<br/>"
dim rs,sql
set rs=server.CreateObject("Adodb.recordSet")
sql="select * from book where title like '%"&b&"%' order by id desc"
rs.open sql,cn,2,1
while not(rs.eof or rs.bof)
response.write("<br/> <a href='showdown.asp?id="&rs("id")&"'>"&rs("title")&"</a> 發(fā)布日期: "&rs("date")&"<br/>")
rs.movenext
wend
rs.close
set rs=nothing
end sub
%>
</td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="bottom.asp"-->
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -