📄 updatemember.asp
字号:
<%@ LANGUAGE="VBSCRIPT" %>
<!--#include file="adovbs.inc"-->
<%
function fixQuotes(theString)
fixQuotes=Replace(theString,"'","''")
end function
dbpath=server.mappath("twoloop.mdb")
set con1=server.createobject("adodb.connection")
con1.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.createobject("adodb.recordset")
sqltext="select * from tpmember where id=cdbl('"&request("recordid")&"')"
rs.open sqltext,con1,adOpenkeyset,adlockoptimistic,adcmdtext
if rs.eof then
response.write "操作超时！"&"<br>"
response.write "<a href='"&"vbscript:history.go(-1)"&"'>返回主页</a>"
else
upsql="update tpmember set userid='"+fixquotes(trim(request("id")))
upsql=upsql+"',userpwd='"+fixquotes(trim(request("pwd")))
upsql=upsql+"',cartype='"+fixquotes(trim(request("car1")))
upsql=upsql+"',carnumber='"+fixquotes(trim(request("car2")))
upsql=upsql+"',name='"+fixquotes(trim(request("tname")))
upsql=upsql+"',pass='"+fixquotes(trim(request("pass")))
upsql=upsql+"',city='"+fixquotes(trim(request("city")))
upsql=upsql+"',phone='"+fixquotes(trim(request("phonenumber")))
upsql=upsql+"',email='"+fixquotes(trim(request("mail")))
upsql=upsql+"',address='"+fixquotes(trim(request("address")))
upsql=upsql+"',code='"+fixquotes(trim(request("emcode")))
upsql=upsql+"',lastbrow='"+cstr(now)
if month(rs("lastbrow"))=month(now) then
upsql=upsql+"',lastnumber='"+cstr(rs("lastnumber"))
upsql=upsql+"',currnumber='"+cstr(rs("currnumber")+1)
else
upsql=upsql+"',lastnumber='"+rs("currnumber")
upsql=upsql+"',currnumber="+"'1"
end if
upsql=upsql+"',countnumber='"+cstr(rs("contnumber")+1)
upsql=upsql+"' where id=cdbl('"+request("recordid")+"')"
insertnum=0
response.write upsql
con1.execute upsql,insertnum
if insertnum=1 then
response.write "注册修改成功！谢谢您的合作！"&"<br>"
response.write "<a href='"&"vbscript:history.go(-1)"&"'>返回主页</a>"
rs.close
con1.close
else
response.write "信息修改失败！"&"<br>"
response.write "<a href='"&"vbscript:history.go(-1)"&"'>返回主页</a>"
rs.close
con1.close
end if
end if
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF">
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -