Symfony2 + Doctrine: Multiple where conditions using array

Question

I have an entity and i'm trying to create the following function inside its repository

function customGet(array $criteria)
{
     //WHAT I'm trying to do:
     //SELECT *
     //FROM mytable
     //LEFT JOIN anothoer table
     //WHERE criteria1 = value1 AND criteria2 = value2 ...etc

     $q = $this
        ->createQueryBuilder('u')
        ->select('u, g')
        ->leftJoin('u.theOtherTable', 'g');
        //Where here
        ->getQuery();
}

How can i do the where clause?

Ahmed Siouani · Accepted Answer · 2013-10-28 15:32:44Z

5

    $q = $this->createQueryBuilder('u')
        ->select('u, g')
        ->leftJoin('u.theOtherTable', 'g');

    foreach ($criteria as $field => $value) {
        $q->andWhere(sprintf('u.%s = :%s', $field, $field))
          ->setParameter($field, $value);
    }

    return $q->getQuery();

edited Oct 28, 2013 at 15:32

Ahmed Siouani

13.9k12 gold badges63 silver badges73 bronze badges

answered Oct 18, 2013 at 6:50

Leetbulb

4163 silver badges6 bronze badges

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

2 Comments

trrrrrrm Over a year ago

Thanks, It works perfectly, is it a good practice to use this to override Doctrine FindBy method ? since i'm having problem with fetch="EAGER" stackoverflow.com/questions/19421861/…

m0c Over a year ago

You should try to "filter" already on the Join if possible, but besides, this is in my opinion a good practice to write dedicated queries.

Md Mehedi Hasan · Accepted Answer · 2013-10-24 07:14:24Z

You can do it in this way if all entity association done correctly

function customGet(array $criteria)
    {
         $value1 = $criteria['0'];   //Your expected value
         $value2 = $criteria['1'];   //Your expected value

     $q = $this
        ->createQueryBuilder('u')
        ->select('u, g')
        ->leftJoin('u.theOtherTable', 'g');
        ->where('criteria1 = :value1 AND criteria2 = :value2')
        ->setParameters(array('value1'=>$value1,'value2'=>$value2))
        ->getQuery();

   return $q->getResult()
}

Collectives™ on Stack Overflow

Symfony2 + Doctrine: Multiple where conditions using array

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related