📄 adminedit.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="95%" align="center" border="1" cellspacing="0" cellpadding="4" class=lanyubk style="border-collapse: collapse">
<tr><td colspan="7" class=lanyuss>文章查找</td></tr>
<tr>
<td colspan="7" class=lanyuds><center>
<form name="searchsoft" method="POST" action="adminedit.asp">
查找文章: <input class=smallInput type="text" name="title" size="13"><input type="submit" name="submit">
</form></center></td></tr>
<%
if request("title")<>"" then
sql="select * from article where title like '%"&trim(request("title"))&"%' order by articleid desc"
else
sql="select * from article order by articleid desc"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<tr><td colspan='7' 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
%>
<tr><td colspan="7" class=lanyuqs></td></tr>
<tr><td colspan="7" class=lanyuss></td></tr>
<%
do while not rs.eof and mp>0:k=k+1
%>
<tr class=lanyuds><td><%=(page-1)*18+i+1%></td><td><%=rs("writer")%></td><td><%=rs("title")%></td><td align='center' width=30><a href="editarticle.asp?id=<%=rs("articleid")%>&classid=<%=rs("classid")%>&Nclassid=<%=rs("Nclassid")%>&bigid=<%=rs("bigclassid")%>">编辑</a></td><td align='center' width=30><a href='javascript:suredo("delarticle.asp?id=<%=rs("articleid")%>","确定删除?")'>删除</a></td><td width=70>人气<%=rs("hits")%></td><td width=60><a href=adminping.asp?id=<%=rs("articleid")%>>评论<%=rs("ping")%></a></td></tr>
<%
i=i+1
mp=mp-1
rs.movenext
loop
%>
<tr><td align="center" colspan="7" class=lanyuqs>
<%
if page>rs.pagecount then Response.redirect("adminedit.asp?page="&rs.pagecount)
if page>1 then
response.Write("<a href='adminedit.asp?page=1'>首页</a>")
response.Write(" <a href='adminedit.asp?page="&page-1&"'>上一页</a> ")
end if
if page<rs.pagecount then
response.Write("<a href='adminedit.asp?page="&page+1&"'>下一页</a>")
response.Write(" <a href='adminedit.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 + -