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

WHY DOES ALUMNI MANAGEMENT SOFTWARE BOOST CULTURE AND PRODUCTIVITY?

WHY DOES ALUMNI MANAGEMENT SOFTWARE BOOST CULTURE AND PRODUCTIVITY?

HR departments throughout the world may benefit from making a deliberate long-term investment in alumni management software. People who have worked for a company in the past are valuable but are under

Read More
Benefits of a Website Redesign

Benefits of a Website Redesign

In today’s digital age, a website is often the first point of contact between a business and its potential customers. As trends and technologies evolve, it is crucial to ensure that your website

Read More
SEO vs. Paid Ads: Which Strategy Delivers Better Results?

SEO vs. Paid Ads: Which Strategy Delivers Better Results?

The long-running argument between SEO (Search Engine Optimization) and paid advertisements is still alive in digital marketing. Although increasing online visibility and driving traffic are the goals

Read More