How to get last insert ID in PHP Codeigniter?




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.
$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
Blog Category
Related Posts

How to fix OpenCart missing icons problem
Very simple solution to fix the icon missing problem in opencart which is due to domain address. The
Read More
How to Use Google Font in the WordPress website
In this blog post, we are going to explain how to use Google font in a WordPress website. We are goi
Read MoreConvert base64 Data to image file and write To folder in PHP
In this post, I will be able to allow you to skills to handle the pictures encoded with Base64 and c
Read More