Get the last insert id with doctrine 2?

Question

How can I get the last insert id with doctrine 2 ORM? I didn't find this in the documentation of doctrine, is this even possible?

try this, at the end of your insert return the id... like return $this->id; — Manie, Aug 18 '10 at 06:13

score 187 · Accepted Answer · answered Aug 18 '10 at 08:34

187

I had to use this after the flush to get the last insert id:

$em->persist($user);
$em->flush();
$user->getId();

answered Aug 18 '10 at 08:34

tom

8,189
12
51
70

2

Cant use it. Getting error Call to undefined method Test\Entity\Test::getId() in "My Project" – noobie-php Jun 19 '13 at 19:40
@noobie-php You need to define a public getter for your Id (if this one is private as it should be) – cheesemacfly Aug 19 '13 at 17:04
@cheesemacfly: I already sorted this out this error is generated (in my scenario) when we are unable To flush() for any reason, once Flush() is executed successfully getID() starts working, assuming getter and setters are not a issue here – noobie-php Aug 20 '13 at 16:39
1

What if I `persist()` the entity in a loop and `flush()` after that? I'm trying to figure that out, but no luck so far. – Nat Naydenova Dec 17 '15 at 16:04
assign id to variable : `code` $id = $user->getId(); `code` – Josiah Jul 14 '17 at 10:22

score 46 · Answer 2 · edited Apr 19 '21 at 05:57

46

You can access the id after calling the persist and flush methods of the entity manager.

$widgetEntity = new WidgetEntity();
$entityManager->persist($widgetEntity);
$entityManager->flush();
$widgetEntity->getId();

You must call flush in order to get this id.

edited Apr 19 '21 at 05:57

Cave Johnson

6,499
5
38
57

answered Aug 20 '10 at 10:03

clarkstachio

613
4
8

score 35 · Answer 3 · edited Apr 24 '18 at 14:51

35

If you're not using entities but Native SQL as shown here then you might want to get the last inserted id as shown below:

$entityManager->getConnection()->lastInsertId()

For databases with sequences such as PostgreSQL please note that you can provide the sequence name as the first parameter of the lastInsertId method.

$entityManager->getConnection()->lastInsertId($seqName = 'my_sequence')

For more information take a look at the code on GitHub here and here.

edited Apr 24 '18 at 14:51

u_mulder

54,101
5
48
64

answered Nov 10 '14 at 16:24

Francesco Casula

26,184
15
132
131

This might not work with every DBMS. For instance it does not work with Postgres (because of sequences) – paul.ago Feb 01 '15 at 18:34
Awesome!! I spent hours looking for this little snippet. – MikeGA Apr 22 '15 at 21:33
4

@paul.ago You just need to know the name of the sequence, eg: `lastInsertId('articles_id_seq')` – ChocoDeveloper Apr 24 '15 at 16:33
2

You can also get the name of the sequence like this: `$conn = $this->getDoctrine()->getConnection();` `$metadata = $em->getClassMetadata('\App\Entity\YourClass');` `$seqName = $metadata->getSequenceName($conn->getDatabasePlatform());` Works :-) – Hugues D Oct 15 '19 at 20:35

score 10 · Answer 4 · answered Aug 19 '10 at 12:23

Calling flush() can potentially add lots of new entities, so there isnt really the notion of "lastInsertId". However Doctrine will populate the identity fields whenever one is generated, so accessing the id field after calling flush will always contain the ID of a newly "persisted" entity.

score 2 · Answer 5 · edited Nov 15 '16 at 15:29

2

A bit late to answer the question. But,

If it's a MySQL database

should $doctrine_record_object->id work if AUTO_INCREMENT is defined in database and in your table definition.

edited Nov 15 '16 at 15:29

Tomasz Kowalczyk

10,472
6
52
68

answered Dec 15 '10 at 12:53

Purasapa

29
1

kikemnzz · Answer 6 · 2021-08-22T14:56:55.583

2

In my case, as I declared $id as private I just created a new public method to get it.

public function getId() {
 return $this->id;
}

So then I could call it like so

    $user = new User();
    $user->setUsername("Kylo Ren");
    $entityManager = getEntityManager();
    $entityManager->persist($user);
    $entityManager->flush();
    echo "Created User with ID " . $user->getId() . "\n";

edited Aug 22 '21 at 14:56

answered Aug 22 '21 at 14:50

kikemnzz

103
5

score 0 · Answer 7 · answered Nov 15 '19 at 15:24

Here i post my code, after i have pushed myself for one working day to find this solution.

Function to get the last saved record :

private function getLastId($query) {
        $conn = $this->getDoctrine()->getConnection();
        $stmt = $conn->prepare($query);
        $stmt->execute();
        $lastId = $stmt->fetch()['id'];
        return $lastId;
    }

Another Function which call the above function

private function clientNum() {
        $lastId = $this->getLastId("SELECT id FROM client ORDER BY id DESC LIMIT 1");
        $noClient = 'C' . sprintf("%06d", $lastId + 1); // C000002 if the last record ID is 1
        return $noClient;
    }

score 0 · Answer 8 · edited May 05 '20 at 15:38

0

More simple: SELECT max(id) FROM client

edited May 05 '20 at 15:38

Julian

33,915
22
119
174

answered May 05 '20 at 15:05

Olivier Bussier

1

3

Not a good idea for concurrent and big systems. – Mahoor13 Feb 17 '21 at 10:56

Get the last insert id with doctrine 2?

8 Answers8

Linked

Related