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