📄 shixiaoad.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("ad_admin")="" then
response.redirect "ad_login.asp"
end if
dim sql,rs
sql="select * from data where stop < date() 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 height="30">
<p align="center"><font style="font-size:14px"><a href="addad.asp">发布新广告</a> <a href="list.asp">全部广告</a> <a href="fufeiad.asp">付费广告</a> <a href="gudingad.asp">固顶广告</a> <a href="shixiaoad.asp">过期广告</a> <a href="pass.asp">修改管理密码</a> <a href="quit.asp"><font color="#FF0000">退出管理</font></a></font></p>
</td>
</tr>
<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'><font color='red'>暂无失效广告！</font></p></td></tr></table>"
rs.close
set rs=nothing
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>
<td width="83">
<p align="center"><%=rs("stop")%></td>
<td width="83"><p align="center"><font color="#FF0000">过期失效</font></td>
<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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -