Cakephp3 passing an array to where condition

Question

I'm working on this piece of code:

public function validateSelected($array = [1, 2])
{
    $this->autoRender = false;
    $samples = TableRegistry::get('Samples');
    $samples->query()
        ->update()
        ->set(['validate' => true])
        ->where(function ($exp, $q) {
            return $exp->in('id', $q);
        })
        ->execute();
}

The code is pretty much self explanatory, I want to update all the rows with id's that would be passed in an array to the function.

I've tested the code by doing this:

->where(function ($exp, $q) {
            return $exp->in('id', [1, 2, 3]);
        })

And its working fine but i cant pass the passed array parameter to this where condition as it gives a syntax error undeclared variable $array.

Any idea about how can i achieve this thing would be great.

arilia · Accepted Answer · 2016-04-26 12:11:48Z

4

you can use the use language construct to include external variables into the anonymous function

 $ids = [1, 2, 3];
 ->where(function ($exp, $q) use($ids) {
        return $exp->in('id', $ids ]);
    })

but you can simply do

->where(['id IN'  => $ids])

or also

->where(['id' => $ids], ['id' => 'integer[]'])

see the manual

answered Apr 26, 2016 at 12:11

arilia

9,3982 gold badges24 silver badges47 bronze badges

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

3 Comments

Subhan Over a year ago

Thanks alot that worked. Can you please explain the purpose of the second parameter in the unknown function?

arilia Over a year ago

I guess it's because sometimes you need to access some $query methods inside the anonymous function. See this paragraph for an example

Subhan Over a year ago

Thanks for the response.

Collectives™ on Stack Overflow

Cakephp3 passing an array to where condition

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related