📄 adduser.asp
字号:
<!--#include file="inc/userconn.inc"-->
<html>
<head>
<title>用户注册</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="316395" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%
'进行安全性监测，看数据来源是否是本服务器页面
if not instr(1,Request.ServerVariables("http_Referer"),Request.ServerVariables ("SERVER_NAME"),1)=8 then
response.write "<b>请不要从非本服务器的页面提交信息</b>"
response.redirect "error.asp?error=001"
end if
%>
<%
'从提交表单返回值
username=request.form("username")
Password=request.form("Password")
Email=request.form("Email")
Oicq=request.form("Oicq")
userfrom=request.form("userfrom")
telphone=request.form("telphone")
username=replace(username,"'","''")
Password=replace(Password,"'","''")
Email=replace(Email,"'","''")
Oicq=replace(Oicq,"'","''")
userfrom=replace(userfrom,"'","''")
telphone=replace(telphone,"'","''")
'开始向数据库写入数据，并检测是否已有此用户
set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM user where username= '" & username & "'"
rs.open sql,conn,1,1
if not (rs.Bof or rs.eof) then
isun="true"
rs.Close()
response.redirect "error.asp?error=002"
else
sql="insert into user(username,password,userfrom,email,oicq,telphone) values ('"&username&"','"&password&"','"&userfrom&"','"&email&"','"&oicq&"','"&telphone&"')"
conn.Execute(sql)
'注册后，给予SESSION等于直接登陆，并导至所需页面
Session("username") = request.form("Username")
session("userleavel")=1
if Session("ProductList")<>"" then
response.redirect "check.asp"
else
response.redirect "main.asp"
end if
end if
'sql= "UPDATE User_Totals Set U_COUNT = U_COUNT + 1 where COUNT_ID = 1"
'conn.Execute(sql)
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -