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>&nbsp;&nbsp;网名:<%=username%>&nbsp;&nbsp;评价星级:<%
			for ai=1 to cint(xingxing)
		response.write "<img border=0 src=../images/art1.gif>"
		next
          %>&nbsp;&nbsp;IP地址:<%=ip%>&nbsp;&nbsp;留言时间:<%=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 + -
显示快捷键?