📄 adminguanggao.asp
字号:
<%
if session("admin")="" then
response.redirect "admin.asp"
else
if session("flag")>1 then
response.write "<br><p align=center>您没有操作的权限</p>"
response.end
end if
end if
%>
<!-- #include file="conn.asp" -->
<html>
<head>
<title> </title>
<link rel="stylesheet" type="text/css" href="inc/admin.css">
<script language="JavaScript">
<!--
function suredo(src,q)
{
var ret;
ret = confirm(q);
if(ret!=false)window.location=src;
}
//-->
</script>
</head>
<body>
<table align="center" width="95%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr class=lanyuss>
<td colspan="5">广告管理</td></tr>
<tr class=lanyuds><td>标题</td><td>说明</td><td width="30">编辑</td><td width="30">删除</td><td>点击</td></tr>
<%
function encodestr(str)
dim i
str=trim(str)
if IsNull(str) then exit function
str=replace(str,"<","<")
str=replace(str,">",">")
str=replace(str,"'","""")
encodestr=replace(str," "," ")
end function
Set rs = Server.CreateObject("ADODB.Recordset")
sql="Select * from guanggao order by id desc"
rs.open sql,conn,1,1
if rs.eof then
response.write("<tr class=lanyuds><td colspan=""5"" align=center>没有广告</td></tr>")
else
Page=Int(Abs(Request("page")))
IF not IsNumeric(Request("page")) Or IsEmpty(Request("page")) Then page=1
rs.pagesize = 18 '每页显示记录数
total = rs.RecordCount
mp = rs.pagesize
rs.absolutepage = page
i=0:k=0
do while not rs.eof and mp>0:k=k+1
%>
<tr class=lanyuds><td width="100"><%=encodestr(rs("title"))%></td><td><%=encodestr(rs("text"))%></td><td width="30"><a href='editguanggao.asp?id=<%=rs("id")%>&classid=<%=rs("classid")%>'>编辑</a></td><td width="30"><a href='javascript:suredo("delguanggao.asp?id=<%=rs("id")%>","确定删除?")'>删除</a></td><td><%=rs("hit")%></td></tr>
<%
mp=mp-1
rs.movenext
loop
%>
<tr class=lanyuqs><td colspan="5" align="center">
<%
if page>rs.pagecount then Response.redirect("adminguanggao.asp?page="&rs.pagecount)
if page>1 then
response.Write("<a href='adminguanggao.asp?page=1'>首页</a>")
response.Write(" <a href='adminguanggao.asp?page="&page-1&"'>上一页</a> ")
end if
if page<rs.pagecount then
response.Write("<a href='adminguanggao.asp?page="&page+1&"'>下一页</a>")
response.Write(" <a href='adminguanggao.asp?page="&rs.pagecount&"'>尾页</a>")
end if
response.Write(" 共"&total&"个广告 ")
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</td></tr>
</table>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -