After executing the mysql stored procedure commands out of sync; You can ' t run the This command now

PHP calls the stored procedure and then executes SQL to prompt commands out of sync; Can ' t run this command now, what is the problem?

Reply content:

PHP calls the stored procedure and then executes SQL to prompt commands out of sync; Can ' t run this command now, what is the problem?

To solve this problem, we need to use Mysqli's Multi_query method

  
   ';$mysqli->autocommit(FALSE);if ($mysqli->multi_query("call test1();")) {    do {        if ($result = $mysqli->store_result()) {            while ($row = $result->fetch_row()) {                printf("%s\n", $row[0]);            }            $result->close();        }    } while ($mysqli->next_result());}$mysqli->commit();echo "
";echo "result2:
";if ($result2 = $mysqli->query("select val from tb1;")) {    while ($row = $result2->fetch_row()) {        
", $row[0]);    }    $result2->close();}else{    

