Welcome Guest, Not a member yet? Register   Sign In
Running Stored Procedures...

Hi Folks...

Ran into an error when executing stored MySQLi procedures.
Error:  "Commands out of sync; you can’t run this command now"

A solution can be found  here

My question:
Why is the function next_result() still not added to \system\database\drivers\mysqli\mysqli_result.php ?
Code below ...

Guess this will solve a lot of probs for a lot of devs ...

PHP Code:
   * Read the next result
   * @return  null
function next_result() {
    if (is_object($this->conn_id))
      return mysqli_next_result($this->conn_id);

had the same problem...add nextresult to core mysql and all your queries got to have $query->next_result() and preferably free_result afterwords. a small setup in CI design.

This topic comes up all the time. Maybe Narf can come up with a good solution for everyone.

Is it possible to simulate next_result() with pdo driver?

Theme © iAndrew 2016 - Forum software by © MyBB