How to get the last insert ID in Codeigniter, How to get the last insert ID in PHP

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.

+91

Tags

Related Posts

How to Create the Best Design for Smartphone Users?

How to Create the Best Design for Smartphone Users?

All users and Customers should be aware of the technology and its related products like smartphones, Hardware, Software, for designing a website, Mobile App Design. According to the website desig

Outsource ECommerce Development Company

Outsource ECommerce Development Company

In today’s competitive digital landscape, having a strong online presence is vital for businesses of all sizes. ECommerce websites are the backbone of modern retail, providing companies with a p

Animation Development Company

Animation Development Company

Blazingcoders is an Animation development company in India. We provide animation services to various type of industries. The animation is a creative concept of graphic representation within the sequen