- get last insert id after insert query in codeigniter active record 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();