Advnatages of HTML5
Ever-increasing usage of mobile devices not just by individuals but the enterprises to have created a strong need for businesses to enable support for the mobile workforce, both in the B2B and B2C com
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;
}
Confused about your business model?
Request a FREE Business Plan.
+91 ▼ Related Posts
Why Every Travel Agency Needs a Custom Website Design
Everyone enjoys travel and travel becomes a hobby to the peoples over all the world. Travelers are increased repeatedly. While the initial thoughts of the journey arise in the mind, Peoples will sourc
Read More
Tips To Hire A Web Development Company
Given the pace of technological advancements and highly-competitive business landscape, having a digital presence is a mandate for businesses to gain visibility and to ensure sustainability. A website
Read More