shoppingbag.asp

21世纪人才www.51zy.net 网站源码

<div id="shoppingbag"><h1>我的购物车</h1>
<%if request.cookies("godbook")("username")<>"" then 
set rs=server.CreateObject("adodb.recordset")
rs.open "select count(*) as rec_count from shop_action where username='"&request.cookies("godbook")("username")&"' and zhuangtai=7",conn,1,1
rec_count=rs("rec_count")
rs.close
rs.open "select sum(zonger) as zongji from shop_action where username='"&request.cookies("godbook")("username")&"' and zhuangtai=7",conn,1,1%>
<ul><li>您的购物车有<span class="new"><%=rec_count%></span>件商品</li> 
<li>总金额：<span class="new"><%=rs("zongji")%></span>元</li>
<li><a href="gouwu.asp?action=show&amp;lx=1">查看购物车/结帐&gt;&gt;</a></li>
<li><a href="user.asp?action=shoucang">我的收藏&gt;&gt;</a></li></ul>
<%rs.close
set rs=nothing
else%>
<ul><li>您的购物车有<span class="new">0</span>件商品</li><li>总金额：<span class="new">0</span>元</li></ul>
<%end if%>
</div>
<div class="clear-both">&nbsp;</div>