create query with array parameter

Question

I try to execute this query

$em->createQuery('select i from AcmePublicBundle:Public i where i.user in (:opc)');
$query->setParameter('opc', $opc);

where :opc is an array like this
$opc={array}[2]
  0 = {array}[1]
     id = "9"
  1 = {array}[1] 
     id = "10"

I get this error

Notice: Undefined offset: 0 in...

If I try this

$em->createQuery('select i from AcmePublicBundle:Public i where i.usuario in (9, 10)');

everything is fine. But I have to pass $opc.

Any ideas?

Jovan Perovic · Accepted Answer · 2012-10-19 09:17:19Z

2

Yeah, error seems quite appropriate because setParameter takes both array key and value into account and key represents field name. Therefore, you can't use matrix here.

$ids = array();
foreach ( $opc as $o ){
    $ids[] = (int)$o[1]; //be careful about data type (string, int etc)
}
$q = " .... WHERE id IN (:opc) ... ";
$q->setParameter('opc', $ids);

This should work....

answered Oct 19, 2012 at 9:17

Jovan Perovic

20.2k5 gold badges47 silver badges92 bronze badges

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

Comments

Juan Sosa · Accepted Answer · 2012-10-19 09:17:28Z

1

Your $opc array should not be multidimensional. Try passing an array like this:

$opc=array(
  '9',
  '10'
);

instead of

$opc=array(
  array('id'=>'9'),
  array('id'=>'10')
);

answered Oct 19, 2012 at 9:17

Juan Sosa

5,2801 gold badge37 silver badges41 bronze badges

Collectives™ on Stack Overflow

create query with array parameter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related