📄 list.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("advip_admin")="" then
response.Redirect "login.asp"
end if
vip=session("advip_admin")
dim sql,rs
sql="select * from data where fabuid='"&vip&"' order by adid desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>现有广告列表</title>
<style type="text/css">
<!--
td { font-size: 12px; line-height: 17px }
body { font-size: 12px; line-height: 17px }
p { margin-top: 1px; margin-bottom: 1px }
a:link { text-decoration: none; color: black }
a:visited { text-decoration: none; color: black }
a:active { text-decoration: none }
a:hover { text-decoration: underline; color: red }
-->
</style>
</head>
<body background="../images/background.gif">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<div align="center">
<center>
<table border="1" width="700" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="0" bgcolor="#F3F3F3">
<tr>
<td width="46" bgcolor="#E8E8E8">
<p align="center">编号</p>
</td>
<td width="158" bgcolor="#E8E8E8"> 广告标题</td>
<td width="83" bgcolor="#E8E8E8" align="center">广告类别</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">发布日期</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">升效日期</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">截止日期</td>
<td width="83" bgcolor="#E8E8E8">
<p align="center">发布状态</td>
<td width="65" bgcolor="#E8E8E8">
<p align="center">管理操作</p>
</td>
</tr>
<%
if rs.eof or rs.bof then
response.write"<tr><td colspan='8'><p align='center'><a href='add.asp'><font color='red'>暂无广告，立即发布</font></a></p></td></tr></table>"
response.end
else
const maxperpage=100
dim currentpage
rs.pagesize=maxperpage
currentpage=request.querystring("pageid")
if isnumeric(currentpage)=false then
response.write "<script>alert('参数错误，关闭窗口！');window.close();</script>"
response.end
end if
if currentpage="" then
currentpage=1
elseif currentpage<1 then
currentpage=1
else
currentpage=clng(currentpage)
if currentpage > rs.pagecount then
currentpage=rs.pagecount
end if
end if
dim totalput,n
totalput=rs.recordcount
if totalput mod maxperpage=0 then
n=totalput\maxperpage
else
n=totalput\maxperpage+1
end if
if n=0 then
n=1
end if
rs.move(currentpage-1)*maxperpage
i=0
do while i< maxperpage and not rs.eof
%>
<tr>
<td width="46">
<p align="center"><%=i+currentpage*maxperpage-maxperpage+1%></td>
<td width="158"> <%=rs("title")%></td>
<td width="83" align="center"><%=rs("type")%></td>
<td width="83">
<p align="center"><%=rs("date")%></td>
<td width="83">
<p align="center"><%=rs("time")%></td>
</center>
<td width="83">
<p align="center"><%=rs("stop")%></td>
<td width="83">
<p align="center"><% If rs("mark")="yes" Then %><font color="#008000">已经发布</font><% Else %><font color="#FF0000">尚未发布</font><% End If %>
</td>
<center>
<td width="65">
<p align="center"><a href="editad.asp?id=<%=rs("adid")%>"><font color="green">编辑</font></a> <a href="delad.asp?id=<%=rs("adid")%>" onClick="return confirm('确定要删除吗？\n\n该操作不可恢复！')"><font color="red">删除</font></a></p>
</td>
</tr>
<%
i=i+1
rs.movenext
loop
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%> </table>
</center>
</div>
</td>
</tr>
</table>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td height="30"><p align="center">页数：<%=currentpage%>/<% =n%>
<%k=currentpage
if k<>1 then%>
<a href="list.asp?pageid=1">首页</a>
<a href="list.asp?pageid=<%=k-1%>">上一页</a>
<%else%>
首页 上一页
<%end if%>
<%if k<>n then%>
<a href="list.asp?pageid=<%=k+1%>">下一页</a>
<a href="list.asp?pageid=<%=n%>">尾页</a>
<%else%>
下一页 尾页
<%end if%>
共有 <%=totalput%> 条广告</p>
</td>
</tr>
</table>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -