<!DOCTYPE html>
<html>
<head>
<title> </title>
<meta charset='utf-8'>
</head>
<body>
<input type="text" id='name'>
<span id="tip"></span><br/>
<input type='button' value="注册">
</body>
<script>
var inp = document.getElementById('name');
inp.onblur = function(){
var v = this.value;
// console.log(v);
var xhr = new XMLHttpRequest();
xhr.onreadystatechange = function(){
if (xhr.readyState == 4) {
var res = xhr.responseText;
// console.log(res);
if (res==1) {
var h = '<font color="red">用户名已存在</font>';
}else{
var h = '<font color="green">恭喜您,用户名可以使用</font>';
}
document.getElementById('tip').innerHTML = h;
}
}
xhr.open('get','ajaxlogin.php?name='+v);
xhr.send();
}
</script>
</html>
<?php
$name = $_GET['name'];
$con = mysqli_connect('localhost','root','root','mydb1');
$sql = "select ename from emp where ename = '$name'";
$res = mysqli_query($con,$sql);
$row = mysqli_fetch_assoc($res);
// var_dump($row) ;
if ($row) {
echo 1;
}else{
echo 0;
}
?>