ajax注冊(cè)是現(xiàn)在我看到網(wǎng)站中所有網(wǎng)站幾乎都會(huì)使用到的一個(gè)功能,下面我就來(lái)給各位整理一個(gè)關(guān)于ajax注冊(cè)驗(yàn)證例子,希望此例子能幫助到各位哦.
html代碼如下:
- <script src="ajax.js"></script>
- <form>
- <table>
- <tr>
- <td>用戶名:</td>
- <td><input type="text" id="txt1" onKeyUp="showHint(this.value)"></td>
- </tr>
- <tr align="center">
- <td colspan="2"><span id="txtHint"></span></td>
- </tr>
- </table>
- </form>
js文件代碼如下:
- var xmlHttp
- function showHint(str)
- {
- if (str.length==0)
- {
- document.getElementById("txtHint").innerHTML=""
- return
- }
- xmlHttp=GetXmlHttpObject()
- if (xmlHttp==null)
- {
- alert ("Browser does not support HTTP Request")
- return
- }
- xmlHttp.onreadystatechange=stateChanged
- var geturl="conn.php?q="+str
- //sid是增加一個(gè)隨機(jī)數(shù) 防止頁(yè)面啟用緩存技術(shù)·
- geturl=geturl+"&sid="+Math.random()
- geturl=encodeURI(geturl);
- geturl=encodeURI(geturl);
- xmlHttp.open("GET",geturl,true)
- xmlHttp.send(null)
- }
- function stateChanged()
- {
- if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
- {
- document.getElementById("txtHint").innerHTML=xmlHttp.responseText
- }
- }
- function GetXmlHttpObject()
- {
- var xmlHttp=null;
- try
- {
- // Firefox, Opera 8.0+, Safari
- xmlHttp=new XMLHttpRequest();
- }
- catch (e)
- {
- // Internet Explorer
- try
- {
- xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
- }
- catch (e)
- {
- xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
- }
- }
- return xmlHttp;
- }
php操作代碼如下:
- <?php
- $q=$_GET["q"];
- $q = urldecode($q);
- if (strlen($q) > 0)
- {
- $conn = @mysql_connect("localhost","root","1010") or die ("MySql連接錯(cuò)誤");
- mysql_select_db("xin",$conn);
- mysql_query("set names 'utf8'");
- $sql = "SELECT username FROM message WHERE username = '$q'";
- $query = mysql_query($sql);
- @$row = mysql_fetch_array($query);
- if(!emptyempty($row['username']))
- {//開(kāi)源軟件:Vevb.com
- $response = "<font color=red>已經(jīng)被注冊(cè)!</font>";
- }else
- {
- $response = "<font color=blue>恭喜!可以注冊(cè)!</font>";
- }
- echo $response;
- }
- ?>
最后再給出數(shù)據(jù)庫(kù)代碼:
- DROP DATABASE IF EXISTS `xin`;
- CREATE DATABASE `xin` /*!40100 DEFAULT CHARACTER SET utf8 */;
- USE `xin`;
- CREATE TABLE `message` (
- `id` int(11) NOT NULL auto_increment,
- `username` varchar(20) default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
新聞熱點(diǎn)
疑難解答