Doubt in Insert, update and delete with Codeigniter Framework?

Question

I have a question related to insertion, alteration and removal of records in the Mysql database. For example, imagine a banknote table, where all the information in that note is recorded, such as supplier data, carrier data and taxes to be collected. And we also have a nota_items table, where the items of this note will be inserted. Well, in structured PHP, I would do it like this: First I would do an INSERT to register the data of the note table and then I would do another INSERT to register the data of the nota_items table with the last id of the note table in the nota_items table referencing the two tables. My question is the following, in the Codeigniter Framework is there any mechanism or function that does this automatically? Or will I have to implement the same idea of structured PHP? I hope I have been clear in my doubt and thank you already!

Answer 1

I believe that there is no way, you will have to do both Inserts, it is even easier using the functions passed by Andrew Maxwell and GWER

Answer 2

Try to use the last_insert_id();

The function of Mysql last_insert_id() returns the last integer created for a column auto_increment of a table. This integer is available in the memory cache that Mysql uses to store column values auto_increment, thus generating the sequence.

See here : http://php.net/manual/en/function.mysql-insert-id.php

PDO: http://php.net/manual/en/pdo.lastinsertid.php

Answer 3

Yes, there is a function of the database that does this procedure $this->db->insert_id(), it takes the last id registered in the database. Vlw