Doctrine findBy* methods and fetch array

Question

What is the cleanest way of using the Doctrine findBy methods but getting an array returned and not objects.

Doctrine::getTable('Table')->findOneById(x);

That works but returns a doctrine object.

I'd still like to be able to use the find methods but I know I can't add

->fetchArray()

on the end.

Anyone else had this problem?

DuoSRX · Accepted Answer · 2011-04-05 13:39:29Z

20

You can specify the hydration mode when using magic finders, like so:

Doctrine_Core::getTable('Table')->findOneById($x, Doctrine_Core::HYDRATE_ARRAY);

answered Apr 5, 2011 at 13:39

DuoSRX

4,2093 gold badges28 silver badges32 bronze badges

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

Comments

Haim Evgi · Accepted Answer · 2011-04-05 13:28:40Z

3

Try use toArray

Doctrine::getTable('Table')->findOneById(x)->toArray();

answered Apr 5, 2011 at 13:28

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

1 Comment

DuoSRX Over a year ago

If you do this, you will first fetch an object and then convert it to an array, which is not efficient memory-wise.

Steven Mercatante · Accepted Answer · 2011-04-05 13:49:26Z

3

Haim Evgi and DuoSRX's answers are correct, but there's a slightly different version for both that I prefer when using Symfony:

Let's say your model name is Person, you would use:

PersonTable::getInstance()->findOneById(x)->toArray();

or

PersonTable::getInstance()->findOneById($x, Doctrine_Core::HYDRATE_ARRAY);

answered Apr 5, 2011 at 13:49

Steven Mercatante

25.4k9 gold badges68 silver badges109 bronze badges

2 Comments

NBPalomino Over a year ago

So what is the difference ?

okdewit Over a year ago

@NBPalomino: The first one retrieves the full Object and converts it to an Array, the second one retrieves it directly as an Array (which uses less memory and is faster). I'd advice to use Array Hydration whenever you need to retrieve information without updating the database.

René Höhle · Accepted Answer · 2013-02-21 11:06:09Z

1

$adCampaign = $em->createQuery('select c from \Model\Campaign c where c.client = ?1')
->setParameter(1, $clientId)
->getArrayResult();

where em is the entityManager - you get the result as array with getArrayResult

edited Feb 21, 2013 at 11:06

René Höhle

27.4k22 gold badges78 silver badges91 bronze badges

answered Sep 27, 2011 at 11:37

alex toader

2,4382 gold badges19 silver badges23 bronze badges

1 Comment

nealio82 Over a year ago

I think you'll find your answer relates to Symfony 2.x (Doctrine 2) which supports namespaces and the entity manager service, whereas the original question is tagged Symfony 1

Collectives™ on Stack Overflow

Doctrine findBy* methods and fetch array

4 Answers 4

Comments

1 Comment

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related