info_gouwuche.asp

网上购物系统:一个经过完善设计的经典网上购物系统

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="33">&nbsp;</td>
</tr>
<tr> 
<td> 
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" height="109">
<%
	if request.Cookies("shopxp")("username")<>"" then 
	set rs=server.CreateObject("adodb.recordset")
	rs.open "select count(*) as rec_count from shop_action where username='"&request.Cookies("shopxp")("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("shopxp")("username")&"' and zhuangtai=7",conn,1,1
	%>
<tr> 
<td height="2" align=cneter></td>
</tr>
<tr> 
<td height="20">　您的购物车有<font color=red><%=rec_count%></font>件商品 
</td>
</tr>
<tr> 
<td height="20">　总金额：<font color=red><%=rs("zongji")%></font>元 
</td>
</tr>
<tr> 
<td height="20">　<a href="buyproduct.asp?action=show&action_key_order=1" target=_blank>查看购物车/结帐&gt;&gt;</a></td>
</tr>
<tr> 
<td height="20">　<a href=user.asp?action=shoucang>我的收藏&gt;&gt;</a></td>
</tr>
<%rs.close
		set rs=nothing
		else%>
<tr> 
<td height="20"> 
　您的购物车有<font color=red>0</font>件商品<br>
　总金额：<font color=red>0</font>元
</td>
</tr>
<tr> 
<td height="1"></td>
</tr>
<%end if%>
</table>
</td>
</tr>
</table>