info_myshop.asp

网上购物,不错的购物系统,花了好长时间来改的

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td height="1" background="images/bj_x.gif"></td>
  </tr>
  <tr>
    <td height="14"><img src="images/main/myshop.gif" width="174" height="34"> </td>
  </tr>
  <tr>
    <td height="1" background="images/bj_x.gif"></td>
  </tr>
  <tr> 
    <td> 
      <table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" height="63">
        <%
					  if request.cookies("songxf")("username")<>"" then 
					  set rs=server.CreateObject("adodb.recordset")
					  rs.open "select count(*) as rec_count from shop_action where username='"&request.cookies("songxf")("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("songxf")("username")&"' and zhuangtai=7",conn,1,1
					  %>
        <tr> 
          <td height="2" align=cneter></td>
        </tr>
        <tr> 
          <td height="20" align="center"> 有<font color=red><%=rec_count%></font>种商品在购物车内 
          </td>
        </tr>
        <tr> 
          <td height="20" align="center"> 总计￥：<font color=red><%=rs("zongji")%></font>元 
          </td>
        </tr>
        <tr> 
          <td height="8" align="center"></td>
        </tr>
        <tr> 
          <td height="20" align="center"><a href="javascript:;" onClick="javascript:window.open('gouwu.asp?action=show&lx=1','gouwu','width=450,height=350,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');">查看购物车/结帐&gt;&gt;</a></td>
        </tr>
        <tr> 
          <td height="20" align="center"><a href=user.asp?action=shoucang>我的收藏&gt;&gt;</a></td>
		</tr>
		<tr> 
          <td height="20" align="center"><a href=user.asp><font color="#FF6600"><b>立即在线支付</b></font></a></td>
		</tr>
          <td height="1" background="images/ppb.gif"></td>
        </tr>
        <%rs.close
							  set rs=nothing
							  else%>
        <tr> 
          <td height="2" align="cneter"></td>
        </tr>
        <tr> 
          <td height="20"> 
            <div align="center">有<font color=red>0</font>种商品在购物车内<br>
              总计￥：<font color=red>0</font>元</div>
          </td>
        </tr>
        <tr> 
          <td height="1"></td>
        </tr>
        <%end if%>
      </table>
    </td>
  </tr>
</table>