step-2.asp

西亚电子购物系统

<!--#include file="header.asp" -->
<!--#include file="conn/nosql.asp" -->
<%
if request("sia_user")="" then 
response.write "<br><br><br><div align='center'>请输入会员名称，谢谢！</div>"
response.end
end if
if request("password")="" then 
response.write "<br><br><br><div align='center'>请填写会员密码，谢谢！</div>"
response.end
end if
if request("name")="" then 
response.write "<br><br><br><div align='center'>请留下您的真实姓名，谢谢！</div>"
response.end
end if
if request("address")="" then 
response.write "<br><br><br><div align='center'>请留下您的联系地址，谢谢！</div>"
response.end
end if
if request("tel")="" then 
response.write "<br><br><br><div align='center'>请留下您的联系电话，谢谢！</div>"
response.end
end if
if request("info")<>"" then 
 if request("mail")="" then
 response.write "<script>alert(""订阅产品快讯则信箱地址不能为空！"");history.back();</script>"
 response.end
 end if
 info=true
 else
 info=false
end if
set rs=server.createobject("adodb.recordset")
	sql="select * from sia_user where sia_user='"&nosql(request("sia_user"))&"'"
	rs.open sql,conn,3,3
	if rs.recordcount>0 then
		response.write "<script language=JavaScript>{window.alert('此会员帐号已经注册!');window.history.go(-1)}</script>"
	    response.end
	else
session("sia_user")=nosql(request.form("sia_user"))
session("grade")=0
'添加一个用户到数据库
rs.addnew
rs("sia_user")=nosql(request.form("sia_user"))
rs("password")=nosql(request.form("password"))
rs("name")=nosql(request.form("name"))
rs("sex")=nosql(request.form("sex"))
rs("province")=nosql(request.form("province"))
rs("address")=nosql(request.form("address"))
rs("ip") = Request.servervariables("REMOTE_ADDR")
rs("zipcode")=nosql(request.form("zipcode"))
rs("tel")=nosql(request.form("tel"))
rs("mail")=nosql(request.form("mail"))
rs("info")=info
rs.update
rs.close

Response.redirect "step-3.asp"

end if %>