关于网友提出的“Call to a member function fetch_array on a non-object”问题疑问，本网通过在网上对“Call to a member function fetch_array on a non-object”有关的相关答案进行了整理，供用户进行参考，详细问题解答如下：
问题：Call to a member function fetch_array on a non-object
描述:mysql调试xamppphp
@session_start();
include_once("include/config.php");
include_once("include/mysqli.php");
$msg = "";
$sql = "select msg from k_notice where end_time>now() and is_show=1 and (siteID=0 or siteID='{$siteID}') order by `sort` desc,nid desc limit 0,1";
$query = $mysqli->query($sql);
while($rs = $query->fetch_array()){
$msg .= $rs['msg']." ";
}
调试网站只显示
Fatal error: Call to a member function fetch_array() on a non-object in C:\xampp\htdocs\home.php on line 8
第八行出错，改为
while( $rs=mysql_fetch_array()){
网站显示出来。
最上面依然显示出错
Warning: Wrong parameter count for mysql_fetch_array() in C:\xampp\htdocs\home.php on line 8
程序本身应该没错，是我环境上少了什么吗？
我环境PHP/5.2.9 MySQL 5.0.51a
解决方案1: $rs = $query->fetch_array()
这里$query什么都不是吧，应该用$mysqli这个对象调用
$msg = "";
$sql = "select msg from k_notice where end_time>now() and is_show=1 and (siteID=0 or siteID='{$siteID}') order by `sort` desc,nid desc limit 0,1";
$mysqli->query($sql);
while($rs = $mysqli->fetch_array()){
$msg .= $rs['msg']." ";
}
解决方案2: $query = $mysqli->query($sql) or die($mysqli->error());
解决方案3: $query 不是数组
应该是查询失败了。
$query = $mysqli->query($sql) or die(mysqli_error());
看看有什么错误
以上介绍了“Call to a member function fetch_array on a non-object”的问题解答，希望对有需要的网友有所帮助。
本文网址链接：http://www.codes51.com/itwd/1050839.html
