$studentArray= implode(',', json_decode($result[$i]));
$tempStudent = Array();
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
while($row =$allStudentArray->fetch_assoc()){
$tempStudent[] = $row;
}
$returnApi[$i] = $tempStudent;报错信息是:Fatal error: Call to a member function fetch_assoc() on boolean in D:\xampp\htdocs\xxx\three\f
查了很长时间没找到怎么回事我尝试:
1、$studentArray= implode(',', json_decode($result[$i]));
$tempStudent = Array();
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
print_r($allStudentArray); //输出查询
while($row =$allStudentArray->fetch_assoc()){
$tempStudent[] = $row;
}
结果是:mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 3 [type] => 0 ) mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 2 [type] => 0 )
Fatal error: Call to a member function fetch_assoc() on boolean in D:\xampp\htdocsxxx\three\f
已经查询到值,但是为什么循环呢
2、我又尝试 $studentArray= implode(',', json_decode($result[$i]));
$tempStudent = Array();
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
echo json_encode($row =$allStudentArray->fetch_assoc());
echo json_encode($row =$allStudentArray->fetch_assoc());
echo json_encode($row =$allStudentArray->fetch_assoc());
echo json_encode($row =$allStudentArray->fetch_assoc());
while($row =$allStudentArray->fetch_assoc()){
$tempStudent[] = $row;
}
输出结果是:{"id":"1","name":"\u54c8\u54c8"}{"id":"2","name":"12"}{"id":"3","name":"12"}null{"id":"1","name":"\u54c8\u54c8"}{"id":"3","name":"12"}nullnull
Fatal error: Call to a member function fetch_assoc() on boolean in D:\xampp\htdo
这个值是正确的,因为WHERE id IN (".$studentArray.") 中的$studentArray = 1,2,3 , 值都查出来,就是无法输出
这到底是怎么回事,我查了好久也没看出来是怎么回事,求告知。谢谢
$tempStudent = Array();
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
while($row =$allStudentArray->fetch_assoc()){
$tempStudent[] = $row;
}
$returnApi[$i] = $tempStudent;报错信息是:Fatal error: Call to a member function fetch_assoc() on boolean in D:\xampp\htdocs\xxx\three\f
查了很长时间没找到怎么回事我尝试:
1、$studentArray= implode(',', json_decode($result[$i]));
$tempStudent = Array();
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
print_r($allStudentArray); //输出查询
while($row =$allStudentArray->fetch_assoc()){
$tempStudent[] = $row;
}
结果是:mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 3 [type] => 0 ) mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 2 [type] => 0 )
Fatal error: Call to a member function fetch_assoc() on boolean in D:\xampp\htdocsxxx\three\f
已经查询到值,但是为什么循环呢
2、我又尝试 $studentArray= implode(',', json_decode($result[$i]));
$tempStudent = Array();
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
echo json_encode($row =$allStudentArray->fetch_assoc());
echo json_encode($row =$allStudentArray->fetch_assoc());
echo json_encode($row =$allStudentArray->fetch_assoc());
echo json_encode($row =$allStudentArray->fetch_assoc());
while($row =$allStudentArray->fetch_assoc()){
$tempStudent[] = $row;
}
输出结果是:{"id":"1","name":"\u54c8\u54c8"}{"id":"2","name":"12"}{"id":"3","name":"12"}null{"id":"1","name":"\u54c8\u54c8"}{"id":"3","name":"12"}nullnull
Fatal error: Call to a member function fetch_assoc() on boolean in D:\xampp\htdo
这个值是正确的,因为WHERE id IN (".$studentArray.") 中的$studentArray = 1,2,3 , 值都查出来,就是无法输出
这到底是怎么回事,我查了好久也没看出来是怎么回事,求告知。谢谢
解决方案 »
- 一个很简单的保存数据保存不了。。。请大家帮忙。。。。。。
- 请问这句话有什么错误$ygeo = unserialize($ygeo);
- 关于DOMDocument的一个简单问题 load
- 在线求助
- 通过页面中select下拉菜单的改变来改变本页中iframe中的table中数据的改变
- 如何在php中得到环境变量upload_max_filesize的值?
- 一个有点难度的问题;怎样用PHP实现象windows的帮助文档内的索引查询功能(输入某字符后自动显示关于该字的项目)
- 请问如何一次将几个文件下载到本地硬盘?
- 大家来讨论现在的网页制作技术怎样创新?
- 只有10M内存,但是有10000000个人准备签到,id是1-10000000,给出解决方案
- 用editplus打开这个php,点击按钮显示脚本错误:没有注册类
- TP3.23,->uploadOne和->create()运行提示错误,但执行结果
$allStudentArray 不存在 fetch_assoc() 方法,因为他是逻辑值
这就表示你的查询失败了:
$allStudentArray = $mysqli->query("SELECT `id`,`name` FROM `student` WHERE id IN (".$studentArray.") ");
你可以 echo $mysqli->error; 看看是什么情况你所谓的查了好久,只是在变化代码,做文字游戏
并没有溯根求源,根据错误信息追踪下去
并自信的称 sql指令没有问题
殊不知,出现那个错误的原因就是 sql指令错了