Symfony2 - how can I get Entity Object based on custom query?

Question

this is my custome query:

$query = $em->createQuery("SELECT max(d.id) FROM MyBundle:DBTableEntity d ");
$max_incoming_id = $query->execute();

I want it to return the Entity Object, just like this one below:

$EntityObj = $resource->getRepository("MyBundle:DBTableEntity")->findAll();

Any idea how to do that?

Solution: $query = $resource->createQuery("SELECT d FROM MyBundle:MyEntity d where d.id > 5); $entities = $query->execute(); foreach ($entities as $i=>$entity): //get entity's ID $entity->getId(); endforeach; That's it! — Edge
– Edge, Commented Nov 23, 2011 at 14:08

JamesHalsall · Accepted Answer · 2011-11-23 13:35:46Z

1

Something like this should work

$EntityObjects = $resource->getRepository('MyBundle:DBTableEntity')
                         ->createQuery()
                         ->orderBy('id', 'DESC')
                         ->getResult();

$EntityObject = array_pop($EntityObjects);

answered Nov 23, 2011 at 13:35

JamesHalsall

13.5k4 gold badges43 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Edge Over a year ago

I've found the solution, its simple with foreach loop: $query = $resource->createQuery("SELECT d FROM MyBundle:MyEntity d where d.id > 5); $entities = $query->execute(); foreach ($entities as $i=>$entity): //get entity's ID $entity->getId(); endforeach; That's it!

Edge Over a year ago

I just ran your code and realized getRepository doesn't contain any CreateQuery() method

Ankit Chauhan · Accepted Answer · 2012-10-16 05:43:10Z

1

Try This

$query = sprintf("SELECT s FROM BundleName:EntityClass s where s.field1 = %d and s.field2=%d", $field1, $field2);
$em = $this->getDoctrine()->getEntityManager();
$queryObj = $em->createQuery($query);
$entities = $queryObj->execute();

answered Oct 16, 2012 at 5:43

Ankit Chauhan

4044 silver badges18 bronze badges

Comments

Patrick Bentveld · Accepted Answer · 2015-03-16 19:53:21Z

0

With excute you receive a array of results (entities).

so you can do $entities = $query.excute();

return $entities[0]; //this is if you have one result;

array_pop($entities) will not work this gives a error in symfony 2.6

answered Mar 16, 2015 at 19:53

Patrick Bentveld

1

Comments

Tony · Accepted Answer · 2015-03-17 03:49:09Z

0

I think you will like this style:

$EntityObj = $resource->getRepository("MyBundle:DBTableEntity")
                      ->findOneBy(array(), array('id' => 'DESC'));

:)

edited Mar 17, 2015 at 3:49

answered Mar 17, 2015 at 3:43

Tony

1,3792 gold badges8 silver badges12 bronze badges

Collectives™ on Stack Overflow

Symfony2 - how can I get Entity Object based on custom query?

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related