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

User · Answer

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

User · Answer

You can access the id after calling the persist method of the entity manager    widgetEntity   new WidgetEntity     entityManager- gt persist  widgetEntity    entityManager- gt flush     widgetEntity- gt getId      You do need to flush in order to get this id   Syntax Error Fix  Added semi-colon after  entityManager- flush   is called

User · Answer

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- gt getConnection  - gt 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- gt getConnection  - gt lastInsertId  seqName    my sequence     For more information take a look at the code on GitHub here and here

User · Answer

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- gt getDoctrine  - gt getConnection             stmt    conn- gt prepare  query            stmt- gt execute             lastId    stmt- gt fetch    id            return  lastId          Another Function which call the above function  private function clientNum              lastId    this- gt 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

User · Answer

A bit late to answer the question  But    If it s a MySQL database  should  doctrine record object- gt id work if AUTO INCREMENT is defined in database and in your table definition

User · Answer

More simple  SELECT max id  FROM client

User · Answer

I had to use this after the flush to get the last insert id    em- gt persist  user    em- gt flush     user- gt getId

[php] Get the last insert id with doctrine 2?

Examples related to php

Examples related to orm

Examples related to doctrine

Examples related to lastinsertid