Hire Web Developer & Web Designers Chennai
Hire Web Developers & Web Designers Chennai To stay competitive in the digital age, companies need to have strong and easy-to-use websites. Professional web developers and designers turn to Bla
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
The Benefits of Alumni Management Software for Educational Institutions
Parents and students today are quite picky when selecting the best university. Campus tours and pamphlets are great indicators of an institution's caliber. Nevertheless, the most comprehensive sou
Read More
Understanding the Difference Between Web Development and Web Application Development
In the digital age, businesses and individuals are constantly searching for ways to enhance their online presence. This has led to the rise of web development and web application development as two co
Read More