CodeIgniter activerecord retrieve last insert id

Question

Are there any options to get the last insert id of a new record in CodeIgniter    last id    this- gt db- gt insert  tablename       array  firstcolumn    gt   value        secondcolumn    gt   value        Considering the table consits of fields id  autoincrement  firstcolumn and secondcolumn   This way you can use the insert id in the following code

User · Answer

Last insert id means you can get inserted auto increment id by using this method in active record,

$this->db->insert_id() 
// it can be return insert id it is 
// similar to the mysql_insert_id in core PHP

You can refer this link you can find some more stuff.

Information from executing a query

User · Answer

for Specific table you cannot use  this- db- insert id     even the last insert happened long ago it can be fetched like this  may be wrong  but working well for me        this- gt db- gt select max   primary key           result   this- gt db- gt get   table   - gt row array         echo  result   primary key

User · Answer

this- gt db- gt insert id      Returns the insert ID number when performing database inserts  Query Helper Methods for codeigniter-3

User · Answer

this- gt db- gt insert id     Try this As your desired question

User · Answer

Try this   public function insert data function  your data         this- gt db- gt insert  your table   your data        last id    this- gt db- gt insert id        return  last id

User · Answer

After your insert query  use this command  this- gt db- gt insert id    to return the last inserted id   For example    this- gt db- gt insert  Your tablename    your data     last id     this- gt db- gt insert id     echo  last id    assume that the last id from the table is 1  after the insert query this value will be 2

User · Answer

In codeigniter 3  you can do it as follow   if  this- gt db- gt insert  table name   table data          inserted id    this- gt db- gt insert id        return  inserted id      You may get help for Codeigniter 3 from here https   codeigniter com user guide database helpers html  In Codeigniter 4  you can get last inserted id as follow    builder    db- gt table  your table name    if  builder- gt insert  table data          inserted id    db- gt insertID        return  inserted id      You may get help for Codeigniter 4 from here https   codeigniter4 github io userguide database helpers html

User · Answer

if  this- gt db- gt insert  Your tablename    your data         return  this- gt db- gt insert id      return false

User · Answer

Shame on me     I looked at the user guide and the first function is  this- gt db- gt insert id     This also works with activerecord inserts     EDIT  I updated the link

User · Answer

this- gt db- gt insert id         please try this

User · Answer

List of details which helps in requesting id and queries are  For fetching Last inserted Id  This will fetching the last records from the table   this- gt db- gt insert id       Fetching SQL query add this after modal request   this- gt db- gt last query

[php] CodeIgniter activerecord, retrieve last insert id?

Examples related to php

Examples related to codeigniter