Return array, not object from Doctrine query - Symfony2

Question

I'm using this:

$this->getDoctrine()->getRepository('MyBundle:MyEntity')->findAll(array(), Query::HYDRATE_ARRAY);

I thought that should ensure it returns an array of an array, but it still returns an array of objects.

I need the whole result returned as an array of an array so I can do this kind of thing (silly example, but it explains what I mean):

<?php
$result = $this->getDoctrine()->getRepository('MyBundle:MyEntity')->findAll('return-an-array');
?>    
This is the age of the person at the 5th record: <?php echo $result[4]['age']; ?>

Thomas Potaire · Accepted Answer · 2014-08-05 14:47:04Z

46

According to this EntityRepository class, findAll don't take multiple arguments.

The code below should do what you want

$result = $this->getDoctrine()
               ->getRepository('MyBundle:MyEntity')
               ->createQueryBuilder('e')
               ->select('e')
               ->getQuery()
               ->getResult(\Doctrine\ORM\Query::HYDRATE_ARRAY);

edited Aug 5, 2014 at 14:47

answered Jul 6, 2013 at 4:26

Thomas Potaire

6,29638 silver badges40 bronze badges

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

3 Comments

numerah Over a year ago

i am having the same porblem and its giving me this error "Error: Class 'apb\appassBundle\Controller\Doctrine\ORM\Query' not found in controller"

Thomas Potaire Over a year ago

Use a leading slash on \Doctrine\ORM\Query

numerah Over a year ago

thanx it was also working when i added use class and just add Query::HYDRATE_ARRAY

Jimbo · Accepted Answer · 2014-01-04 15:04:48Z

28

You can also use the getArrayResult() function instead of getResult(). It returns an array of data instead:

$query = $em->createQuery("SELECT test FROM namespaceTestBundle:Test test");
$tests = $query->getArrayResult();

edited Jan 4, 2014 at 15:04

Jimbo

26.7k16 gold badges93 silver badges135 bronze badges

answered Dec 12, 2013 at 16:12

Samir Mengadi

3013 silver badges3 bronze badges

Comments

Eric Amshukov · Accepted Answer · 2017-08-18 01:22:24Z

-1

Use getScalarResult() to get an array result with objects truncated to strings.

answered Aug 18, 2017 at 1:22

Eric Amshukov

2453 silver badges10 bronze badges

Collectives™ on Stack Overflow

Return array, not object from Doctrine query - Symfony2

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related