asp+ajax無重新整理使用者註冊代碼

最後更新：2017-01-13 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

reg.asp檔案

<%
username=request.Form("username")
password=request.Form("password")

sql="select * from puser where y_username='"&username&"'"
rs.open sql,conn,1,1
If Not rs.eof Then
response.write "no"
response.end
End If
rs.close

sql="insert into puser(y_username,y_password) values('"&username&"','"&password&"')"
rs.open sql,conn,1,3
response.write "yes"
%>

adoconn.asp檔案代碼
<%
set rs=server.CreateObject("adodb.recordset")
db="./username.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
conn.Open connstr
%>

檢測使用者是否存在

<%
username=Replace(request.querystring("username"),"'","")
sql="select * from puser where y_username='"&username&"'"
rs.open sql,conn,1,1
if rs.eof then
response.write "no"
else
response.write "yes"
end if
rs.close
%>

mdb.資料表

y_id 自動編號
y_username text
y_password text

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> 使用者註冊 </TITLE>
</HEAD>
<style>

</style>
<BODY>
<script language=javascript教程>
<!--
function checkUserName()
{
   username=document.getElementById("username").value;
   var xmlhttp;
   try
   {
xmlhttp=new ActiveXObject("Msxml2.XMLHTTP");
   }
   catch (e)
   {
     try
     {
       xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
     }
     catch (e)
     {
     try
     {
   xmlhttp=new XMLHttpRequest();
     }
     catch (e)
     {
     }
     }
   }
if (username=="")
{
    msg="使用者名稱不可為空";
var ch=document.getElementById("check1");
ch.innerHTML="<font color='#aaaaaa'>"+msg+"</font>";
return false;
}

//建立請求，並使用escape對username編碼，以避免亂碼
   xmlhttp.open("get","checkuser.asp?username="+escape(username)+ "&t=" + new Date().getTime());
   xmlhttp.onreadystatechange=function()
   {
     if(4==xmlhttp.readyState)
{
    if(200==xmlhttp.status)
    {
      if (xmlhttp.responseText=="yes")
      {
     msg="此使用者名稱已經存在";
      }
   else
   {
    msg="輸入正確";
   }
    }
    else
    {
      msg="網路連結失敗";
    }
    var ch=document.getElementById("check1");
    ch.innerHTML="<font color='#aaaaaa'>"+msg+"</font>";
}
   }
   xmlhttp.send(null);
   return false;
   }
//-->
</script>

//建立請求，並使用escape對username編碼，以避免亂碼
   xmlhttp.onreadystatechange=function()
   {
     if(4==xmlhttp.readyState)
{
    if(200==xmlhttp.status)
    {
      if (xmlhttp.responseText=="yes")
      {
   this.form1.username.value="";
   this.form1.password.value="";
   this.form1.password1.value="";
   document.getElementById("check1").innerHTML="";
   document.getElementById("password2").innerHTML="";
   document.getElementById("password3").innerHTML="";
   alert('註冊成功');
  }
  else
  {
      this.form1.password.value="";
   this.form1.password1.value="";
   alert('註冊失敗');
  }
    }
    else
    {
    alert('網路連接失敗');
    }
}
   }
//開啟串連
xmlhttp.open("post","reg.asp",true)
xmlhttp.setRequestHeader('Content-type','application/x-www-form-urlencoded');
//發送資料
xmlhttp.send("username="+escape(username)+"&password="+escape(password));
}
</script>
<div align="center">
<TABLE border=1 cellpadding=0 cellspacing=0 width=500>
<form name="form1" method="post">
<TR>
<TD colspan=2 align="center" height=25><b>使用者註冊</b></TD>
</TR>
<TR>
<TD align=right width=100>使用者名稱</TD>
<TD align=left><input type=text size=30 name="username" id="username" onBlur="return checkUserName();"> <span id="check1"></span></TD>
</TR>
   <TR>
<TD align=right>密碼</TD>
<TD align=left><input type=password size=30 name="password" onBlur="checkpass();" maxlength=20> <span id="password2"></span></TD>
</TR>
    <TR>
<TD align=right>確認密碼</TD>
<TD align=left><input type=Password size=30 name="password1" onBlur="checkpass1();" maxlength=20> <span id="password3"></span></TD>
</TR>
<TR>
<TD align="center" colspan=2><input type="button" value="註冊" onclick="return sendreg();" maxlength=20> <input type="reset" value="重設"></TD>
</TR>
</form>
</TABLE>
</div>
</BODY>
</HTML>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More

asp+ajax無重新整理使用者註冊代碼

聯繫我們

A Free Trial That Lets You Build Big!

Sales Support

After-Sales Support