CodeIgniter activerecord, retrieve last insert id?

Question

Are there any options to get the last insert id of a new record in CodeIgniter?

$last_id = $this->db->insert('tablename',
    array('firstcolumn' => 'value',
    'secondcolumn' => 'value')
);

Considering the table consits of fields id (autoincrement) firstcolumn and secondcolumn.

This way you can use the insert id in the following code.

I keep come to this question for several times. Thanks a lot! — giripp, Jan 15 '14 at 15:26

score 278 · Accepted Answer · edited Sep 02 '19 at 11:50

278

Shame on me...

I looked at the user guide and the first function is $this->db->insert_id();

This also works with activerecord inserts...

EDIT: I updated the link

edited Sep 02 '19 at 11:50

Nafiu Lawal

153
1
13

answered Dec 31 '09 at 16:16

Dennis Decoene

6,718
5
26
41

29

the userguide is your best friend for things like this. i have been using codeigniter for 2+ years and i still find functions like this that i never knew about. – Tom Schlick Jan 03 '10 at 10:02
8

Be sure to wrap your insert and this function in a transaction as the query scheduler may insert another object before running this function – parker.sikand Dec 04 '13 at 18:28
3

link is dead, updated link: http://ellislab.com/codeigniter/user-guide/database/helpers.html – womd Feb 11 '14 at 11:16
I need to use insert_id(), but i don't know that insert_id() granted to get ID belong to insert() before it! I mean, Is it possible to retrieve ID belong another insert() in another request? – N.M Jan 03 '17 at 06:07

score 37 · Answer 2 · edited Mar 16 '17 at 12:41

37

Last insert id means you can get inserted auto increment id by using this method in active record,

$this->db->insert_id() 
// it can be return insert id it is 
// similar to the mysql_insert_id in core PHP

You can refer this link you can find some more stuff.

Information from executing a query

edited Mar 16 '17 at 12:41

BackSlash

20,445
19
77
124

answered Feb 24 '14 at 07:01

Raja Ram T

814
8
8

link is not correct.please fix the link. new link http://www.codeigniter.com/userguide3/database/helpers.html – Shaiful Islam Feb 15 '15 at 03:02

score 11 · Answer 3 · edited Mar 17 '16 at 18:06

11

for Specific table you cannot use $this->db->insert_id() . even the last insert happened long ago it can be fetched like this. may be wrong. but working well for me

     $this->db->select_max('{primary key}');
     $result= $this->db->get('{table}')->row_array();
     echo $result['{primary key}'];

edited Mar 17 '16 at 18:06

David

1,137
4
19
27

answered Apr 07 '15 at 08:08

Infant Rosario

149
1
4

score 8 · Answer 4 · answered Jul 25 '17 at 10:57

8

List of details which helps in requesting id and queries are

For fetching Last inserted Id :This will fetching the last records from the table

$this->db->insert_id();

Fetching SQL query add this after modal request

$this->db->last_query()

answered Jul 25 '17 at 10:57

Madhur

1,239
3
21
36

score 7 · Answer 5 · edited Jan 03 '19 at 22:27

7

After your insert query, use this command $this->db->insert_id(); to return the last inserted id.

For example:

$this->db->insert('Your_tablename', $your_data);

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

echo $last_id // assume that the last id from the table is 1, after the insert query this value will be 2.

edited Jan 03 '19 at 22:27

Andrew Naguib

3,978
2
21
42

answered Jan 03 '19 at 22:11

Nikkolai Fernandez

81
1
4

score 6 · Answer 6 · answered Feb 24 '15 at 09:37

6

Try this.

public function insert_data_function($your_data)
{
    $this->db->insert("your_table",$your_data);
    $last_id = $this->db->insert_id();
    return $last_id;
}

answered Feb 24 '15 at 09:37

Raham

4,141
3
21
26

@Dennis Decoene you may also visit this link https://ellislab.com/codeIgniter/user-guide. – Raham Feb 24 '15 at 09:42

score 6 · Answer 7 · answered Jan 05 '16 at 11:08

6

$this->db->insert_id();

Try this As your desired question.

answered Jan 05 '16 at 11:08

Akash Tyagi

61
1
1

Shaiful Islam · Answer 8 · 2015-07-16T02:09:25.487

3

$this->db->insert_id();

Returns the insert ID number when performing database inserts

Query Helper Methods for codeigniter-3

edited Jul 16 '15 at 02:09

answered Feb 15 '15 at 02:51

Shaiful Islam

6,448
12
35
54

score 2 · Answer 9 · answered May 25 '18 at 09:38

2

$this->db->insert_id()

//please try this

answered May 25 '18 at 09:38

Girish Ninama

553
4
8

This duplicate answer adds no new value to the page. It should be removed. – mickmackusa May 10 '19 at 00:11

score 1 · Answer 10 · answered Apr 29 '15 at 08:33

1

if($this->db->insert('Your_tablename', $your_data)) {
    return $this->db->insert_id();
}
return false

answered Apr 29 '15 at 08:33

Nakendra Pun

41
2

score 0 · Answer 11 · answered Jan 30 '20 at 10:10

In codeigniter 3, you can do it as follow:

if($this->db->insert("table_name",$table_data)) {
    $inserted_id = $this->db->insert_id();
    return $inserted_id;
}

You may get help for Codeigniter 3 from here https://codeigniter.com/user_guide/database/helpers.html

In Codeigniter 4, you can get last inserted id as follow:

$builder = $db->table("your table name");
if($builder->insert($table_data)) {
    $inserted_id = $db->insertID();
    return $inserted_id;
}

You may get help for Codeigniter 4 from here https://codeigniter4.github.io/userguide/database/helpers.html

CodeIgniter activerecord, retrieve last insert id?

11 Answers11

Linked

Related