Symfony 2 - fetch the last inserted row from table

Question

How can I rewrite this code in order to get last inserted record from the table?

$repository = $entityManager->getRepository('AdminBundle:MyTable');
$product = $repository->find($id);

I tried something like

$repository->findBy(array('id','DESC')->setMaxResults(1);

But it did not work for me.

score 25 · Accepted Answer · edited Mar 25 '20 at 19:40

25

You could get the latest record by using findBy() with order by, limit and offset parameters

$results = $repository->findBy(array(),array('id'=>'DESC'),1,0);

First argument is for filter criteria
Second argument takes order by criteria
Third argument is for limit
Fourth argument sets offset

Note it will return you the results set as array of objects so you can get single object from result as $results[0]

FindBy() Examples

edited Mar 25 '20 at 19:40

Andrey Tsarev

769
1
8
25

answered Jan 03 '18 at 06:48

M Khalid Junaid

63,861
10
90
118

I used your code and get this error: "[Doctrine\ORM\ORMException] Invalid order by orientation specified for Backend\AdminBundle\Entity\MyTable#0" – Jacek717 Jan 03 '18 at 09:08
1

@Jacek717 My bad it was key/value pair `'id'=>'DESC'` check the updated answer – M Khalid Junaid Jan 03 '18 at 09:25
I think that works! I get no errors. But I stil have a problem with fetching data from $results array. I mean when I try to type something like $output->writeln($results[0]); I get error: "PHP Notice: Undefined offset: 0". I'm a little newbie in PHP/Symfony so maybe it's very dummy question but I don't know how I can get info from this variable. Can you help? – Jacek717 Jan 03 '18 at 09:53
@Jacek717 what do you see if you [dump](https://stackoverflow.com/questions/11902099/too-much-data-with-var-dump-in-symfony2-doctrine2) $results – M Khalid Junaid Jan 03 '18 at 10:27
2

Ok I found where was the problem. I change argument for limit from 0 to 1 and now everything works fine. Thanks a lot for your help! – Jacek717 Jan 03 '18 at 12:05
Slight nuance, you passed 0 as limit and 1 as offset, you rather want to reverse that with `$results = $repository->findBy(array(),array('id'=>'DESC'),1,0);` – Steven Rosato Mar 07 '19 at 00:27

score 11 · Answer 2 · edited Jan 06 '18 at 00:09

11

Instead of hacking code where you want to use it, you can also create a repository method and call it when necessary.

/**
 * Repository method for finding the newest inserted
 * entry inside the database. Will return the latest
 * entry when one is existent, otherwise will return
 * null.
 *
 * @return MyTable|null
 */
public function findLastInserted()
{
    return $this
        ->createQueryBuilder("e")
        ->orderBy("id", "DESC")
        ->setMaxResults(1)
        ->getQuery()
        ->getOneOrNullResult();
}

References: https://symfony.com/doc/current/doctrine.html#querying-for-objects-the-repository

edited Jan 06 '18 at 00:09

Matt Smeets

398
4
15

answered Jan 03 '18 at 09:40

user3932886

111
2

1

Replacing `id` by `e.id` seems to be necessary. – Baudev Feb 05 '19 at 16:37
While the answer provided by @M Khalid Junaid offers simplicity, the one posted by @user3932886 has better reusability and allows your repository/query logic remain in one place, i.e. inside the repository class and therefore should be preferred in most cases. – Ali Aug 29 '22 at 14:47

score 4 · Answer 3 · answered Sep 30 '20 at 20:20

4

After looking for one I decided to try it myself, I think it was much less verbose:

$myRepository->findOneBy([], ['id' => 'DESC']);

answered Sep 30 '20 at 20:20

Jeferson Guedes

81
4

score 3 · Answer 4 · answered Jan 03 '18 at 06:48

3

Please try the below one

$repository = $entityManager->getRepository('AdminBundle:MyTable');
$repository->setMaxResults(1)->orderBy('id', 'DESC');
$results = $repository->getQuery()->getSingleResult();

Reference: https://undebugable.wordpress.com/2016/01/27/symfony2-querybuilder-find-first-and-find-last-record-in-table/

answered Jan 03 '18 at 06:48

Sam G

1,242
15
12

1

I used your approach and get this error: "Undefined method 'orderBy'. The method must star with either findBy or findOneBy!" – Jacek717 Jan 03 '18 at 08:54

score 1 · Answer 5 · answered Apr 12 '21 at 20:13

You can add these functions to your repository:

public function getLastRow(): ?YourEntity
{
    return $this->findOneBy([], ['id' => 'DESC']);
}

public function getLastId(): int
{
    $lastRow = $this->getLastRow();
    return $lastRow ? $lastRow->getId() : 0;
}

score 0 · Answer 6 · answered Apr 12 '21 at 22:14

0

You can be collected by getting the id of the inserted object

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

OR

$entitymanager->getRepository("entity")->findBy([],["id"=>desc])->getId();

answered Apr 12 '21 at 22:14

L3xpert

1,109
1
10
19

Symfony 2 - fetch the last inserted row from table

6 Answers6