How to get last insert ID in PHP Codeigniter?

In this article, we are going to discuss how to get the last inserted ID in Codeigniter. I will let you know how to get the 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 the second table to create a relation between both tables.

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

In Codeigniter, You can use $this->db->insert_id(); function to get the last inserted ID.

insert_id() is function of "db" library. There is a number of query helper methods in Codeigniter.

function saveUserInfo(){
   $input = ['name'=>'blazing coders', 'email'=>'info.blazingcoders@gmail.com'];
   $this->db->insert('users', $input);
   $insertId = $this->db->insert_id();
   return  $insertId;
}

Tags

  • How to get last insert id in Codeigniter controller

  • Get last row id in Codeigniter

  • How to get last inserted record in Codeigniter

  • Last insert id in Codeigniter 4
  • How to insert id from one table to another in Codeigniter
  • Codeigniter get next auto-increment id

  • How to get last updated id in Codeigniter

  • Codeigniter get next id

  • PHP MySQL last insert id how to get last inserted id in PHP Codeigniter
  • Mysql select last insert id from the table
  • How to get the last record in MySQL using PHP

  • How to get last inserted id in SQL

  • How to get last inserted record in MySQL

  • How to get last updated record id in PHP
  • Pdo last insert id returns 0

Related Posts

Top 10 Mobile App Development Companies in California, USA (2026)

Top 10 Mobile App Development Companies in California, USA (2026)

Are you confused about how to choose the best Mobile App Development Company in USA for your business idea? With hundreds of companies offering similar services, finding the right partner who truly un

Read More
Smart Real Estate App Development to Boost Property Sales

Smart Real Estate App Development to Boost Property Sales

In today's technologically advanced world, the real estate sector is changing dramatically. Buyers no longer hold out for printed brochures or property fairs. They demand real-time information at

Read More
How to Send Email in Laravel using SMTP

How to Send Email in Laravel using SMTP

Today we are going to explain how to send email in Laravel using STMP. Laravel is PHP based framework that comes with a simple API to send emails via SMTP from localhost or Hosted online. You can

Read More