php判定数据库是否有相同数据,JS 判断出数据库中是否有重复的ID

复制内容到剪贴板

代码:reg.htm

php+ajax注册用户名验证

php+ajax

用户名:

密　码:

服务器端db.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转换函数,用来转换javascrīpt用escape函数加密过的字符

--此函数需要iconv函数库支持*/

function unescape($str) {

$str = rawurldecode($str);

preg_match_all("/%u.{4}|.{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) == "")

$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, '测试', '测试');