CodeIgniter Forums
Running Stored Procedures... - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forum-6.html)
+--- Forum: CodeIgniter 3.x (https://forum.codeigniter.com/forum-17.html)
+--- Thread: Running Stored Procedures... (/thread-64147.html)



Running Stored Procedures... - johnny - 01-20-2016

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);
 
    }
 
  



RE: Running Stored Procedures... - sammyci - 02-20-2016

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.


RE: Running Stored Procedures... - skunkbad - 02-20-2016

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


RE: Running Stored Procedures... - dimas - 03-21-2017

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