📄 type.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"><%@ ENABLESESSIONSTATE = FALSE %>
<!--#include file="mdb/conn.asp" -->
<!--#include file="config.asp" -->
<html>
<head>
<%
dim typename,classid,classname
if IsNumeric(Request.QueryString("typeid"))=False then
Response.Redirect"info.asp?info=错误的参数"
else
typeid=cint(Request.QueryString("typeid"))
end if
set temprs=conn.execute("select name from type where id="&typeid)
if temprs.eof or temprs.bof then
response.write "<title>该分类并不存在！</title>您查看的分类并不存在！"%>
<br><a href='http://www.aishop.com.cn/aishop/1/' target='_blank'><img src='http://www.aishop.com.cn/aishop/1/images/ad.gif' border='0' class='bk'></a><br>
<br><script type="text/javascript"><!--
google_ad_client = "pub-0322715741508628";
google_ad_width = 728;
google_ad_height = 90;
google_ad_format = "728x90_as";
google_ad_type = "text_image";
google_ad_channel = "";
google_color_border = "FFFFFF";
google_color_bg = "FFFFFF";
google_color_link = "0000FF";
google_color_text = "000000";
google_color_url = "008000";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><br><script type="text/javascript"><!--
google_ad_client = "pub-0322715741508628";
google_ad_output = "textlink";
google_ad_format = "ref_text";
google_cpa_choice = "CAAQhaq1_wEaCAInDozL339PKJ2R4YcB";
google_ad_channel = "";
//--></script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<%
response.end
end if
typename=temprs(0)
set temprs=nothing
%>
<title><%=title%> >> <%=desktoptitle%> >> <%=classname%> >> <%=typename%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="INDEX.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--#include file="top.asp" -->
<table width="100%" border="0" cellspacing="0" cellpadding="8">
<tr>
<td align="center" valign="top" bgcolor="<%=titlecolor%>">
<%
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 * FROM zhuanti where pl="&typeid&" ORDER BY id DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.pagesize = 12
rs.cachesize = 12
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 "<p align='center'>没有任何相册专题</p>"
else
rs.absolutepage = ipagecurrent
irecordsshown = 0
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='3' class='x'><tr><td>最新更新情况，截止到 "&now()&" 共有 <b>"&rs.RecordCount&" </b> 个相册。</td></tr></table>"
do while irecordsshown<9 and NOT rs.EOF
Response.Write"<table width='100%' border='0' cellspacing='0' cellpadding='5'>"
Response.Write"<tr align='center'>"
for i=1 to 4
Response.Write"<td width='25%'>"
if not rs.eof then
sqlp="select top 1 * from desktop where zhuanti="&rs("id")&" order by id asc"
Set rsp=Server.CreateObject("ADODB.RecordSet")
rsp.open sqlp,conn,1,1
if rsp.eof or rsp.bof then
'if rsp("surl")=null then
photourl="image/nopic1.jpg"
else
photourl=rsp("surl")
end if
rsp.close
set rsp=nothing
sqlpp="select id from desktop where zhuanti="&rs("id")&" order by id asc"
Set rspp=Server.CreateObject("ADODB.RecordSet")
rspp.open sqlpp,conn,1,1
if rspp.eof or rspp.bof then
sm=0
else
sm=rspp.RecordCount
end if
rspp.close
set rspp=nothing
dim sqlp
Set rsp=Server.CreateObject("ADODB.RecordSet")
sqlp="select pass from zhuanti where id="&rs("id")&""
'response.write sqlp
'response.end
rsp.open sqlp,conn,1,1
p=rsp("pass")
if p<>"" then
photourl="images/nopass.jpg"
end if
rsp.close
set rsp=nothing
Response.Write"<table align=center bgcolor='#b2b2b2' border=0 cellpadding=1 cellspacing=0 class='bk1'><tr><td><table align=center bgcolor='#ffffff' border=0 cellpadding=5 cellspacing=0 class='bk1'><tbody><td><a href='zhuanti.asp?typeid="&rs("id")&"' target='_blank'><img src='"&photourl&"' border='0' class='bk'></a></td></tbody></table></tr></td></tbody></table><br><a href='zhuanti.asp?typeid="&rs("id")&"' target='_blank'>"&rs("name")&"</a>|"&sm&"张</td></td>"
irecordsshown = irecordsshown +1
rs.movenext
end if
next
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' ><tr><td height='20'>每页显示 12个相册 共有 "&ipagecount&" 页 当前为第 "&ipagecurrent&" 页 "
if ipagecurrent=1 then
Response.Write"首页 | "
else
Response.Write"<a href='type.asp?typeid="&typeid&"&page=1'>首页</a> | "
end if
if ipagecurrent=1 then
Response.Write"上一页 | "
else
Response.Write"<a href='type.asp?typeid="&typeid&"&page="&ipagecurrent-1&"'>上一页</a> | "
end if
if ipagecount>ipagecurrent then
Response.Write"<a href='type.asp?typeid="&typeid&"&page="&ipagecurrent+1&"'>下一页</a> "
else
Response.Write"下一页"
end if
if ipagecount>ipagecurrent then
Response.Write"| <a href='type.asp?typeid="&typeid&"&page="&ipagecount&"'>末页</a> "
else
Response.Write"| 末页 "
end if
Response.Write"</td></tr></table>"
%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--#include file="foot.asp" -->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -