mysql存储过程不能立即生效,出现错误“命令不同步，您无法立即运行命令”。在mysql / php中执行存储过程时...

I have written a stored procedure for a table, and after that i am executing queries for same table in php function, But i am getting error :

Error in db : Commands out of sync, you can't run the command now..

I tried mysqli: multi_query also instead of mysqli:query, but i got null output.

Can anyone please help me to sort out this problem.

P.S : stored proceure is working as expected and query are also correct.. but together it returns the error.

解决方案

You have to consume all selects, and navigate to next result

$sql="";

if (mysqli_multi_query($link, $sql)) {

do {

if ($result = mysqli_store_result($link)) {

while ($row = mysqli_fetch_array($result)) {

array_push($arrows,$row);

}

mysqli_free_result($result);

}

} while (mysqli_next_result($link));

}