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

mysql codeigniter

Try this

function add_post($post_data){   $this->db->insert('posts', $post_data);   $insert_id = $this->db->insert_id();   return  $insert_id;}

In case of multiple inserts you could use

$this->db->trans_start();$this->db->trans_complete();

mysql codeigniter

A transaction isn't needed here, this should suffice:

function add_post($post_data) {    $this->db->insert('posts',$post_data);    return $this->db->insert_id();}

mysql codeigniter

$id = $this->db->insert_id();

CodeHunter