+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: CodeIgniter 3.x (https://forum.codeigniter.com/forumdisplay.php?fid=17)
+--- Thread: Running Stored Procedures... (/showthread.php?tid=64147)
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?