📄 pic.asp
字号:
<%@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="img/dex.css" rel="stylesheet" type="text/css" />
<link href="img/dex2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<!--TOP-->
<!--#include file="top.asp"-->
<!--TOP END-->
<div id="box"><div id="boxleft">
<div id="pclass">
<ul><%
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from picclass"
RS.Open SQL, cn, 1,1,1
Do while not RS.EOF%>
<li><a href="pic.asp?class=<%=RS("class")%>"><%=RS("classname")%></a></li>
<% RS.movenext
Loop
set RS = nothing%>
</ul>
</div>
<!--新闻分类结束-->
<div id="wsearch">
<% call websearch() %>
</div>
<!--全站搜索结束-->
<div id="newstop">
<ul>
<%Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "Select top 10 * from pic order by click desc"
rs.Open SQL, cn, 1,1
do while not rs.eof
Response.Write "<li><a href='showpic.asp?id="&rs("id")&"'>"&left(rs("title"),13)&"...</a></li>"
rs.movenext
loop
rs.close
set rs=nothing%>
</ul>
</div>
<!--点击排行结束-->
</div>
<div id="depic">
<ul>
<%
if Request.QueryString("class")<>"" then
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from pic where pic<>'' and class="&request.QueryString("class")&" order by id DESC"
rs.Open SQL, cn, 1,1
do while not rs.eof
Response.Write "<li><a href='showpic.asp?id="&rs("id")&"'><img border='0' src='"&rs("pic")&"' width='142' height='200' alt='"&rs("title")&"---"&rs("user")&"'/></a></li>"
rs.movenext
loop
rs.close
set rs=nothing
else
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from pic where pic<>''order by id DESC"
rs.Open SQL, cn, 1,1
rs.PageSize=24
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
rs.AbsolutePage=page
for i=1 to rs.pagesize
if rs.EOF then exit for
Response.Write "<li><a href='showpic.asp?id="&rs("id")&"'><img border='0' src='"&rs("pic")&"' width='142' height='200' alt='"&rs("title")&"---"&rs("user")&"'/></a></li>"
rs.movenext
next%>
<br /><br />
<%if page=1 and not page=pagecount then%>
<div align="center">第<%=page%>页 <%for i=1 to pagecount%>
<a href="pic.asp?page=<%=i%>"><%=i%></a> <%next%><a href="pic.asp?page=<%=page+1%>">下一页</a> </div>
<%elseif page=pagecount and not page=1 then%>
<div align="center">第<%=page%>页 <%for i=1 to pagecount%>
<a href="pic.asp?page=<%=i%>"><%=i%></a> <%next%><a href="pic.asp?page=<%=page-1%>">上一页</a> </div>
<%elseif page<1 then%><div class="font" align="center"><font color=red>没有任何记录！</font></div>
<%elseif page>pagecount then%><div class="font" align="center"><font color=red>没有任何记录！</font></div>
<%elseif page=1 and page=pagecount then%>
<%else%>
<div align="center">第<%=page%>页 <%for i=1 to pagecount%>
<a href="pic.asp?page=<%=i%>"><%=i%></a> <%next%><a href="pic.asp?page=<%=page-1%>">上一页</a>
<a href="pic.asp?page=<%=page+1%>">下一页</a> </div>
<%end if
rs.close
set rs=nothing
end if%>
</ul>
</div>
</div>
<!-------------bottom ---------------------------------------->
<!--#include file="bottom.asp"-->
<!---------bottom end ---------------------------------------->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -