CodeIgniter Forums
A model that calls a store procedure that returns multipal tables - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: A model that calls a store procedure that returns multipal tables (/showthread.php?tid=91093)



A model that calls a store procedure that returns multipal tables - DanielCollins - 06-15-2024

Hello.
Hope your well.
I am fairly new to PHP frameworks. But I have a project I'm doing where I need to call a store procedure that returns multipal tables.  I have no issues setting up the model and the call is working, but the issue is the multipal tables being returned I can only ever access the first table, there is meant to be 11 tables being returned and the store procedure works as expected but when I try and put the tables into an array of tables I only ever get the first table.

I have tried a few things like looping through the response, using the Mysqli_next_result. But nothing works.
Codeignitor V4.4.4
Running on cyberpanel open light speed server. For "production"  just using spark for testing.
Any ideas on how to fix this would be great.