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. |
Welcome Guest, Not a member yet? Register Sign In |