注册 登录
编程论坛 ASP技术论坛

又一种提示问题

nixy 发布于 2007-08-29 18:04, 424 次点击
现在好多网站注册都是你把用户名输入后自动提示你是否注册过,这样的ASP怎么做呀,请各位大虾和老师指教,我用来储存用户名的表是USER
6 回复
#2
jamesxiaoyao2007-08-29 18:07
可以用 JAVA 脚本来做啊,当失去焦点onblur()的时候,去和数据库中的字段来比对。
#3
nixy2007-08-29 18:10
有实例吗?JAVA 脚本我还不会呢

[此贴子已经被作者于2007-8-29 18:11:31编辑过]


#4
jamesxiaoyao2007-08-29 18:14
GG一下没有吗
#5
jamesxiaoyao2007-08-29 18:17

<SCRIPT language=JavaScript>
<!--
function check(value)
{
window.open("checkuser.asp?username="+value,"",'toolbar=no,directories=no,scrollbars=0,resizable=1,status=no,menubar=0,width=250,height=100');
}
-->
</SCRIPT>

<form method="POST" action="regsave.asp" name="form1" onSubmit="return test();">
用户名:<input type="text" name="username" size="20" maxlength="12" tabindex="1">
<input type="button" name="button1" onclick="check(document.form1.username.value)" value="查看用户名是否可用" />
</form>

验证页面 checkuser.asp
------------------------------------------------------

<!--#i nclude file="conn.asp"-->
<%if request("username")="" then
response.write"<SCRIPT language=JavaScript>alert('对不起!请输入你的帐号!');javascript:window.close();</SCRIPT>"
end if
if len(request("username"))<4 then
response.write"<SCRIPT language=JavaScript>alert('输入的帐号至少为4位数!');javascript:window.close();</SCRIPT>"
end if
%>
<%dim username,sql
username=request("username")
sql="select * from dv_user where username='"&username&"'"
rst.open sql,conn,1,3
%>
<% if not rst.eof then
response.write "<p align='center'><font color=#ff0000 size=2>对不起!此帐号已被人注册,请您另选帐号!</font></p><br>"
response.write "<p align='center'><a href='javascript:window.close()' class='A02'>关闭窗口</a></p>"
else
response.write "<p align='center'><font color=#ff0000 size=2>恭喜你!此帐号无人使用,请继续注册!</font></p><br>"
response.write "<p align='center'><a href='javascript:window.close()' class='A02'>关闭窗口</a></p>"
end if%>

他这里是个点击事件,你可以把事件修改一下

#6
jamesxiaoyao2007-08-29 18:18

<SCRIPT language=JavaScript>
<!--
function onblur(value)
{
window.open("checkuser.asp?username="+value,"",'toolbar=no,directories=no,scrollbars=0,resizable=1,status=no,menubar=0,width=250,height=100');
}
-->
</SCRIPT>

<form method="POST" action="regsave.asp" name="form1" onSubmit="return test();">
用户名:<input type="text" name="username" size="20" maxlength="12" tabindex="1" onblur="check(document.form1.username.value)" >
</form>

验证页面 checkuser.asp
------------------------------------------------------

<!--#i nclude file="conn.asp"-->
<%if request("username")="" then
response.write"<SCRIPT language=JavaScript>alert('对不起!请输入你的帐号!');javascript:window.close();</SCRIPT>"
end if
if len(request("username"))<4 then
response.write"<SCRIPT language=JavaScript>alert('输入的帐号至少为4位数!');javascript:window.close();</SCRIPT>"
end if
%>
<%dim username,sql
username=request("username")
sql="select * from dv_user where username='"&username&"'"
rst.open sql,conn,1,3
%>
<% if not rst.eof then
response.write "<p align='center'><font color=#ff0000 size=2>对不起!此帐号已被人注册,请您另选帐号!</font></p><br>"
response.write "<p align='center'><a href='javascript:window.close()' class='A02'>关闭窗口</a></p>"
else
response.write "<p align='center'><font color=#ff0000 size=2>恭喜你!此帐号无人使用,请继续注册!</font></p><br>"
response.write "<p align='center'><a href='javascript:window.close()' class='A02'>关闭窗口</a></p>"
end if%>

他这里是个点击事件,你可以把事件修改一下

#7
nixy2007-08-30 07:41

谢谢楼上的哥哥

1