how to get last insert id after insert query in codeigniter active record

Question

I have an insert query  active record style  used to insert the form fields into a MySQL table  I want to get the last auto-incremented id for the insert operation as the return value of my query but I have some problems with it   Inside the controller   function add post         post data   array           id               gt               user id      gt    11330            content      gt    this- gt input- gt post  poster textarea             date time    gt  date  Y-m-d H i s             status           gt    1             return  this- gt blog model- gt add post  post data       And inside model   function add post  post data        this- gt db- gt trans start         this- gt db- gt insert  posts   post data        this- gt db- gt trans complete        return  this- gt db- gt insert id        I get nothing as the return of the add post in model

User · Answer

because you have initiated the Transaction over the data insertion so, The first check the transaction completed or not. once you start the transaction, it should be committed or rollback according to the status of the transaction;

function add_post($post_data){
  $this->db->trans_begin() 
  $this->db->insert('posts',$post_data);
  $this->db->trans_complete();
  if ($this->db->trans_status() === FALSE){
    $this->db->trans_rollback();
    return 0;
  }else{
    $this->db->trans_commit();
    return $this->db->insert_id();
  }
}``

in the above, we have committed the data on the successful transaction even you get the timestamp

User · Answer

Inside Model   function add info  data       this- gt db- gt insert  tbl user info   data       last id    this- gt db- gt insert id       return   last id       Inside Controller   public function save user record        insertId     this- gt welcome model- gt save user info  data     echo  insertId- gt id

User · Answer

Just to complete this topic  If you set up your table with primary key and auto increment you can omit the process of manually incrementing the id   Check out this example  if    CI- gt db- gt table exists db prefix      my table name           CI- gt db- gt query  CREATE TABLE      db prefix      my table name       serviceid  int 11  NOT NULL PRIMARY KEY AUTO INCREMENT     name  varchar 64  NOT NULL     hash  varchar 32  NOT NULL     url  varchar 120  NOT NULL     datecreated  datetime NOT NULL     active  tinyint 1  NOT NULL DEFAULT  1    ENGINE InnoDB DEFAULT CHARSET      CI- gt db- gt char set           Now you can insert rows   this- gt db- gt insert db prefix     my table name                  name            gt   data  name                 hash               gt  app generate hash                 url        gt   data  url                 datecreated        gt  date  Y-m-d H i s                 active             gt   data  active

User · Answer

Try this  function add post  post data       this- gt db- gt insert  posts    post data       insert id    this- gt db- gt insert id        return   insert id      In case of multiple inserts you could use    this- gt db- gt trans start     this- gt db- gt trans complete

User · Answer

id    this- gt db- gt insert id

User · Answer

A transaction isn t needed here  this should suffice   function add post  post data         this- gt db- gt insert  posts   post data       return  this- gt db- gt insert id

User · Answer

Using the mysqli PHP driver  you can t get the insert id after you commit   The real solution is this   function add post  post data      this- gt db- gt trans begin       this- gt db- gt insert  posts   post data       item id    this- gt db- gt insert id       if   this- gt db- gt trans status       FALSE            this- gt db- gt trans rollback        return  0          else          this- gt db- gt trans commit        return   item id            Source for code structure  https   codeigniter com user guide database transactions html running-transactions-manually

User · Answer

From the documentation    this- gt db- gt insert id   The insert ID number when performing database inserts   Therefore  you could use something like this   lastid    this- gt db- gt insert id

User · Answer

You must use  lastId    this- gt db- gt insert id

[mysql] how to get last insert id after insert query in codeigniter active record

Examples related to mysql

Examples related to codeigniter