⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 search.asp

📁 这是我刚从网上下载的一个加密相册的程序,相当好,供大家参考学习
💻 ASP
字号:
<%@ ENABLESESSIONSTATE = FALSE %>
<!--#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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
a {  font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>; text-decoration: none}
a:hover {  font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>; text-decoration: underline}
td {  font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>}
br {  font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none; color: <%=fontcolor%>}
.bk { font-size: 9pt; border: 1px <%=xcolor%> solid}
body {  font-family: "宋体"; font-size: 9pt; font-style: normal; line-height: 13pt; font-weight: normal; font-variant: normal; text-transform: none}
.an {  font-family: "宋体"; font-size: 9pt; background-color: <%=bgcolor%>; border: 1px <%=xcolor%> solid; color: <%=fontcolor%>}
.xzy {  border: <%=xcolor%> solid; border-width: 0px 1px 1px}
.zx {  border: <%=xcolor%> solid; border-width: 0px 0px 1px 1px}
.sxz {  border: <%=xcolor%> solid; border-width: 1px 0px 1px 1px}
.s {  border: <%=xcolor%>; border-style: solid; border-top-width: 1px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px}
.y {  border: <%=xcolor%>; border-style: solid; border-top-width: 0px; border-right-width: 1px; border-bottom-width: 0px; border-left-width: 0px}
.font {  font-family: "Arial Black"; font-size: 14pt; color: <%=fontcolor%>}
.x {  border: <%=xcolor%>; border-style: solid; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px}
.z {  border: <%=xcolor%>; border-style: solid; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 1px}
.sx {  border: <%=xcolor%>; border-style: solid; border-top-width: 1px; border-right-width: 0px; border-bottom-width: 1px; border-left-width: 0px}
.bk1 {
	BORDER-BOTTOM: #999999 1px dashed; BORDER-LEFT: #999999 1px dashed; BORDER-RIGHT: #999999 1px dashed; BORDER-TOP: #999999 1px dashed
-->
</style>
</head>

<body bgcolor="<%=bgcolor%>" text="#000000">
<!--#include file="top.asp" -->
<table width="764" border="0" cellspacing="0" cellpadding="3" align="center" class="xzy" height="25">
  <tr> 
  <td bgcolor="<%=titlecolor%>"> 站内导航:<a href="index.asp">返回首页</a> 
<%
sql = "SELECT * FROM type ORDER BY id ASC" 
Set rs = Server.CreateObject("ADODB.Recordset")
rs.OPEN sql,Conn,0,1
if rs.eof and rs.bof then
Response.Write"还没有分类"
else
do while not rs.eof
Response.Write"| <a href='type.asp?typeid="&rs("id")&"'>"&rs("name")&"</a>"
rs.movenext
loop
end if
rs.close
Set rs=Nothing
%>
  </td>
 </tr>
</table>
<table width="764" border="0" cellspacing="0" cellpadding="5" align="center" class="xzy" height="400" bgcolor="#FFFFFF">
  <tr> 
  <td width="179" valign="top" class="y" align="center"> 
   <table width="100%" border="0" cellspacing="0" cellpadding="5">
    <form name="form1" method="get" action="search.asp">
     <tr> 
      <td width="63%">搜索文件 ↓</td>
      <td width="37%" align="right">Search</td>
     </tr>
     <tr align="center"> 
      <td colspan="2" class="s"> 
       <input type="text" name="key" size="15" class="an">
       <input type="submit" name="Submit" value="确定" class="an">
      </td>
     </tr>
    </form>
   </table>
      <table border=0 cellpadding=0 cellspacing=0 width="100%">
        <tbody> 
        <tr> 
          <td><img height=128 src="images/xc_1.jpg" 
                  width=217></td>
        </tr>
        <tr> 
          <td><img height=155 src="images/xc_2.jpg" 
                  width=217></td>
        </tr>
        <tr> 
          <td><img height=165 src="images/xc_3.jpg" 
                  width=217></td>
        </tr>
        </tbody> 
      </table>
    </td>
    <td width="551" valign="top" bgcolor="#FFFFFF" background="images/xc_4_bj.jpg"> 
      <%
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 = 9
rs.cachesize = 9
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<9 and NOT rs.EOF
Response.Write"<tr align='center'>"
Response.Write"<td width='33%'>"
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")&"' target='_blank'><img src='"&rs("minipic")&"' border='0' width=141 height=141></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"' target='_blank'>"&rs("name")&"</a> | 察看:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"<td width='33%'>"
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")&"' target='_blank'><img src='"&rs("minipic")&"' border='0' width=141 height=141></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"' target='_blank'>"&rs("name")&"</a> | 察看:"&rs("ck")&"</td>"
irecordsshown = irecordsshown +1
rs.movenext 
end if

Response.Write"<td width='33%'>"
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")&"' target='_blank'><img src='"&rs("minipic")&"' border='0' width=141 height=141></a></td></tbody></table><br><a href='display.asp?id="&rs("id")&"' target='_blank'>"&rs("name")&"</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='20'>每页显示 9 个文件 共有 "&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>
</table>
<table width="764" border="0" cellspacing="0" cellpadding="3" align="center" class="xzy" height="25">
  <tr> 
  <td colspan="2" bgcolor="<%=titlecolor%>" align="center"><%=cy%></td>
 </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -