📄 signupsubmit.asp
字号:
<!--#include file="conn.asp"-->
<%
userid=trim(request("signup_uid"))
set rs=server.createobject("adodb.recordset")
sqltext="select * from userb where userid='"&userid&"'"
rs.open sqltext,conn,3,3
if not rs.eof and not rs.bof then
Response.Redirect "messagebox.asp?msg=此用户名已经注册过，请选用其他用户名!"
else
'添加一条记录到数据库
rs.addnew
rs("userid")=request.form("signup_uid")
rs("password")=request.form("signup_pwd")
rs("email")=request.form("signup_email")
rs("sex")=request.form("signup_gender")
rs("username")=request.form("signup_username")
rs("telphone")=request.form("signup_tel")
rs("zip")=request.form("signup_zip")
rs("address")=request.form("signup_addr")
if request.form("signup_idcardno")="" then
rs("idcard")="空"
else
rs("idcard")=request.form("signup_idcardno")
end if
if request.form("signup_birth")="" then
rs("birthday")=""
else
rs("birthday")=request.form("signup_birth")
end if
if request.form("signup_career")="请选择..." then
rs("work")="空"
else
rs("work")=request.form("signup_career")
end if
if request.form("signup_income")="请选择..." then
rs("income")="空"
else
rs("income")=request.form("signup_income")
end if
if request.form("signup_education")="请选择..." then
rs("knowledge")="空"
else
rs("knowledge")=request.form("signup_education")
end if
rs("point")=1000
rs("regtime")=now()
rs.update
%>
<html>
<head>
<title>会员登记成功</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style.css" type="text/css">
</head>
<body text="#000000">
<div align="center">
<center>
<TABLE cellSpacing=1 cellPadding=4 width=445 bgColor=#416327 height="144">
<TBODY>
<TR vAlign=top bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="10" bgcolor="#1f60a0"></TD></TR>
<TR vAlign=top bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="32"><font class="medium">
<p align="center">恭喜！你已经顺利成为正式会员!<br>
同时作为奖励，你也获得了<font color="#ff0000"><b>1000</b></font>点积分！</p>
</center>
<p align="left"><font color="#0000FF">会员注册成功，注册信息如下----</font></font></TD></TR>
<tr>
<TD class=main1 width=419 bgColor=#1f60a0 height=25 align="right" colspan="2">
<p align="left"><font color="#FFFFFF">基本资料</font></TD>
</tr>
<center>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">用户名：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("userid")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">电子邮件：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("email")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">性别：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("sex")%></TD>
</tr>
<tr>
<TD class=main1 width=419 bgColor=#1f60a0 height=25 align="right" colspan="2">
</center>
<p align="left"><font color="#FFFFFF">联系信息</font></TD>
</tr>
<center>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">真实姓名：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("username")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">邮政编码：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("zip")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">联系地址：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("address")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">联系电话：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("telphone")%></TD>
</tr>
</center>
<tr>
<TD class=main1 width=419 bgColor=#1F60A0 height=25 align="right" colspan="2">
<p align="left"><font color="#FFFFFF">补充信息</font></TD>
</tr>
<center>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">身份证号码：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("idcard")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">生日：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%if rs("birthday")="" then%>空<%else%><%=rs("birthday")%><%end if%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">职业：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("work")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">月收入：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("income")%></TD>
</tr>
<tr>
<TD class=main1 width=102 bgColor=#6688CC height=25 align="right"><SPAN
class=main1><font color="#FFFFFF">学历：</font></SPAN></TD>
<TD class=main1 width=317 height=25 bgcolor="#e1f0ff"> <%=rs("knowledge")%></TD>
</tr>
<TR vAlign=top bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="15"></TD></TR>
<TR bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="27">
<p align="center">
<INPUT class=main type=button size=3 value='登录' name=Submit2 onclick="javascript:window.location.href='login.htm'">
</TD></TR>
<TR bgColor=#e1f0ff>
<TD class=main1 colSpan=2 width="431" height="4" bgcolor="#1f60a0"></TD></TR></TBODY></TABLE>
</center>
</div>
<p align="center">
</body>
</html>
<%
rs.close
conn.close
end if
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -