A model that calls a store procedure that returns multipal tables |
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. |
Messages In This Thread |
A model that calls a store procedure that returns multipal tables - by DanielCollins - 06-15-2024, 10:42 PM
|