pass array of conditions to doctrine expr()->orx() method

php oop doctrine-orm doctrine dql
Bartosz Rychlicki picture Bartosz Rychlicki · Jul 28, 2012 · Viewed 23.6k times · Source

I need to construct DQL with a QueryBuilder like this 

[QUERY]... AND WHERE e.type = x OR e.type = Y OR e.type = N [...]

I have types in array How can I pass this array to my query builder? 

$qb->andWhere($qb->expr()->orx(CONDITIONS));

List of types will be dynamic, calling $qb->andWhere on each foreach types loop will make only more AND WHERE's no more ORs.
Can I store multiply orx expressions and then add it to andWhere? Any idea how to solve this, probably, common problem?

Answer

DEY picture DEY · Apr 16, 2013

I hope so, then I found this :

$conditions = array('e.type = x', 'e.type = Y', 'e.type = N');
$orX = $qb->expr()->orX();

foreach ($conditions as $condition) {
    $orX->add($condition);
}

$qb->add('where', $orX);

Using @meze suggestion, you can simplify the code and replace the foreach statement with:

$orX->addMultiple($conditions);

Related questions

When to use self over $this?

In PHP 5, what is the difference between using self and $this? When is each appropriate?

Read More
What is the difference between public, private, and protected?

When and why should I use public, private, and protected functions and variables inside a class? What is the difference between them? Examples: // Public public $variable; public function doSomething() { // ... } // Private private $variable; private function doSomething() { // ... } // Protected protected $variable; protected function …

Read More
How do I get a PHP class constructor to call its parent's parent's constructor?

I need to have a class constructor in PHP call its parent's parent's (grandparent?) constructor without calling the parent constructor. // main class that everything inherits class Grandpa { public function __construct() { } } class Papa extends Grandpa { public function __construct() { // call Grandpa's constructor …

Read More