📄 admin_ping.asp
字号:
<!--#include file="include/conn.asp"-->
<!--#include file="inc/format.asp"-->
<!--#include file="inc/error.asp"-->
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
<%
c_id=request.QueryString("c_id")
sql2="select * from commodity where c_id="&c_id
set rs2=server.createobject("adodb.recordset")
rs2.open sql2,conn,1,1
if rs2("u_id")<>session("u_id") then
founderr=true
errmsg=errmsg+"<br>"+"<li>商品不属于用户!非法浏览内容!"
call diserror()
response.end
end if
rs2.close
set rs2=nothing
sql="select * from pinglun where c_id="&c_id
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<table width="60%" border="0" align="center" cellpadding="4" cellspacing="1" bordercolor="#C0C0C0" bgcolor="#000000" style="border-collapse: collapse">
<tr align="center">
<td colspan="3" bgcolor="#E8E8E8">商品评论管理</font></td>
</tr>
<tr bgcolor="#E8E8E8" align="center">
<td class="chinese" width="10%" bgcolor="#FFFFFF">编号</td>
<td class="chinese" width="60%" bgcolor="#FFFFFF">内容&评论时间</td>
<td class="chinese" width="20%" bgcolor="#FFFFFF">操作</td>
</tr>
<%if rs.eof and rs.bof then%>
<tr align="center">
<td colspan="4" bgcolor="#FFFFFF" class="chinese" style="color: #FF0000">当前没有商品的评论!</td>
</tr>
<% else
rs.movefirst
newsperpage=15
rs.pagesize=newsperpage
if trim(request("page"))<>"" then
currentpage=clng(request("page"))
if currentpage>rs.pagecount then
currentpage=rs.pagecount
end if
else
currentpage=1
end if
totalnews=rs.recordcount
if currentpage<>1 then
if (currentpage-1)*newsperpage<totalnews then
rs.move(currentpage-1)*newsperpage
dim bookmark
bookmark=rs.bookmark
end if
end if
if (totalnews mod newsperpage)=0 then
totalpages=totalnews\newsperpage
else
totalpages=totalnews\newsperpage+1
end if
i=0
do while not rs.eof and i<newsperpage%>
<tr>
<td bgcolor="#FFFFFF" class="chinese" align="center"><%=rs("p_id")%> </td>
<td bgcolor="#FFFFFF" class="chinese"><%=left(rs("p_content"),30)&"..."%> <span class="date"><%=rs("p_time")%></span> </td>
<td bgcolor="#FFFFFF" class="chinese" align="center"><a href="admin_pingdel.asp?c_id=<%=rs("c_id")%>&p_id=<%=rs("p_id")%>">删除</a> <a href="showping.asp?p_id=<%=rs("p_id")%>" target="_blank">浏览</a></td>
</tr>
<%i=i+1
rs.movenext
loop
end if%>
</table>
<table align="center" width="60%" border="0" cellspacing="0" cellpadding="0">
<form name="form2" method="post" action="admin_ping.asp">
<tr>
<td class="chinese" align="right"><%=currentpage%> /<%=totalpages%>页,<%=totalnews%>条记录/<%=newsperpage%>篇每页..
<%
i=1
showye=totalpages
if showye>10 then
showye=10
end if
for i=1 to showye
if i=currentpage then
%>
<%=i%>
<%else%>
<a href="admin_ping.asp?page=<%=i%>"><%=i%></a>
<%end if
next
if totalpages>currentpage then
if request("page")="" then
page=1
else
page=request("page")+1
end if%>
<a href="admin_ping.asp?page=<%=page%>" title="下一页">>></a>
<%end if%>
<input type="text" name="page" class="textarea" size="4">
<input type="submit" name="Submit" value="Go" class="button"></td>
</tr>
</form>
</table>
<%
rs.close
set rs=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -