Mysql querybuilder with multiple parameters values

Question

I try to get multiple values from setParameters, but with the same 'key', litke this :

->where('d.type = :type')->setParameters(array('type'=> 7, 'type => '8'))

But i have only result from '8', and not 7 + 8.

so i can't get multiple values from type ? With an other method ? — Ygg69
– Ygg69, Commented Mar 30, 2017 at 7:25
Do want get as Select * From YourTable as d where d.type IN (7,8)? — Imanali Mamadiev
– Imanali Mamadiev, Commented Mar 30, 2017 at 7:41
That's not a Symfony question, its a SQL question. You must use IN clausule from MySQL. — Borja Pombo
– Borja Pombo, Commented Mar 30, 2017 at 8:08
Thanks, i have updated my title, and that was indeed 'IN' :) — Ygg69
– Ygg69, Commented Mar 30, 2017 at 8:12

DonCallisto · Accepted Answer · 2017-03-30 07:28:51Z

2

Change your where condition as follows

->where('d.type IN (:types)')
->setParameter('types', array(7, 8))

or

$qb = $this->createQueryBuilder('d');

// other parts of your query using $qb variable

->where($qb->expr()->in('d.type', array(7, 8));

With first example, if array(7, 8) is a parameter variable (passed to function) and it's empty, no error will be raised.

In second, if array(7, 8) is a parameter variable (passed to function) and it's empty, an error will be raised (so you should check carefully before run the query.

answered Mar 30, 2017 at 7:28

DonCallisto

30k9 gold badges74 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

Mysql querybuilder with multiple parameters values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related