save.asp

一个不错的音乐网站

<%PageName="UserSave"%>
<!--#include file="conn.asp"-->
<!--#include file="functionuser.asp"-->
<!--#include file="const.asp"-->
<!--#include file="md5.asp"-->
<!--#include file="Star.INC"-->
<%
        
	password = md5(Trim(Replace(Request("password"), "'", "")))
	email=trim(request.form("email"))
	set rs=server.createobject("adodb.recordset")
	sql="select * from [user] where username='"&membername&"' and password='"&memberword&"'"
	rs.open sql,conn,1,3
	if rs.eof then
		errmsg="<br>"+"对不起，你不是本站用户，请重新注册。"
		founderr=true
	else
		rs("password")=password
		rs("email")=email

		if trim(request.form("Sex"))="" then
			rs("Sex")=null
		else
			rs("Sex")=trim(request.form("Sex"))
		end if

		if trim(request.form("Tel"))="" then
			rs("Tel")=null
		else
			rs("Tel")=trim(request.form("Tel"))
		end if

		if trim(request.form("Name"))="" then
			rs("Name")=null
		else
			rs("Name")=trim(request.form("Name"))
		end if

		if trim(request.form("Address"))="" then
			rs("Address")=null
		else
			rs("Address")=trim(request.form("Address"))
		end if

		if trim(request.form("Youbian"))="" then
			rs("Youbian")=null
		else
			rs("Youbian")=trim(request.form("Youbian"))
		end if

		if trim(request.form("Shenfenzheng"))="" then
			rs("Shenfenzheng")=null
		else
			rs("Shenfenzheng")=trim(request.form("Shenfenzheng"))
		end if
		if trim(request.form("oicq"))="" then
			rs("oicq")=null
		else
			rs("oicq")=trim(request.form("oicq"))
		end if

		rs.update
		Response.Cookies("bzmtvmusic")("password") = PassWord
	end if
	rs.close

	if founderr=true then
		call error()
	else
%>
<LINK href="../images/index.css" rel=stylesheet type=text/css>
<div align="center" style="width: 255; height: 67">

        <div align="center">       
          
  <table border="0" cellpadding="4" cellspacing="1" width="229">
    <tr> 
      <td colspan="2"  align="center" width="241"><span style="font-size: 9pt">
      修改成功</span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">登录帐号：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=membername%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">电子信箱：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=Email%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">您的称呼：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("Sex")%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">真实姓名：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("Name")%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">身份证号：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("Shenfenzheng")%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">联系电话：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("Tel")%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">详细地址：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("Address")%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">邮政编码：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("Youbian")%></span></td>
    </tr>
    <tr> 
      <td width="74"  align="right"><span style="font-size: 9pt">OCIQ号码：</span></td>
      <td width="158" ><span style="font-size: 9pt">&nbsp;<%=request("OICQ")%></span></td>
    </tr>
    <tr> 
      <td width="241"  align="center" colspan="2"> 
        <span style="font-size: 9pt"> 
        <INPUT type=button name=back value="修改成功" onclick="javascript:window.open('Modify.asp','_self','')" style="font-size: 9pt">
        </span>
      </td>
    </tr>
  </table>     
        </div>     
           
 </div>
           
<%
end if
set rs=nothing
conn.close
set conn=nothing
%>