Question

ASP表单提交前的验证

<!-- #include file="include/conn.asp" -->

<b><font color="#FFFFFF" face="宋体"><span lang="zh-cn">注册</span></font></b>
<form action="add_messages.asp" method="POST" style="vertical-align: super">
<b>License</b><span lang="zh-cn"></span><input type="varchar" name="license" size="12" maxlength="12"><p><span lang="zh-cn">
<b>姓名 </b> </span><input type="varchar" name="username" size="8" maxlength="2"><br><span lang="zh-cn"></span>
<b>电话</b><span lang="zh-cn"><b> </b></span><input type="varchar" name="phone_no" size="20"></p><p><span lang="zh-cn"></span>
<b>地址</b><span lang="zh-cn"><b></b> </span><input type="varchar" name="address" size="50"></p><p>
<b><span lang="zh-cn"> 邮箱</span></b><span lang="zh-cn"> </span><input type="varchar" name="email" size="50"></p><p><span lang="zh-cn">
<b> 建议 </b></span><textarea name="advice" rows="3" cols="48"></textarea>
<input type="submit" value="确认" style="color: #000000; "></p>
</form>
</body>

我想实现,如果数据库中有用户输入的license号,就允许完成用户提提交注册.
请给出代码.谢谢了.
if license<>"" and username<>"" then%>
<!-- #include file="include/conn.asp" -->
<% set rs=server.CreateObject("adodb.recordset")
sql="insert into reginfo (license,username,phone_no,address,email,advice,ip) values ('"&license&"','"&username&"','"&phone_no&"','"&address&"','"&email&"','"&advice&"','"&ip&"')"
conn.Execute(sql)
conn.close
response.redirect("ok.asp")

else
Response.Write "<script language='javascript'>alert('字段不能有空！');location='index444444.asp';</script>"

End If
%>

现在license的条件是非空,我想改成条件是与数据库中已经有的合法license匹配,才能注册.请帮助给个详细的代码.谢谢.

下面仁兄.的代码能细点写吗? 我要的是用户输入的license与库里面的license要检查一下,如果有可以注册.

Answer 1

<!-- #include file="include/conn.asp" -->
<%

lic=request.form("license")
set reg=conn.execute ("select license from table where license='"&lic&"'")
if not reg.eof then
response.write"<script>alert("error !,license input repleat,please input again");history.back(-1)</script>"
else
'提交入库语句
end if
%>
<b><font color="#FFFFFF" face="宋体"><span lang="zh-cn">注册</span></font></b>
<form action="add_messages.asp" method="POST" style="vertical-align: super">
<b>License</b><span lang="zh-cn"></span><input type="varchar" name="license" size="12" maxlength="12"><p><span lang="zh-cn">
<b>姓名 </b> </span><input type="varchar" name="username" size="8" maxlength="2"><br><span lang="zh-cn"></span>
<b>电话</b><span lang="zh-cn"><b> </b></span><input type="varchar" name="phone_no" size="20"></p><p><span lang="zh-cn"></span>
<b>地址</b><span lang="zh-cn"><b></b> </span><input type="varchar" name="address" size="50"></p><p>
<b><span lang="zh-cn"> 邮箱</span></b><span lang="zh-cn"> </span><input type="varchar" name="email" size="50"></p><p><span lang="zh-cn">
<b> 建议 </b></span><textarea name="advice" rows="3" cols="48"></textarea>
<input type="submit" value="确认" style="color: #000000; "></p>
</form>
</body>