CI MySQLI Stored Procedure with Last Insert ID as output

So, a couple things...

First, this is CI4 support and you're using $this->db-> syntax, so what version are you using/trying to get help for?

Second, that seems like an overly complicated way to do what you're trying to do, why not use the query builder(https://codeigniter.com/user_guide/datab...ilder.html) and then call $this->db->insert_id()?

https://codeigniter.com/user_guide/datab...lpers.html

Lastly, if you're determined to use MySQL like this, you may find someone here that can help but, you'd probably be better served asking in a MySQL forum.

Enliven Applications - Open Blog is now Pubvana - CI4 Tutorials