How do you get the last insert ID in CakePHP 3.0?

Question

Working with the CakePHP 3.0 beta, seems like a simple problem, but I've searched through the docs and can't find anything. After inserting a new record using $this->Model->save(), I'd like to the get the auto_increment primary key ID of the newly created record.

With Cake 2.x, I could do:

$record_id=$this->ModelName->id;

or

$record_id=$this->ModelName->getLastInsertID();

However neither of those seems to work in CakePHP 3.0.

Thanks

score 33 · Answer 1 · answered Sep 24 '14 at 22:32

33

Finally found the answer, if anybody else runs into this do:

$result=$this->ModelName->save($whatever);
$record_id=$result->id;

answered Sep 24 '14 at 22:32

ben921

566
1
4
7

2

This is the the book here: http://book.cakephp.org/3.0/en/orm/saving-data.html#inserting-data – alecho May 30 '15 at 18:26
For me: `$record_id = $result['ModelName']['id']` – António Almeida Jul 01 '15 at 21:35
this certainly works best. Istead of saving inside the if, doing it one line above and just got if($result) – mewc Sep 04 '17 at 22:05

score 14 · Answer 2 · answered Oct 10 '15 at 16:57

14

to cakephp3.X I Found this:

if ($articlesTable->save($article)) {
    // The $article entity contains the id now
    $id = $article->id;
}

http://book.cakephp.org/3.0/en/orm/saving-data.html#inserting-data

answered Oct 10 '15 at 16:57

Elton Baroncello

141
1
2

Faisal · Answer 3 · 2017-09-10T07:45:33.047

7

You can solve this issue following way.

For CakePHP 3.x

$result = $this->ModelName->save($this->request->data);
$insertedId = $result->id;

For CakePHP 2.x

$this->ModelName->save($this->request->data);
$insertedId = $this->ModelName->getLastInsertId();

edited Sep 10 '17 at 07:45

answered Feb 28 '17 at 10:19

Faisal

4,591
3
40
49

1

`$insertedId = $this->ModelName->id;` is wrong for 3.x. Please change – Kim Stacks Sep 10 '17 at 03:43

score 2 · Answer 4 · answered Jan 07 '19 at 20:56

To get the identifier of the newly created registration cakePHP 3.x, it's very simple, just check if the entity was saved well, otherwise you will not have access to the identifier. The code is very simple

$this->loadModel('ModelName');
$newEntity = $this->ModelName->newEntity();

So after loading your model and declaring a new record, you can put the values on the entity before saving it. For example if it's a post request, you can do:

To proceed fields by fields:

$newEntity->name = $this->request->getData('name');

or (according to cakePHP version, first example is from the recent version)

$newEntity->name = $this->request->data('name');

Otherwise globally, in this case the name attributes of your fields in the form must be identical to the attributes of your entity in database.

$newEntity = $this->ModalName->patchEntity($newEntity, $this->request->getData());

And once the entity is ready, you will only have access to its identifier if it is registered in the database.

Solution to get the ID of the last record, you have to do this:

if($this->ModalName->save($newEntity) {
  //you can get ID here
  $id = $newEntity->id;
}

I hope it will be useful.

score 1 · Answer 5 · edited Jun 08 '15 at 08:33

1

$result=$this->ModelName->find('all',['fields'='id'])->last();

$record_id=$result->id;

edited Jun 08 '15 at 08:33

Limon Monte

52,539
45
182
213

answered Jun 08 '15 at 07:44

Naresh Dudhat

245
3
9

3

With this method we may get wrong ID if another thread / process / server / etc inserts at the same time. – t_motooka Sep 11 '16 at 00:02

score 1 · Answer 6 · answered Jun 08 '15 at 20:41

1

These work for the actually ORM model.

$result = $this->Model->save($data);
$id = $result->id;

answered Jun 08 '15 at 20:41

Manuel

99
4

score 0 · Answer 7 · edited Jun 07 '16 at 08:27

0

In CakePHP 3.0

$statement  = $query1->insert("columns of milestone");
$id =  $statement->lastInsertId('Milestones'); //Here it will return the last insert id

NOTE Milestones is the name of table

edited Jun 07 '16 at 08:27

A J

3,970
14
38
53

answered Jun 07 '16 at 07:28

Pankaj Sharma

112
12

score 0 · Answer 8 · answered Dec 12 '16 at 14:48

I've been struggling with this for quite a while before getting it to work. The save method will update the entity with the last insert id as long as the entity id is not already set. If you are creating a new record and the entity id is set to zero the save method will not update it so be sure that the entity id is not set:

$table = TableRegistry::get('MyModel');
$record = $table->newEntity($data);

// Unset the id if present and set to zero:
if (isset($record->id) && ($record->id==0)){
  unset($record->id);
}

if ($saved = $table->save($record)){
  $id = $record->id; // get the last insert id
}

Zetaphor · Answer 9 · 2017-09-16T02:10:48.310

-1

This is the only way I was able to get this to work correctly:

$result=$this->ModelName->save($whatever);
$record_id=$result['id'];

edited Sep 16 '17 at 02:10

answered Oct 21 '15 at 22:49

Zetaphor

504
10
24

score -1 · Answer 10 · edited Dec 02 '16 at 17:55

-1

This should work fine:

$entity = $this->MyModel->newEntity($this->request->data())
$result= $this->MyModel->save($entity);
$id = $result->id;

edited Dec 02 '16 at 17:55

maxshuty

9,708
13
64
77

answered Dec 02 '16 at 17:27

Rajesh Jangid

1
2

How do you get the last insert ID in CakePHP 3.0?

10 Answers10

Linked