?? search.asp
字號:
<!--#include file="conn.asp"-->
<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>搜索結(jié)果</title>
</head>
<!--#include file="head.asp"-->
<%Const MaxPerPage=10%>
<%
keyword=request("keyword")
if keyword="" then
response.write "<p align='center'> <font size=2>搜索關(guān)鍵字不能為空:"
response.write "<a href='index.asp'>返回首頁</a></font>"
response.end
else
keyword=replace(replace(replace(replace(keyword,"'","‘"),"<","<"),">",">")," "," ")
findword="downname and downjjie like '%"&keyword&"%' "
end if
set rs=server.createobject("adodb.recordset")
set rss=server.createobject("adodb.recordset")
sqlstr="select * from ggao"
rss.open sqlstr,conn,1,1
%>
<%
dim rs,sql
dim totalPut
dim CurrentPage, TotalPages
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
set rs = server.createobject("adodb.recordset")
%>
<body bgcolor="#008080" topmargin="0" leftmargin="0">
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="600" bgcolor="#B3B3B3">
<tr>
<td width="100%"> </td>
</tr>
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="600">
<tr>
<td width="598">
<%
sql="select * from download where "&findword&" "
sql=sql&" order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'><font size=2>沒有搜索到任何相關(guān)的文章:<a href='index.asp'>返回首頁</a></font>"
end if
totalPut=rs.recordcount
if currentpage<1 then
currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showContent
showpage totalput,MaxPerPage,"search.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
showContent
showpage totalput,MaxPerPage,"search.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"search.asp"
end if
end if
rs.close
sub showContent
dim i
i=0
do while not rs.eof
%>
<div align="center">
<table border="1" cellpadding="0" cellspacing="0" width="590" style='border-collapse:collapse' bordercolor=#111111>
<tr>
<td width="100%" colspan="4" bgcolor="#3333CC" height="20" valign="bottom"><font size="2" color="#FFFFFF"><b><a href="show.asp?id=<%=rs("id")%>" target="_blank"><%=rs("downname")%></a></b></font></td>
</tr>
<tr>
<td width="25%" bgcolor=#F5f0eb height="18" valign="bottom">
<p align="left"><font size="2">添加時間:</font></td>
<td width="25%" bgcolor=#F5f0eb height="18" valign="bottom"><%=rs("downtime")%></td>
<td width="25%" bgcolor=#F5f0eb height="18" valign="bottom"><font size="2">推薦等級:</font></td>
<td width="25%" bgcolor=#F5f0eb height="18" valign="bottom"><img src=images/<%=rs("downtjian")%>stars.gif></td>
</tr>
<tr>
<td width="100%" colspan="4" bgcolor="#FFFFFF">簡介<br>
<%
downjjie=rs("downjjie")
if len(downjjie)>50 then
downjjie=left(downjjie,50) & "......"
response.write downjjie
else
response.write downjjie
end if
%>
</td>
</tr>
</table>
</div><p>
<%
i=i+1
if i>=MaxPerPage then exit do
rs.movenext
loop
end sub
%>
</td>
</tr>
<tr>
<td width="598"><%
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
response.write "<p align='center'>"
if CurrentPage<2 then
response.write "<font color='#000080'>首頁 | 上一頁</font> | "
else
response.write "<a href="&filename&"?page=1&keyword="&keyword&">首頁</a> | "
response.write "<a href="&filename&"?&page="&CurrentPage-1&"&keyword="&keyword&">上一頁</a> | "
end if
if n-currentpage<1 then
response.write "<font color='#000080'>下一頁 | 尾頁</font>"
else
response.write "<a href="&filename&"?page="&(CurrentPage+1)&"&keyword="&keyword&">"
response.write "下一頁</a> | <a href="&filename&"?page="&n&"&keyword="&keyword&">尾頁</a>"
end if
response.write "<font color='#000080'> 頁次：</font><strong><font color=red>"&CurrentPage&"</font><font color='#000080'>/"&n&"</strong>頁</font> "
response.write "<font color='#000080'> 共<b>"&totalnumber&"</b>個軟件 <b>"&maxperpage&"</b>軟件/頁</font>"
%>
<%
end function
%></td>
</tr>
<tr>
<td width="598">
<p align="center"><%=rss("ggao")%>
</td>
</tr>
<%
set rs=nothing
conn.close
set conn=nothing
%>
<tr>
<td width="598">
<hr style="border-style: dotted; border-color: #008080">
</td>
</tr>
</center>
<tr>
<td width="500">
<form method="post" action="search.asp">
<p align="center">
<input type="text" name="keyword" size="20" style="background-color: #B3B3B3; border-style: dotted; border-color: #000000"><input type="submit" name="submit" value="搜索">
你搜索的關(guān)鍵字為<%=keyword%>
</form></td>
</tr>
<center>
<tr>
<td width="598">
<p align="center"><!--#include file="foot.asp"--></td>
</tr>
</table>
</center>
</td>
</tr>
</table>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -