gouwucheinfo.asp

来自「php 语言写的c2c商城网站程序」· ASP 代码 · 共 49 行

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="35" bgcolor="f1f1f1" background="images/menu_02.gif"></td>
</tr>
<tr> 
<td> 
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" height="70">
<%
	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
	%>
<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="gouwu.asp?action=show&lx=1">查看购物车/结帐&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>