php ajax 实现用户登录 - 中国源码教程网

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" onblur="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, '测试', '测试');