呵呵, Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\hosting\member\wanrenqingko\dream\ticket\info.php on line 39 有错!!! 另: xmlhttp.open("GET","db.php?username="+escape(document.getElementById("username").value),true); 最好用false用true是同步而不是异步
得出了错误信息: SELECT * FROM users WHERE username='test' Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\hosting\member\wanrenqingko\dream\ticket\db.php on line 18 此用户名未被注册!在mysql admin, run sql命令时没问题啊,见图:
$strsql="SELECT * FROM users WHERE username='".$_GET["username"]."'";
echo $strsql;
$result=mysql_query($strsql);
$rows=mysql_num_rows($result);
echo $rows;
mysql_close($conn);
var xmlhttp=false;
if(window.XMLHttpRequest){
xmlhttp = new XMLHttpRequest();
} else if(window.ActiveXObject){
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
} else {
return xmlhttp;
}
xmlhttp.onreadystatechange = function(flag){
if (xmlhttp.readyState==4){
if (xmlhttp.status==200){
CheckUserName(xmlhttp.responseText,flag);
}
}
}
xmlhttp.open("GET", url, true);
xmlhttp.send(null);
}function CheckUserName(request,flag)
{
alert(request);
}
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\hosting\member\wanrenqingko\dream\ticket\info.php on line 39
有错!!!
另:
xmlhttp.open("GET","db.php?username="+escape(document.getElementById("username").value),true);
最好用false用true是同步而不是异步
SELECT * FROM users WHERE username='test'
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\hosting\member\wanrenqingko\dream\ticket\db.php on line 18
此用户名未被注册!在mysql admin, run sql命令时没问题啊,见图:
可见这个测试页面: http://wanrenqingko.mysite4now.com/ticket/false.html
这里面有,我上次写了一篇原创文章
/*数据库连接*/
$conn=@mysql_connect("***.mysite4now.com","want****","****");
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 users WHERE username='".$_GET["username"]."'"; echo $strsql;
$result=mysql_query($strsql);
$rows=mysql_num_rows($result);
echo $rows;
mysql_close($conn);
//判断是否有此记录
if($rows){
echo "已被注册!";
}else{
echo "此用户名未被注册!";
}
}else{
echo "别调戏我!";
}
?>
http://wanrenqingko.mysite4now.com/ticket/checkuserid.asp