infoxpuser.asp

IMPORTANT YOU SHOUD LOAD IT DOWN FOR USING

<table width=624 height="50" border=0 align=center cellpadding=0 cellspacing=0>
<tr>
<td width="624" valign="middle"><%if request.Cookies("shopxp")("username")="" then%>

  <table width="600" border="0" cellspacing="0" cellpadding="0">
     <form name="userlogin" method="post" action="usershopxp/checkusershopxplogin.asp">
	<tr>
      <td>用户名 <input type="text" class="wenbenkuang" name="username" size="14"></td>
      <td>密　码 <input type="password" class="wenbenkuang" name="userpassword" size="14"></td>
      <td>验证码 <input class=wenbenkuang name=verifycode type=text value="<%If GetCode=9999 Then Response.Write "9999"%>" maxLength=4 size=6> 
      <img src=GetshopxpCode.asp> </td>
      <td><table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td><input class=go-wenbenkuang name="imageField2" value="登 陆" type=submit onFocus="this.blur()">
          </td>
          <td><input class=go-wenbenkuang onclick="window.location='usershopxp/getpwd.asp'" type=button value="忘 密" name=Submit32></td>
        </tr>
      </table></td>
    </tr>
	</form>
  </table>
  <%else%>
<table width="600" border="0" cellspacing="0" cellpadding="0">
    <%
	if request.Cookies("shopxp")("username")<>"" then 
	set rs=server.CreateObject("adodb.recordset")
	rs.open "select count(*) as rec_count from shopxp_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 shopxp_action where username='"&request.Cookies("shopxp")("username")&"' and zhuangtai=7",conn,1,1
	%>
  <tr>
    <td width="147">您的购物车有<font color=red><%=rec_count%></font>件商品</td>
    <td width="115">总金额：<font color=red><%=rs("zongji")%></font>元</td>
    <td width="338"><a href="xpbuy.asp?action=show&action_key_order=1" target=_blank>查看购物车/结帐&gt;&gt;</a> <a href=xpuser.asp?action=shoucang>我的收藏&gt;&gt;</a> <a href="xplogout.asp">注销退出</a></td>
  </tr>
   <%rs.close
		set rs=nothing
		else%>
      <%end if%>
</table>
<%end if%></td>
</tr>
</table>