How to get last insert id in PHP Codeigniter?

How to get last insert id in PHP Codeigniter?

In this PHP Codeigniter Tutorial, I will let you know how to get last inserted id from the table.

Sometimes, You have to work on relational tables where you perform the insert query on a table and you need that automatically generated ID to insert into second table to create relation between both tables.

In PHP, you can use mysqli_insert_id function to get the last inserted ID.

In Codeigniter, You can use insert_id() function to get latest auto incremented column value from the MySQL table.

insert_id() is function of "db" library. There are numbers of query helper method in Codeigniter.

Example :
function saveUserInfo(){
   $input = ['name'=>'Ajay Gupta', 'email'=>'ajay.agrahari09@gmail.com'];
   $this->db->insert('users', $input);
   $insertId = $this->db->insert_id();
   return  $insertId;
}

Phone: (+91) 8800417876
Noida, 201301
Attention Required! | Cloudflare

Sorry, you have been blocked

You are unable to access ressim.net

Why have I been blocked?

This website is using a security service to protect itself from online attacks. The action you just performed triggered the security solution. There are several actions that could trigger this block including submitting a certain word or phrase, a SQL command or malformed data.

What can I do to resolve this?

You can email the site owner to let them know you were blocked. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page.