📄 search.asp
字号:
<%@ ENABLESESSIONSTATE = FALSE %>
<!--壹加壹在线--www.10000cn.com-->
<!--#include file="config.asp" -->
<!--#include file="mdb/conn.asp" -->
<html>
<head>
<%
dim key
if Request.QueryString("key")="" then
Response.Redirect"info.asp?info=请输入关键字"
else
key=Request.QueryString("key")
end if
%>
<title><%=title%> - <%=desktoptitle%></title>
<!--#include file="intop.asp" -->
<TABLE border=0 cellPadding=0 cellSpacing=0 width=750 align=center>
<TBODY>
<TR>
<TD vAlign=top bgcolor=#f2f2f2> <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<tr>
<td width="7750" valign="top" bgcolor="#CCCCCC">
<%
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='3' class='x'><tr><td>您当前的位置：<a href='"&homeurl&"'>"&title&"<a> → <a href='index.asp'>"&desktoptitle&"</a> → 壁纸搜索</td></tr></table>"
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='5'>"
Dim ipagecount
Dim ipagecurrent
Dim strorderBy
Dim irecordsshown
if request.querystring("page")="" then
ipagecurrent=1
else
ipagecurrent=cint(request.querystring("page"))
end if
sql = "SELECT minipic,ck,name,id FROM desktop where name like '%"&trim(key)&"%' ORDER BY id DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.pagesize = 25
rs.cachesize = 25
rs.open sql,conn,1,1
ipagecount = rs.pagecount
If ipagecurrent > ipagecount Then ipagecurrent = ipagecount
If ipagecurrent < 1 Then ipagecurrent = 1
if ipagecount=0 then
response.write "<tr><td align='center'>没 找 到 任 何 文 件</tr></td>"
else
rs.absolutepage = ipagecurrent
irecordsshown = 0
do while irecordsshown<25 and NOT rs.EOF
Response.Write"<tr align='center'>"
Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#e9e9e9' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 察看："&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext
end if
Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#e9e9e9' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 察看："&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext
end if
Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#e9e9e9' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 察看："&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext
end if
Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#e9e9e9' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 察看："&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext
end if
Response.Write"<td width='20%'>"
if not rs.eof then
Response.Write"<table align=center bgcolor='#e9e9e9' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='display.asp?id="&rs("id")&"'><img src='"&rs("minipic")&"' border='0' width=110 height=150></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"'>"&left(rs("name"),3)&"</a> | 察看："&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext
end if
Response.Write"</tr>"
loop
end if
rs.Close
set rs=nothing
Response.Write"</table>"
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='5' class='s'><tr><td height='35'>每页显示 25 个文件 共有 "&ipagecount&" 页 当前为第 "&ipagecurrent&" 页 "
if ipagecurrent=1 then
Response.Write"首页 | "
else
Response.Write"<a href='search.asp?key="&key&"&page=1'>首页</a> | "
end if
if ipagecurrent=1 then
Response.Write"上一页 | "
else
Response.Write"<a href='search.asp?key="&key&"&page="&ipagecurrent-1&"'>上一页</a> | "
end if
if ipagecount>ipagecurrent then
Response.Write"<a href='search.asp?key="&key&"&page="&ipagecurrent+1&"'>下一页</a> "
else
Response.Write"下一页"
end if
if ipagecount>ipagecurrent then
Response.Write"| <a href='search.asp?key="&key&"&page="&ipagecount&"'>末页</a> "
else
Response.Write"| 末页 "
end if
Response.Write"</td></tr></table>"
%>
</td>
</tr>
<TR>
<TD></TD>
</TR>
</TBODY>
</TABLE>
<!--壹加壹在线--www.10000cn.com-->
<SCRIPT language=JavaScript>
<!--
if (window.Event)
document.captureEvents(Event.MOUSEUP);
function nocontextmenu()
{
event.cancelBubble = true
event.returnValue = false;
return false;
}
function norightclick(e)
{
if (window.Event)
{
if (e.which == 2 || e.which == 3)
return false;
}
else
if (event.button == 2 || event.button == 3)
{
event.cancelBubble = true
event.returnValue = false;
return false;
}
}
document.oncontextmenu = nocontextmenu; // for IE5+
document.onmousedown = norightclick; // for all others
//-->
</SCRIPT> <BR></TD>
</TR>
</TBODY>
</TABLE>
<!--#include file="infoot.asp" -->
</BODY></HTML>
<!--壹加壹在线--www.10000cn.com-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -