Question

php初学者，遇到调用存储过程的问题，求大神解答Warning: mysqli_fetch_array() expects parameter 1 to be

<?php
$db = new mysqli('localhost','root','','my');
if (mysqli_connect_errno()){
echo 'Can not connect to MySQL server';
}
$db->query("SET NAMES gbk");

$result =mysqli_query($db,"call sp_select2(2)");
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
{echo $row['Customer_name'];}
$result =mysqli_query($db,"call sp_select2(2)");
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
{echo $row['Customer_name'];}

?>

报错Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result
为什么不能连续两次调用

Answer 1

你数据库是不是封装了一个类呀，你不是都有数据库对象了吗。怎么还用 $result =mysqli_query($db,"call sp_select2(2)");

Answer 2

mysqli_fetch_array 有这个吗？还是mysql_fetch_array