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.

Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3

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