📄 shoucang.asp

📁 if you want it,call me.
💻 ASP
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<title>收藏列表</title>
<link href="css.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"></head>
<body leftmargin="0" topmargin="0">
<% if session("user")="" then
response.write "<script language=javascript>alert('请您先注册或者登陆！');window.location.reload('javascript:window.close()')</script>"
response.end
end if

if request("cid")<>"" then
dim spname
set rs=server.createobject("adodb.recordset")
sql="select * from goods where id="&request("cid")
rs.open sql,conn,1,1
if rs.eof then
response.write"<br><br><div align=center>没有此商品存在</div>"
response.end
else
spname=rs("sp_name")
end if
rs.close

set rs1=server.createobject("adodb.recordset")
sql1="select * from shoucang where user_name='"&session("user")&"' and sp_name='"&spname&"'"
rs1.open sql1,conn,1,3
if not rs1.eof then
response.write "<script language=javascript>alert('您以前已收藏此物品！');window.location.reload('javascript:window.close()')</script>"
response.end
else
rs1.addnew
rs1("sp_id")=request("cid")
rs1("user_name")=session("user")
rs1("sp_name")=spname
rs1.update
end if
rs1.close
end if
%>
<table width="480" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr  class="tabbgcolorli"> 
    <td>　您已收藏的商品列表</td>
  </tr>
</table>
<br>
<table class="border3" width="480" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="40%"> <div align="center">商品名称&nbsp;</div></td>
    <td width="20%"> <div align="center">操作</div></td>
    <td width="20%"> <div align="center">操作</div></td>
  </tr>
  <%
set rs=server.createobject("adodb.recordset")
sql="select * from shoucang where user_name='"&session("user")&"' order by id desc"
rs.open sql,conn,1,1
if rs.eof then
response.write"<br><div align=center>您暂时没有已收藏的商品</div>"
response.end
else
do while not rs.eof
%>
  <tr> 
    <td><div align="center"><%=rs("sp_name")%></div></td>
    <td><div align="center"><a href="delshoucang.asp?id=<%=rs("id")%>">删除</a></div></td>
    <td><div align="center"><a href="addorder.asp?buyid=<%=rs("sp_id")%>">购买此商品</a></div></td>
  </tr>
  <%
	rs.movenext
	loop
	end if
	rs.close
	set rs=nothing
	%>
</table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -