doctrine dql/queryBuilder with a foreach or array in parameters

Question

In my symfony aplication, I recover a variable as a string by my ajax script.

This variable looks like this:

$slug = "1-2-3-4-4-5-6-7" /* it could more*/
$vars = explode('-',$slug ); /*push the $slug string in an array */

/* recover all value of the array */
foreach ($vars as $var) {
      echo $var;
    }

Now I need to use this foreach in a dql or a query builder because all $var are ids of an entity and i need to pass all this value to get the right result.

How can I make a query with an array of parameter or make a foreach in doctrine query builder ?

I have already try something this in a queryBuilder method:

->setParameters("id" => $vars);

it returns me an error : SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

I try this too in the queryBuilder:

->setParameters(array('id' => array($vars)));

Here I have no error, but it does not return the good result. Indeed I have only one result in database if there are many ids.

This has been asked and answered before

SaschaM78
– SaschaM78

2016-01-25 12:56:46 +00:00
Commented Jan 25, 2016 at 12:56 — SaschaM78
– SaschaM78, Commented Jan 25, 2016 at 12:56

oshell · Accepted Answer · 2016-01-29 09:53:08Z

1

If you want to check if the id is within a certain set of given ids you can use IN.

$qb = $this->createQueryBuilder('s')
        ->addSelect('u')
        ->innerJoin('s.field','u')
        ->where("u.id IN(:ids)")
        ->setParameter('ids', array_values($ids));

answered Jan 29, 2016 at 9:53

oshell

9,1511 gold badge31 silver badges50 bronze badges

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

Comments

Ajir · Accepted Answer · 2016-01-25 12:30:17Z

0

Try using the ->setParameter('ids', $ids). where $ids is the array of ids

answered Jan 25, 2016 at 12:30

Ajir

2151 silver badge10 bronze badges

2 Comments

french_dev Over a year ago

see my edit, in fact if I use setParameters("ids" => $ids) I have an error of SQLState for the cardinality like SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s). As it is wrote, the dql does not accept an array here.

Ajir Over a year ago

->where('topic.user IN (:userIds)') ->setParameter('userIds', $userIds);

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

The solution is here.

I created a more complex query in order to answer to all condition:

array is empty

array contains only 1 value

array contains many values

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 26, 2016 at 14:02

french_dev

2,17712 gold badges48 silver badges92 bronze badges

Collectives™ on Stack Overflow

doctrine dql/queryBuilder with a foreach or array in parameters

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related