Skip to main content

How to Get Last inserted ID in CodeIgnier?

We often need last inserted ID for different reasons(for example when you need to store foreign key), Immediately after a record has been inserted into the database, you can get the id that was auto incremented(primary Key).

Basic PHP MySQL Method


<?php
mysql_insert_id();
?>


simply call CodeIgniter method


<?php
$this->db->insert_id();?>
?>


That’s it!

Reference URL: http://codeigniter.com/user_guide/database/helpers.html

I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.