📄 list.asp
字号:
</tr>
<%
rs.close
set rs=nothing
%>
<tr>
<td height="37" colspan="2"><img src="images/view3.gif" width="770" height="55"></td>
</tr>
<tr>
<td width="59%">
<table width="456" height="142" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="496" height="126"> <%
set rs=server.createobject("adodb.recordset")
rs.open "select * from sh_review where bookid="&request("id")&" and shenhe=1 order by pinglundate desc",conn,1,1
j=rs.recordcount
plcount=rs.recordcount
if j>3then j=3
for i=1 to j
%>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td width="5%" align="right" height="22"><img src="images/image002.gif" width="15" height="15"></td>
<td colspan="2" height="22"><b>主题：</b> <%=trim(rs("pingluntitle"))%></td>
<td width="36%" height="22"><img src="images/pingji/<%=rs("pingji")%>.gif" width="79" height="14"></td>
</tr>
<tr>
<td width="5%"> </td>
<td colspan="2"><b>作者：</b><%=trim(rs("pinglunname"))%> (<%=trim(rs("pinglundate"))%>)</td>
<td width="36%"><%=trim(rs("ip"))%></td>
</tr>
<tr>
<td width="5%"> </td>
<td colspan="3"><strong>内容：</strong> <%if len(rs("pingluncontent"))>360 then
response.write left(rs("pingluncontent"),20)&"... <a href=""javascript:;"" onClick=""javascript:window.open('pinglunll.asp?id="&rs("pinglunid")&"','pinglun','width=300,height=400,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"" title="&trim(rs("pingluntitle"))&">[详细内容]</a>"
else response.write rs("pingluncontent")
end if%> </td>
</tr>
<%if trim(rs("huifu"))<>"" then%>
<tr>
<td width="5%"></td>
<td colspan="3"><b><font color="#0099CC">管理员回复：</font></b><%=rs("huifu")%> </td>
</tr>
<%end if%>
<tr>
<td height=1 colspan=4 background="images/bj_x.gif"></td>
</tr>
</table><%
rs.movenext
next
if plcount>0 then
%></td>
</tr>
<tr>
<td><div align="right"><a href=list_review.asp?id=<%=request("id")%>> 浏览该商品的全部评论</a> <font color="#999999">共<%=plcount%>条 <%end if%></font></div></td>
</tr>
</table> </td>
<td width="41%" valign="top">
<%dim bookid,action
bookid=request.QueryString("id")
action=request.QueryString("action")
if action="save" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from sh_review",conn,1,3
rs.addnew
rs("bookid")=bookid
rs("pingji")=request("pingji")
rs("pinglunname")=HTMLEncode2(trim(request("pinglunname")))
rs("pingluntitle")=HTMLEncode2(trim(request("pingluntitle")))
rs("pingluncontent")=HTMLEncode2(trim(request("pingluncontent")))
rs("ip")=Request.servervariables("REMOTE_ADDR")
rs("pinglundate")=now()
rs("shenhe")=0
rs.update
rs.close
set rs=nothing
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from sh_chanpin where bookid="&bookid,conn,1,3
rs("pingji")=rs("pingji")+1
rs("pingjizong")=rs("pingjizong")+request("pingji")
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript>alert('成功提交，请等待管理员审核与回复！');</script>"
response.End
end if
%>
<table width="100%" border="0" cellspacing="1" cellpadding="2" >
<tr>
<td><div align="center"><font color="#006633">发表您的评论：</font></div></td>
</tr><tr>
<td height="1" colspan="2" background="images/bj_x.gif" ></td>
</tr>
<tr>
<form name="pinglunform" method="post" action="list.asp?action=save&id=<%=bookid%>">
<td>
<table width="100%" border="0" cellpadding="2" cellspacing="1">
<tr>
<td width="23%">
<div align="right">姓名：</div></td>
<td width="77%">
<input name="pinglunname" style="BACKGROUND-COLOR: #ffffff"; type="text" id="pinglunname5" size="12">
</td>
</tr>
<tr>
<td width="23%">
<div align="right">评级：</div></td>
<td width="77%">
<input type="radio" name="pingji" value="5" checked>
<img src="images/pingji/5.gif">
<input type="radio" name="pingji" value="4">
<img src="images/pingji/4.gif"><br>
<input type="radio" name="pingji" value="3">
<img src="images/pingji/3.gif">
<input type="radio" name="pingji" value="2">
<img src="images/pingji/2.gif"><br>
<input type="radio" name="pingji" value="1">
<img src="images/pingji/1.gif"> </td>
</tr>
<tr>
<td width="23%">
<div align="right">标题：</div></td>
<td width="77%">
<input name="pingluntitle" style="BACKGROUND-COLOR: #ffffff"; type="text" id="pingluntitle" size="26">
</td>
</tr>
<tr>
<td valign="top">
<div align="right">正文：</div></td>
<td>
<textarea name="pingluncontent" cols="26" rows="5" id="pingluncontent" style="BACKGROUND-COLOR:#ffffff";></textarea>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="image" border="0" name="submit" src="images/bc.gif" width="54" height="18" onClick="return check();">
</div></td>
</tr>
</table></td>
</form>
</tr>
</table><%function HTMLEncode2(fString)
'fString = Replace(fString, CHR(13), "")
'fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
'fString = Replace(fString, CHR(10), "<BR>")
fString = replace(fString, ">", ">")
fString = replace(fString, "<", "<")
fString = Replace(fString, CHR(32), "<I></I> ")
fString = Replace(fString, CHR(9), " ")
fString = Replace(fString, CHR(34), """)
fString = Replace(fString, CHR(39), "'")
fString = Replace(fString, CHR(13), "")
fString = Replace(fString, CHR(10) & CHR(10), "</P><P> ")
fString = Replace(fString, CHR(10), "<BR> ")
HTMLEncode2 = fString
end function%>
<script LANGUAGE="javascript">
<!--
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function check()
{
if(checkspace(document.pinglunform.pinglunname.value)) {
document.pinglunform.pinglunname.focus();
alert("请填写您的姓名！");
return false;
}
if(checkspace(document.pinglunform.pingluntitle.value)) {
document.pinglunform.pingluntitle.focus();
alert("请填写评论标题！");
return false;
}
if(checkspace(document.pinglunform.pingluncontent.value)) {
document.pinglunform.pingluncontent.focus();
alert("请填写评论正文！");
return false;
}
}
//-->
</script></td>
</tr>
<tr>
<td height="31" colspan="2" align="center" valign="middle"><div align="right"><img src="images/tonglei.gif" width="770" height="56"></div></td>
</tr>
<tr>
<td height="1" colspan="2" background="images/bj_x.gif" ></td>
<tr>
<td height="38" colspan="2" align="center"><%
sql="select * from sh_chanpin where anclassid = (select anclassid from sh_chanpin where bookid = "&request("id")&") order by liulancount desc "
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<!--#include file="tui.asp"--></td>
</tr>
</table></td>
</tr>
</table>
<tr><td> </td></tr>
</table>
</TABLE>
<!--#include file="webfoot.asp"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -