📄 newusercheck.asp
字号:
<%@ Language=VBScript %>
<%option explicit%>
<% on error resume next
dim conn,rs,sql,i,connstr,founderr
founderr=false
connstr="dbq=" & server.MapPath("mdb/bookshop.mdb") & ";driver={microsoft access driver (*.mdb)};"
set conn=server.CreateObject("adodb.connection")
conn.Open connstr
set rs=server.CreateObject("adodb.recordset")
dim temp
temp=Request.Form("newusername")
if temp="" then
founderr=true
Response.Write "非法的用户名!"
Response.End
end if
sql="select * from guest where nicename='" & temp & "'"
rs.Open sql,conn,1,1
if rs.RecordCount>0 then
founderr=true
Response.Write "此用户名已注册!"
Response.End
end if
'if not founderr then Response.Redirect "useradd.asp"
%>
<HTML>
<HEAD>
<style>
<!--
.FONT {
COLOR: navy; FONT-FAMILY: "宋体"; FONT-SIZE: 12px; LINE-HEIGHT: 14px
}
.3dfont {
FILTER: glow(color=ffffff,strength=0) shadow(color=aaaaaa,direction:135); POSITION: relative; WIDTH: 100%
}
-->
</style>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
</HEAD>
<BODY>
<P class="FONT">为了我们更好的为您服务，更准确及时的将您订购的商品送到您的手中和与您联系，请您务必详细填写您的信息，并核对无误；
国内用户请留下您的真实中文姓名。<BR>请放心：您的资料未经您的允许，我们将只用于处理您的订货信息，对外保密。 <FONT
face=Arial>(</FONT>带<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT><SPAN class=16v><FONT
color=#000080>号为必填项<FONT face=Arial>)</FONT></FONT></SPAN></P>
<form method="POST" action="newuseradd.asp">
<p><TABLE border=1 cellPadding=1 cellSpacing=1 width="318" align="center">
<TR>
<TD class="FONT" width="74">昵称</TD>
<TD width="228"><%=temp%> <input type="hidden" name="nicename" size="20" value="<%=temp%>"></TD></TR>
<TR>
<TD class="FONT" width="74">姓名<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="text" name="name" size="20" value=""></TD></TR>
<TR>
<TD class="FONT" width="74">联系电话<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="text" name="tel" size="20"></TD></TR>
<TR>
<TD class="FONT" width="74">联系地址<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="text" name="addr" size="20"></TD></TR>
<TR>
<TD class="FONT" width="74">E_mail:<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="text" name="email" size="20"></TD></TR>
<TR>
<TD class="FONT" width="74">邮编：<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="text" name="zip" size="20"></TD></TR>
<TR>
<TD class="FONT" width="74">密码：<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="password" name="password1" size="20"></TD></TR>
<TR>
<TD class="FONT" width="74">确认密码<FONT color=#ff0000><STRONG><SPAN
class=main2>＊</SPAN></STRONG></FONT></TD>
<TD width="228"><input type="password" name="password2" size="20"></TD></TR></TABLE>
<p align="center"><input type="submit" value="提交" name="B1"><input type="reset" value="全部重写" name="B2"></p>
</form>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -