HOW TO GET LAST INSERTED ID FROM TABLE IN SQL IN CODEIGNITER code example
Example 1: return last insert id in codeigniter
$id = $this->db->insert_id();
Example 2: codeigniter return last inserted id
$this->db->insert('posts', $post_data);
$insert_id = $this->db->insert_id();
return $insert_id;