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

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);
 
    }
 
  
Reply
#2

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.
Reply
#3

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

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




Theme © iAndrew 2016 - Forum software by © MyBB