How to get last insert ID in PHP Codeigniter?

Breadcrumb Breadcrumb

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;
}

Confused about your business model?

Request a FREE Business Plan.

India +91 ▼

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

What Is AR/VR Technology? A Beginner’s Guide to the Future of Innovation
AR/VR |

What Is AR/VR Technology? A Beginner’s Guide to the Future of Innovation

The fields of virtual reality (VR) and augmented reality (AR) are no longer limited to science fiction films; they are actively influencing industries, improving user experiences, and spurring innovat

Read More
H
Hire Us | Web Development | Web Design |

Hire Web Developer & Web Designers Mumbai

We are Experts from Mumbai, India providing highly professional Web developer in Mumbai location. We provide Software developer and Web programmer to work on your projects and provide 24 * 7 deve

Read More
Barcode not printing and not scanning properly in zebra direct thermal printer
eCommerce |

Barcode not printing and not scanning properly in zebra direct thermal printer

When printing barcodes to a printer of less than 600dpi, the printer may not accurately reproduce the exact bar and space ratios which can result in a read error on the barcode scanner or verifier.

Read More