"IN" and "NOT IN" in CakePHP3

Question

There is an example in the Cookbook:

$query = $cities->find()
   ->where(function ($exp, $q) {
      return $exp->notIn('country_id', ['AFG', 'USA', 'EST']);
});

In SQL this should be aequivalent to: WHERE country_id NOT IN ('AFG', 'USA', 'EST')

Now, I'm trying to use a variable here. Sadly, this won't work:

$query = $cities->find()
   ->where(function ($exp, $q, $variable) {
      return $exp->notIn('country_id', $variable);
});

Any ideas?

You mean variable inheritance, traits are something completely different ;) — ndm, Jun 28 '17 at 15:16
But why is it not possible to pass the variable through normal function parameter? — DeVolt, Jun 29 '17 at 10:21

DeVolt · Answer 1 · 2017-06-29T10:19:23.710

0

It works with "use", see: PHP: Anonymous Functions

$query = $cities->find()
   ->where(function ($exp, $q) use ($variable) {
      return $exp->notIn('country_id', $variable);
});

edited Jun 29 '17 at 10:19

answered Jun 28 '17 at 13:01

DeVolt

321
1
3
15

score 0 · Accepted Answer · answered Jun 30 '17 at 14:49

0

I always find the easiest way to use IN and NOT IN is as follows in CakePHP

$query = $cities->find()
   ->where(['country_id IN' => $variable])

More information on auto generating in clauses is at the following link in the book. You can also use it to cast values to the type of the column automatically. To me it is more readable as well.

https://book.cakephp.org/3.0/en/orm/query-builder.html#automatically-creating-in-clauses

answered Jun 30 '17 at 14:49

KaffineAddict

436
2
11

1

Thanks! That works even better! – DeVolt Jul 10 '17 at 08:55

"IN" and "NOT IN" in CakePHP3

2 Answers2