How do I reference a row immediately after it has been added to a table?

Question

This is PHP / CodeIgniter / MySQL

The only way I can think of is to do the insert ($this->db->insert(...)), and then immediatly after, run another query to find the record again.

I'm hoping there is something (which seems a bit more efficient to me) that returns the primary key (or something) of the newly added record.

I don't know about codeigniter, but usually there is a function like `lastInsertId()` — TheNytangel, Sep 27 '13 at 02:16
`mysqli_insert_id()` will give you the id of the last inserted row. — Source, Sep 27 '13 at 02:17
For CodeIgniter, it seems to be [`$this->db->insert_id()`](http://ellislab.com/codeigniter/user-guide/database/helpers.html) — jedwards, Sep 27 '13 at 02:18
CodeIgniter is incredibly well documented. If you are going to use CodeIgniter then there are no excuses for not taking advantage of it. — Sverri M. Olsen, Sep 27 '13 at 02:53

score 2 · Accepted Answer · answered Sep 27 '13 at 02:18

2

For codeigniter

$this->db->insert_id()

answered Sep 27 '13 at 02:18

Leetbulb

score 0 · Answer 2 · edited Apr 01 '14 at 09:56

0

Have a look at here http://ellislab.com/codeigniter/user_guide/database/helpers.html and the first function is $this->db->insert_id();

This also works with activerecord inserts.

or you can do

$last_insert_id = $this->db->call_function('insert_id');

edited Apr 01 '14 at 09:56

Kumar V

answered Sep 27 '13 at 03:15

Suvash sarker

2 Answers2