eCommerce Marketplace Development
Assemble your own Marketplace today like Amazon, eBay, Souq style retail Online Shopping Store. Web-based business is the quickest developing retail advertise in Asia, Europe, the Americas, and around
Read More
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;
}
$input = ['name'=>'blazing coders', 'email'=>'info.blazingcoders@gmail.com'];
$this->db->insert('users', $input);
$insertId = $this->db->insert_id();
return $insertId;
}
Related Posts
A
Automation Testing Company in India
The world is heading towards automation, it has it’s strong footsteps in Software testing as well. We at Blazingcoders perform automation testing with various tools such as Junit, Selenium, QTP/
Read More
Codeigniter website speed optimization
In this article, we are going to discuss Steps to follow the Codeigniter website optimizer. We are Web development, Software development, and Mobile application development company for many organizati
Read More