request with multiple id Symfony2 Doctrine

symfony doctrine-orm
Ajouve picture Ajouve · Nov 6, 2013 · Viewed 54.8k times · Source

I've got an array of IDs and I'd like to get an entity array from my IDs array.

I can't use find.

The sql request looks like:

SELECT * FROM mytable WHERE id = 12 OR id = 10 ...

with a loop on my id array.

Answer

Piotr Pasich picture Piotr Pasich · Nov 6, 2013

You can also get it directly from repository:

$em->getRepository('YourRepo')->findById(array(1,2,3,4,5));

Also you can pass parameters in get no tin array, but in simple string glued by commas

?ids=1,2,3,4,56

And after that get it from $request

$em->getRepository('YourRepo')->findById(explode(',', $request->get('ids'));

Related questions

Count Rows in Doctrine QueryBuilder

I'm using Doctrine's QueryBuilder to build a query, and I want to get the total count of results from the query. $repository = $em->getRepository('FooBundle:Foo'); $qb = $repository->createQueryBuilder('n') ->where('n.bar = :bar') ->…

Read More
How to sort findAll Doctrine's method?

I've been reading Doctrine's documentation, but I haven't been able to find a way to sort findAll() Results. I'm using symfony2 + doctrine, this is the statement that I'm using inside my Controller: $this->getDoctrine()->getRepository('MyBundle:MyTable')…

Read More
On delete cascade with doctrine2

I'm trying to make a simple example in order to learn how to delete a row from a parent table and automatically delete the matching rows in the child table using Doctrine2. Here are the two entities I'm using: Child.…

Read More