📄 adminping.asp
字号:
<%
if session("admin")="" then
response.redirect "admin.asp"
else
if session("flag")>2 then
response.write "<br><p align=center>您没有操作的权限</p>"
response.end
end if
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<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>
<!--#include file="conn.asp"-->
<body>
<table align="center" width="97%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr><td colspan="8" class=lanyuss>评论管理</td></tr>
<%
Function SafeRequest(ParaName,ParaType)
'--- 传入参数 ---
'ParaName:参数名称-字符型
'ParaType:参数类型-数字型(1表示以上参数是数字，0表示以上参数为字符)
Dim ParaValue
ParaValue=Request(ParaName)
If ParaType=1 then
If not isNumeric(ParaValue) then
Response.write "参数" & ParaName & "必须为数字型！"
Response.end
End if
Else
ParaValue=replace(ParaValue,"'","''")
End if
SafeRequest=ParaValue
End function
dim rs
set rs = server.createobject("adodb.recordset")
if request("id")="" then
sql="select * from ping order by id desc"
else
sql="select * from ping where articleid='"&Saferequest("id",0)&"' order by id desc"
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<tr><td colspan='8' 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><%=(page-1)*18+i+1%></td><td><%=rs("title")%></td><td><%=rs("text")%></td><td><%=rs("writer")%></td><td><%=rs("phone")%></td><td><%=rs("date")%></td><td><a href="#" onClick="window.open('viweart.asp?id=<%=rs("articleid")%>','','width=380,height=400');">所在文章</td><td><a href='javascript:suredo("dellping.asp?id=<%=rs("id")%>","确定删除?")'>删除</a></td></tr>
<%
i=i+1
mp=mp-1
rs.movenext
loop
%>
<tr><td align="center" colspan="8" class=lanyuqs>
<%
if page>rs.pagecount then Response.redirect("adminping.asp?page="&rs.pagecount)
if page>1 then
response.Write("<a href='adminping.asp?page=1'>首页</a>")
response.Write(" <a href='adminping.asp?page="&page-1&"'>上一页</a> ")
end if
if page<rs.pagecount then
response.Write("<a href='adminping.asp?page="&page+1&"'>下一页</a>")
response.Write(" <a href='adminping.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>
</body>
</html> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -