Get last insert id?

straker

I am using the insert method:

$this->examples_model->insert('values')

on an table with id as the autoincrement primary key.

How can I retrieve the new id that was inserted? Equivalent to PHP's mysql_insert_id() function.

Thanks in advance.

admin

CodeIgniter has a $this->db->insert_id() method. In your case you could do the following:
$this->examples_model->db()->insert_id();
Alternatively, if you use MY_Model's "save" method instead, it will automatically return the insert_id:
$id = $this->examples_model->save($values);

straker

Great! Thanks. save() looks like the better option.