How to get a Doctrine 2 result as an associative array?

Question

I want to get the results in array for this code:

 $person = $em->find('Person', 2);

I am using doctrine 2. I want the above result in array form. .

PHP version 5.4

Its an object oriented tool, get used to objects

RiggsFolly
– RiggsFolly

2018-01-12 14:22:27 +00:00
Commented Jan 12, 2018 at 14:22 — RiggsFolly
– RiggsFolly, Commented Jan 12, 2018 at 14:22

bliszka · Accepted Answer · 2018-01-16 08:33:28Z

2

The best approach is to write method in your Repository class or create query builder inline (but it is not recommended).

use Doctrine\ORM\Query; ... $qb = $em->getRepository(Person::class)->createQueryBuilder('p'); $qb ->andWhere('p.id = :id') ->setParameter('id', $id) ; $person = $qb->getQuery()->getResult(Query::HYDRATE_ARRAY);

Replace

$qb->getQuery()->getResult(Query::HYDRATE_ARRAY)

by

$qb->getQuery()->getOneOrNullResult(Query::HYDRATE_ARRAY)

if you need to get only one element.

edited Jan 16, 2018 at 8:33

answered Jan 12, 2018 at 14:41

bliszka

687 bronze badges

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

3 Comments

Ashfaq Over a year ago

above code returning this error : Warning: include_once(Query.php) [<a href='function.include-once'>function.include-once</a>]: failed to open stream: No such file or directory in /usr/local/zend/share/ZendFramework/library/Zend/Loader.php on line 134

bliszka Over a year ago

@Ashfaq You have to import Query class. Check example above I have added use Doctrine\ORM\Query;.

Ashfaq Over a year ago

Now, I am getting this error: Fatal error: Uncaught Doctrine\ORM\NonUniqueResultException in D:\xampp\htdocs\doctrine2\vendor\doctrine\orm\lib\Doctrine\ORM\AbstractQuery.php:774 after change $qb->getQuery()->getOneOrNullResult(Query::HYDRATE_ARRAY)

Ashfaq Muhammad · Accepted Answer · 2018-01-12 14:31:23Z

I have found a solution :

$person = $em->find('Person', 2); $personx = json_decode(json_encode((array)$person), true); echo '<pre>'; print_r($personx); echo '<pre>';

It is working perfectly for me.

Eugene Nikolaev · Accepted Answer · 2018-01-12 14:29:10Z

As $person may be object with circular references, it can not be converted to array directly, but you can use serializing, like it described here Symfony Serialize doctrine entity

Or you can do it manually:

$person_array = ['name' => $person->getName(), 'id' => $person->getId()];

Collectives™ on Stack Overflow

How to get a Doctrine 2 result as an associative array?

3 Answers 3

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Linked

Related