⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 my_info.asp

📁 网上购物系统 asp+sql server 2005
💻 ASP
字号:
<!--#include file="include/dbopenbd.asp" -->
<%
call checklogin()
if request("edit")="ok" then call edit()
%>

<HTML>
<HEAD>
<TITLE>用户中心-<%=sitename%>-<%=siteurl%></TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="description" content="<%=sitedescription%>">
<meta name="keywords" content="<%=sitekeywords%>">
<link rel="stylesheet" href="include/css.css" type="text/css">
</HEAD>
<CENTER>
<!--#include file="a_top.asp"-->
<table width=760 border=0 align=center cellpadding=0 cellspacing=0 bgcolor="#FFFFFF"  class="grayline" >
<tr> 
<td align="center" valign="top" width="185"> 
<!--#include file="user_center_menu.asp"-->
</td>
<td bgcolor="#CCCCCC" width="1"></td>
<td valign="top" bgcolor="#FfFfFf" width="570"> 
<TABLE border=0 width="100%" cellspacing="2" cellpadding="2" align=center>
<tr><td height=30>目前位置:<a href=main.asp>首页</a> > <a href=user_center.asp>用户中心</a> > 个人资料</td></tr>
<tr><td width="570"  align="center" height="1" background="images/small/bgline.gif"></td></tr></table>

<br>
<%
set rs=conn.execute("select * from s_buser where UserId='"&request.cookies("buyok")("userid")&"'")
Memo=rs("Memo")
Memo2=rs("Memo2")
%>

	<%if Memo2<>"" then%>
	 <table width="80%" border="0" cellpadding="4" cellspacing="0" bordercolor="#C0C0C0" align=center bordercolordark="#FFFFFF">
	 <tr><td><marquee scrolldelay="200" id=zimu1 onMouseOver=zimu1.stop() onMouseOut=zimu1.start()><b>管理员:</b><%=Memo2%></marquee></td></tr>
	</table>
	<%end if%>


        <form name="myinfo" action="my_info.asp" method="post">
	 <table width="80%" border="1" cellpadding="4" cellspacing="0" bordercolor="#C0C0C0" align=center bordercolordark="#FFFFFF">
	<tr><td colspan=2><b>以下为基本资料:</b></td></tr>
        <tr> 
            <td width="30%" align="right">登陆帐号: </td>
          <td width="70%"><%=rs("UserID")%></td>
        </tr>
        <tr> 
            <td align="right">真实姓名: </td>
          <td><input type="text" name="Username" value="<%=rs("UserName")%>" maxlength="16" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
        </tr>

        <tr> 
            <td align="right">电子邮箱: </td>
          <td><input  type="text" name="UserMail" value="<%=rs("UserMail")%>" maxlength="100" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ;"></td>
        </tr>
        <tr> 
            <td align="right">联系地址: </td>
          <td><input  type="text" name="Address" value="<%=rs("Address")%>" maxlength="50" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
        </tr>
        <tr> 
            <td align="right">邮政编码: </td>
          <td><input  type="text" name="ZipCode" value="<%=rs("ZipCode")%>"  maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
        </tr>
        <tr> 
            <td align="right">联系电话: </td>
          <td><input  type="text" name="HomePhone" value="<%=rs("HomePhone")%>"  maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
        </tr>

	<tr><td colspan=2><b>以下为选填资料:</b></td></tr>

        <tr> 
            <td  width="30%" align="right">移动电话: </td>
          <td width="70%"><input  type="text" name="CompPhone" value="<%=rs("CompPhone")%>"  maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>
	<tr> 
            <td align="right">腾讯QQ号: </td>
          <td><input  type="text" name="UserQQ" value="<%=rs("UserQQ")%>"  maxlength="11" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>
	<tr> 
            <td align="right">ICQ号: </td>
          <td><input  type="text" name="UserICQ" value="<%=rs("UserICQ")%>"  maxlength="18" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>
	<tr> 
            <td align="right">MSN号: </td>
          <td><input  type="text" name="UserMSN" value="<%=rs("UserMSN")%>"  maxlength="100" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; "></td>
        </tr>
        <tr> 
            <td align="right">国 家: </td>
          <td><input  type="text" name="Country" value="<%=rs("Country")%>"  maxlength="30" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>
        <tr> 
            <td align="right">省 份: </td>
          <td><input  type="text" name="Province" value="<%=rs("Province")%>"  maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>
        <tr> 
            <td align="right">城 市: </td>
          <td><input  type="text" name="City" value="<%=rs("City")%>"  maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>
		<tr> 
            <td align="right">性 别: </td>
          <td>
		  <input  name="Sex" type="radio" value="1" <%if rs("Sex")="1" then response.write "checked"%>><img border=0 src=images/small/boy.gif>帅哥 <input type="radio" name="Sex" value="0" <%if rs("Sex")="0" then response.write "checked"%>><img border=0 src=images/small/girl.gif>靓妹
        </td></tr>
        <tr> 
            <td align="right">生 日: </td>
          <td><input  type="text" name="Birthday" value="<%=rs("Birthday")%>" maxlength="20" style="height=22; width=80%; BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"></td>
        </tr>

	 <tr> 
            <td align="right">个人说明: </td>
          <td><TEXTAREA type="text" name="Memo"  ROWS="4" COLS="38" style="BORDER-RIGHT: darkgray 1px solid; BORDER-TOP: darkgray 1px solid; FONT-SIZE: 8pt; BORDER-LEFT: darkgray 1px solid; COLOR: #666666; BORDER-BOTTOM: darkgray 1px solid; FONT-FAMILY: verdana ; overflow:auto;"><%=Memo%></TEXTAREA></td>
        </tr>

	<tr><td colspan=2 align=center> 
	  <input type="submit" name="Submit" value="确认修改">&nbsp;&nbsp;&nbsp;&nbsp; 
          <input name="Submit2" type="reset" value="重新填写"><input type=hidden name=edit value="ok">
	</td></tr>
        </form>        
      </table><br><br>
