mesave.asp

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

<%@ LANGUAGE = "vbscript" %>

<!--#include file="conn.asp"-->

<%

set rs=server.createobject("adodb.recordset")
sql="select * from users where userid='"&request.cookies("userid")&"' and password='"&request.cookies("password")&"'"
rs.open sql,conn,1,3
password=request("password")
rs("password")=password
rs("name")=request("name")
rs("email")=request("email")
rs("sex")=request("sex")
rs("province")=request("province")

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

rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.cookies("password")=password
response.redirect "meedit.asp?id="&request("id")
%>