基于php+ajax的注册用户名验证

最新推荐文章于 2018-08-15 16:00:34 发布

tukidrmyd

最新推荐文章于 2018-08-15 16:00:34 发布

阅读量3.1k

点赞数

文章标签： ajax php xmlhttprequest mysql function input

reg.htm

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<META HTTP-EQUIV="expires" CONTENT="0">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<title>PHP+AJAX注册用户名验证</title>
<style type="text/css">

</style>
<script type="text/javascript">

</script>
</head>

<body>
    <div id="login">
        <h1>PHP+Ajax</h1>
        <form id="frmlogin" name="frmlogin">
          <label>用户名:
          <input name="username" type="text" id="username" size="22" maxlength="10" οnblur="chkUserName(this)" />
          </label><label id="tip"></label>
            <p>
               <label>密　码:
               <input name="pwd" type="password" id="pwd" size="24" maxlength="16" />
               </label>
      </p>
            <p align="center">
               <input name="Submit" type="button" class="button" id="btn_login" style="width:60px;background:#efefef;height:25px;line-height:25px;font-size:12px;" value="注册" />
               <input name="Submit2" type="reset" class="button" style="width:60px;background:#EFEFEF;height:25px;line-height:25px;font-size:12px;" value="重置" />
            </p>
      </form>

</div>
</body>
</html>

服务器端db.php

<?php
    /*数据库连接*/

    $conn=@mysql_connect("localhost","root","");
    mysql_query("SET NAMES UTF8");
    mysql_select_db("php_ajax",$conn);

    //设置页面编码
    header("Content-type:text/html;charset=UTF-8");

    //查询数据库
    if(isset($_GET["username"])){
        $strsql="SELECT * FROM member WHERE username='".unescape($_GET["username"])."'";
        $result=mysql_query($strsql);
        $rows=@mysql_num_rows($result);
        mysql_close($conn);

        //判断是否有此记录
        if($rows){
            echo "已被注册!";
        }else{
            echo "此用户名未被注册!";
        }
    }else{
        echo "别调戏我!";
    }

    /*PHP的unescape转换函数,用来转换Javascript用escape函数加密过的字符
    --此函数需要iconv函数库支持*/

    function unescape($str) {
        $str = rawurldecode($str);
        preg_match_all("/%u.{4}|&#x.{4};|&#/d+;|&#/d+?|.+/U",$str,$r);
        $ar = $r[0];
        foreach($ar as $k=>$v) {
            if(substr($v,0,2) == "%u")
                $ar[$k] = iconv("UCS-2","UTF-8",pack("H4",substr($v,-4)));
            elseif(substr($v,0,3) == "&#x")
                $ar[$k] = iconv("UCS-2","UTF-8",pack("H4",substr($v,3,-1)));
            elseif(substr($v,0,2) == "&#") {
                $ar[$k] = iconv("UCS-2","UTF-8",pack("n",preg_replace("/[^/d]/","",$v)));
            }
        }
        return join("",$ar);
    }
?>

sql

CREATE TABLE `member` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `pwd` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- 导出表中的数据 `member`
--

INSERT INTO `member` VALUES (8, 'admin', 'admin888');
INSERT INTO `member` VALUES (9, '测试', '测试');

tukidrmyd

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
基于php+ajax的注册用户名验证

reg.htmPHP+AJAX注册用户名验证body{ text-align:center; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; background:#EFEFEF;}#login { margin-top:6%; margin-right:auto;
复制链接

扫一扫