<%
rs.close
set rs=nothing
%>	  
</td>
</TR>
</TABLE>
<!--#include file="a_bottom.asp"-->
</BODY>
</HTML>

<%
'修改资料
sub edit()
call check_path()   '保证此页的调用是合法的
Username=aspsql(request("Username"))
UserQQ=aspsql(request("UserQQ"))
UserMSN=aspsql(request("UserMSN"))
UserICQ=aspsql(request("UserICQ"))
Sex=aspsql(request("Sex"))
Birthday=aspsql(request("Birthday"))
HomePhone=aspsql(request("HomePhone"))
CompPhone=aspsql(request("CompPhone"))
UserMail=aspsql(request("UserMail")) 
Country=aspsql(request("Country")) 
Province=aspsql(request("Province"))
City=aspsql(request("City"))
Address=aspsql(request("Address"))  
ZipCode=aspsql(request("ZipCode"))
Memo=aspsql(request("Memo"))

sql = "select * from s_buser where UserId='"&request.cookies("buyok")("userid")&"'"
set rs=Server.Createobject("ADODB.RecordSet")
rs.Open sql,conn,1,3
rs("Username")=Username
rs("Sex")=Sex
rs("UserQQ")=UserQQ
rs("UserICQ")=UserICQ
rs("UserMSN")=UserMSN
rs("Birthday")=Birthday
rs("HomePhone")=HomePhone
rs("CompPhone")=CompPhone
rs("UserMail")=UserMail
rs("Country")=Country
rs("Province")=Province
rs("City")=City
rs("Address")=Address
rs("ZipCode")=ZipCode
rs("Memo")=Memo
rs.update
set rs = nothing
response.write "<script language='javascript'>"
response.write "alert('操作成功,您修改的个人资料已保存!');"
response.write "location.href='my_info.asp';"
response.write "</script>"
response.end
end sub

conn.close
set conn=nothing
%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -