product_p.asp
来自「非常有商业价值的软件」· ASP 代码 · 共 105 行
ASP
105 行
<!--#include file="chk.asp"-->
<!--#include file="db_conn.asp"-->
<!--#include file="../my_lib/my_request.asp"-->
<!--#include file="../my_lib/pages.asp"-->
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="style.css" rel=stylesheet type=text/css>
<title>商品留言评论管理</title>
</head>
<body>
<div align="center">
<table border="1" width="760" id="table1" cellspacing="1" style="border-collapse: collapse" bordercolor="#EFEFEF">
<tr>
<td colspan="3" height="18">
<p align="center">商品评论管理</td>
</tr>
<% sql="select * from product_leave order by addtime desc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
if (rs.eof and rs.bof) then
response.write "<tr>"
response.write "<td width=500 colspan=4><font color=#FF0000>目前还没有任何留言</font></td>"
response.write "</tr>"
else
rs.PageSize =20 '每页记录条数
iCount=rs.RecordCount '记录总数
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
end if
ii=1
while not rs.eof and ii<=rs.pagesize
id=rs("id")
username=rs("username")
xingxing=rs("xingxing")
neirong=rs("neirong")
pid=rs("pid")
ip=rs("ip")
addtime=rs("addtime")
sqls="select p_name from yqj_product where id="&pid
set rsp=conn.execute (sqls)
p_name=rsp("p_name")
rsp.close
set rsp=nothing
%>
<tr>
<td width="33" bgcolor="#D4D4D4" height="18" rowspan="2">
<p align="center"><font color="#0000FF"><%=(page-1)*19+ii%></font></td>
<td width="675" height="18">针对商品:<a href=edit_product.asp?id=<%=pid%>><%=p_name%></a> 网名:<%=username%> 评价星级:<%
for ai=1 to cint(xingxing)
response.write "<img border=0 src=../images/art1.gif>"
next
%> IP地址:<%=ip%> 留言时间:<%=addtime%></td>
<td width="37" height="18">
<p align="center"><a href="del_p.asp?id=<%=id%>&page=<%=page%>">
<font color="#0000FF">删除</font></a></td>
</tr>
<tr>
<td width="717" height="18" colspan="2"><font color="#FF0000">留言内容:</font><%=neirong%></td>
</tr>
<tr>
<td colspan="3"><hr color="#000080" size="1"></td>
</tr><%
rs.movenext
ii=ii+1
wend
%>
<tr>
<td colspan="3" height="18">
<p align="right"><%call PageControl(iCount,maxpage,page,"border=0 align=left","<p align=left>")%></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?