Symfony2: get the id of the persisted object

database symfony persistence entity
Miloš picture Miloš · Oct 18, 2012 · Viewed 32.8k times · Source

I have two entity: User and Person.

In the entity User I need the id of the associated person: user_id.

When I am creating a new user, I have to create first the person and then the user. In the user, I have to put the id of the corresponding person and for that I need to get the id of the persisted object person which is an auto increment.

Is it possible to get the id of the object after:

$em->persist($person);
$em->flush();

And how can I do this?

The alternative is to search the biggest id it the table Person and take this one but I think there should be a better and easier method to get the id of the persisted object.

In php for example, when I execute

$articleID = $_DB->queryRaw((....);

I am getting the id like that.

Answer

Habibillah picture Habibillah · Oct 18, 2012

Symfony2 with Doctrine as default ORM will automatically generate an ID after data stored in database. So you can call the ID by ->getId() 

$id = $person->getId();

Related questions

Generating a single Entity from existing database using symfony2 and doctrine

Is it possible to generate a single entity from database using the Symfony2 console tool? In the middle of coding I had to add a table and there are modifications made to the existing entity classes. So I don't want …

Read More
What do scale and precision mean when specifying a decimal field type in Doctrine 2?

I'm creating a decimal field to hold a financial figure in Doctrine2 for my Symfony2 application. Currently, it looks like this: /** * @ORM\Column(type="decimal") */ protected $rate; When I entered a value and said value was persisted to the database, …

Read More
Symfony2: spl_object_hash() expects parameter 1 to be object, string given in Doctrine

I am trying to populate the database with the object User and Person by executing persist and flush. First of all, I am creating the Person object and persist and flush it: $person->setFirstname($enquiry->getFirstname()); $person->…

Read More