![]() |
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. |