Welcome Guest, Not a member yet? Register   Sign In
MySQLi Library with Stored Procedures & Multiple result sets support
#7

[eluser]Tim Brownlaw[/eluser]
Well I'm now into returning multiple result sets back from my Stored Procedures.

The changes I had to make to mysqli_result.php work just dandy on my development PC.
It's when I put the site up onto my hosting account that things went upside down.

The calls to the Stored Procedures only return the 1st result set and ignore everything else.

Don't you hate that! It's kind of put my project into screaming halt mode!

So I wrote an extensive set of test scripts (using native PHP ) with installer for the demo tables and Stored Procedures up on the same hosting and it works a treat.

Native PHP = Works - Local and Host
CI Implementation - Work locally, Don't work on the Host.

The sample native PHP Code is up at http://www.webatories.com/testsp

I'll put up the CI changes as soon as I recover from my extensive messing around in the code and
provide the complete code for download when I get the chance.

I could go and try another framework but I'd rather contribute to CI as I kind of like even with it shortcomings. That's the whole point of this forum. To help make CI better.

Cheers
Tim Brownlaw


Messages In This Thread
MySQLi Library with Stored Procedures & Multiple result sets support - by El Forum - 04-04-2010, 06:07 PM



Theme © iAndrew 2016 - Forum software by © MyBB