📄 car.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="nimda/config.asp"-->
<!--#include file="edulcni/conn.asp"-->
<!--#include file="edulcni/chk.asp"--> <%
dim id,UserName,action
action=request.QueryString("action")
UserName=trim(request.cookies(cookieName)("UserName"))
id=request.QueryString("id")
set rs=server.CreateObject("adodb.recordset")
select case action
case "del"
conn.execute "delete from orders where actionid="&request.QueryString("actionid")
response.redirect "car.asp"
case "add"
rs.open "select id,UserName from orders where UserName='"&UserName&"' and id="&id&" and state=6",conn,1,1
if not rs.eof and not rs.bof then
call MsgBox("对不起,此商品已存在于您的购物车中,不可以重复添加!","Close","None")
response.end
rs.close
else
rs.close
rs.open "select id,UserName,state,paid from orders",conn,1,3
rs.addnew
rs("id")=id
rs("UserName")=UserName
rs("state")=6
rs("paid")=0
rs.update
rs.close
set rs=nothing
call MsgBox("商品成功添加到你的购物篮!","Close","None")
response.end
end if
end select
rs.open "select orders.actionid,orders.id,product.name,product.price1,product.price2,product.discount from product inner join orders on product.id=orders.id where orders.UserName='"&request.cookies(cookieName)("UserName")&"' and orders.state=6",conn,1,1 %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>E书部落—网上书城</title>
<link href="style.css" rel="stylesheet" type="text/css"></head>
<body>
<!--#include file="head.htm"-->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="218" align="left" valign="top" style="border-left: 1px dotted #65A8CF; border-top: 1px dotted #65A8CF; border-bottom: 1px dotted #65A8CF"><!--#include file="uleft.asp"--> <br></td><td width="560" align="left" valign="top" style="border-left: 1px dotted #65A8CF; border-right:1px dotted #65A8CF; border-top: 1px dotted #65A8CF; border-bottom: 1px dotted #65A8CF"><br> <table cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="18"><img src="images/w.gif"></td>
<td style="color:#415373">购物车</td>
</tr>
</table>
<br> <form name="form1" method="post" action="cart.asp">
<table width="96%" border=0 align=center cellpadding=2 cellspacing=2>
<tr height=20><td width=7% align=center>选 择</td>
<td width="45%" align=center>商品名称</td>
<td width="14%" align=center>市场价</td>
<td width="13%" align=center>会员价</td>
<td width="12%" align=center>折扣</td>
<td width="9%" align=center>删除</td></tr>
<%
do while not rs.eof%>
<tr bgcolor=#ffffff>
<td align="center" bgcolor=#FFFFFF><input name=id type=checkbox checked value="<%=rs("id")%>"></td>
<td STYLE="PADDING-LEFT: 5px" align=center><a href=vpro.asp?id=<%=rs("id")%> target=_blank><%=rs("name")%></a></td>
<td align=center><%=rs("price1")%>元</td>
<td align=center><font color="#FF6600"><%=rs("price2")%>元</font></td>
<td align=center><%=(rs("discount")*100)%>%</td>
<td align="center">
<a href="car.asp?action=del&actionid=<%=rs("actionid")%>"><img src=images/trash.gif width=15 height=17 border=0></a></a></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing%>
<tr align="center"><td height=36 colspan=6 bgcolor=#FFFFFF><input type=submit name=Submit value=去下订单 onclick="location='cart_t.asp'">
<%
if action<>"addtocart" then%>
<input type=button name=Submit2 value=继续采购 onclick=javascript:window.close()>
<%
end if%>
</td>
</tr></table>
</form> <p> </p></td>
</tr>
</table>
<!--#include file="foot.htm"-->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -