Symfony2 and multiple where

Question

I want to build a query using where with multiple values. Number of values is variable (from one to ten). My query looks like this for now:

return $repository->createQueryBuilder('s')
    ->where('s.id = :id')
    ->setParameter('id', '1')

But I want that id parameter to be array. I tried setParameters, but that's not the function.

Manse · Accepted Answer · 2013-01-22 10:19:19Z

2

Try this

return $repository->createQueryBuilder('s')
   ->where('s.id IN (:id)')
   ->setParameter('id', array('1','2','3'))

This uses the array passed as a parameter to be using in the IN statment.

To use a variable do this :

$myarray = array('1','2','3');
return $repository->createQueryBuilder('s')
   ->where('s.id IN (:id)')
   ->setParameter('id', $myarray)

edited Jan 22, 2013 at 10:19

answered Jan 22, 2013 at 10:04

Manse

38.1k11 gold badges88 silver badges112 bronze badges

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

2 Comments

Tomek Buszewski Over a year ago

Okay, works great! Can you tell me also, how can I pass an variable instead of array? When I define $asd variable outside the builder, and then I want to use it, Symfony returns unknown variable.

Tomek Buszewski Over a year ago

Yeah, and I was in the form builder :) So I had to use use. But nevertheless, your answer helped me A LOT. Thanks!

Collectives™ on Stack Overflow

Symfony2 and multiple where

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related