Hire Web Developer & Web Designers Delhi
We are Experts from Delhi, India providing highly professional Web developer in Delhi location. We provide Software developer and Web programmer to work on your projects and provide 24 * 7 develo
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
H
Advantages and Disadvantages of Choosing WordPress as Your CMS Solution
In the digital age, selecting the right Content Management System (CMS) is crucial for businesses aiming to establish a strong online presence. WordPress, a leading CMS, powers over 40% of websites gl
Read MoreC
Convert 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 convert the pictures to a folder. While working with API for app, you'll notice that they'
Read More