usersave.asp

《Web数据库技术》-高晗-vod点播系统程序源代码

<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select * from users where userid='"&Replace(request("userid"), "'", "''")&"'"
rs.open sql,conn,1,3

if request("change")<>"" then
     rs("userid")=request("useridd")
  if Replace(request("password"), "'", "''")<>"" then
    rs("password")=Replace(request("password"), "'", "''")
   end if
rs("name")=request("name")
rs("email")=request("email")

rs("times")=request("times")


rs("adress")=request("adress")
rs("starlook")=request("starlook")
rs("nlook")=request("nlook")
rs("sex")=request("sex")
rs("province")=request("province")

rs("phone")=request("phone")

rs.update


end if

rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect Request.ServerVariables("HTTP_REFERER")
%>