Welcome Guest, Not a member yet? Register   Sign In
working w/stored proc that return multiple result sets

(12-07-2015, 03:43 PM)skunkbad Wrote: You should be able to call more than one stored procedure, just by calling ->next_result(). I'm not sure if CI3 has ->next_result(), but if it doesn't you will need a hack:
PHP Code:

This is the only system hack, and was necessary because CodeIgniter
does not currently allow more than one stored procedure to be run 
during the same request.

The following method was added to the CI_DB_mysqli_result class:*/

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

// -------------------------------------------------------------------- 

thanks! I'll give it a go and see what happens tonight...

And on the pedestal these words appear:
'My name is Ozymandias, king of kings:
Look on my works, ye Mighty, and despair!'
Nothing beside remains. Round the decay
Of that colossal wreck, boundless and bare
The lone and level sands stretch far away.

Messages In This Thread
RE: working w/stored proc that return multiple result sets - by ozzy mandiaz - 12-07-2015, 04:26 PM

Theme © iAndrew 2016 - Forum software by © MyBB