管理页
function popwin2(id,path)
{ window.open("openarticle.asp?id="+id+"&ppath="+path,"","height=500,width=600,resizable=yes,scrollbars=yes,status=yes,toolbar=yes,menubar=yes,location=yes");
}
body { background:#799AE1; margin:0px; font:9pt 宋体; }
table { border:0px; }
td { font:normal 12px 宋体; }
img { vertical-align:bottom; border:0px; }
a { font:normal 12px 宋体; color:#000000; text-decoration:none; }
a:hover { color:#00000;text-decoration:underline; }
.sec_menu { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title { }
.menu_title span { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2 { }
.menu_title2 span { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
dim rs
MaxPerPage=20
dim totalPut
dim CurrentPage
dim TotalPages
dim i,j
dim typename
typename=""
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
dim sql
dim rstype
dim typesql
dim typeid,typename1
if not isEmpty(Replace(request("typeid"), "'", "''")) then
typeid=Replace(request("typeid"), "'", "''")
else
typeid=0
end if
%>
sql="select articleid,title,dateandtime,review from learning order by dateandtime desc"
else
sql="select articleid,title,dateandtime,review from learning where title like '%"&request("name23")&"%' order by dateandtime desc"
end if
Set rs= Server.CreateObject("ADODB.Recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "还 没 有 任 何 文 章！"
else
totalPut=rs.recordcount
totalPut=rs.recordcount
if currentpage currentpage=1
end if
if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if
if currentPage=1 then
showpage totalput,MaxPerPage,"managebbs.asp"
showContent
showpage totalput,MaxPerPage,"managebbs.asp"
else
if (currentPage-1)*MaxPerPage rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showpage totalput,MaxPerPage,"managebbs.asp"
showContent
showpage totalput,MaxPerPage,"managebbs.asp"
else
currentPage=1
showpage totalput,MaxPerPage,"managebbs.asp"
showContent
showpage totalput,MaxPerPage,"managebbs.asp"
end if
end if
end if
sub showContent
dim i
i=0
%>
按电影名查询
只显示有评论的电影
ID号
电影名称
修改
删除
·
相关评论
修改
删除
if i>=20 then exit do
rs.movenext
loop
%>
end sub
function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
n= totalnumber \ maxperpage
else
n= totalnumber \ maxperpage+1
end if
%>
共有部 当前:第页/共页
首页 上一页
首页
上一页
end if
if n-currentpage %>
下一页 尾页
下一页
尾页
第页
end function
%>
sub gotopage
end sub
%>
set rs=nothing
conn.close
set conn=nothing %>
