📄 savemember.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 rtrim(userid)="&"'"&trim(request("id"))&"'"
rs.open sqltext,con1,adOpenkeyset,adlockoptimistic,adcmdtext
if not(rs.eof and rs.bof) then
response.write "此用户名已被他人注册，请更正！"&"<br>"
response.write "<a href="&"vbscript:history.go(-1)"&">更正</a>"
else
if trim(request("city"))="其它" then
mjj=fixquotes(trim(request("othercity")))
else
mjj=fixquotes(trim(request("city")))
end if
insersql="insert into tpmember(userid,userpwd,cartype,carnumber,name,pass,city,phone,email,address,code,lastbrow,lastnumber,currnumber,countnumber) values('"&fixquotes(trim(request("id")))&"','"&fixquotes(trim(request("pwd")))&"','"&fixquotes(trim(cstr(request("car1"))))&"','"&fixquotes(trim(cstr(request("car2"))))&"','"&fixquotes(trim(request("tname")))&"','"&fixquotes(trim(request("pass")))&"','"&fixquotes(mjj)&"','"&fixquotes(trim(request("phonenumber")))&"','"&fixquotes(trim(request("mail")))&"','"&fixquotes(trim(request("address")))&"','"&fixquotes(trim(request("emcode")))&"','"&now&"','0','1','1')"
insertnum=0
con1.execute insersql,insertnum
if insertnum=1 then
response.write "注册成功！"
rs.close
con1.close
else
response.write "注册失败！"
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 + -