dynamic find using multiple NOT LIKE

Question

I'm trying to do a complex find in CakePHP that has multiple NOT LIKE variables pulled from a table.

Just as an example of trying to use an array, something like:

$blocked_words = array();
array_push($blocked_words,'%apple%','%orange%','%strawberry%','%grapes%');

'NOT' => array(
array('Api.reason LIKE' => $blocked_words)),

does not work, only:

'NOT' => array(
array('Api.reason LIKE' => '%apple%'),
array('Api.reason LIKE' => '%orange%'),
array('Api.reason LIKE' => '%grapes%')),

seems to work. While this is great, it doesn't solve my need when i'm pulling an unknown number of variables. Is there a way to have LIKE work with an array or a workaround?

voodoo417 · Accepted Answer · 2014-09-07 04:25:50Z

1

Do it:

$blocked_words = array('%apple%','%orange%','%strawberry%','%grapes%');
$conditions = array(); // conditions
foreach ($blocked_words as $word) {
   $conditions['NOT'][] = array('Api.reason LIKE' => "%$word%");
}

answered Sep 7, 2014 at 4:25

voodoo417

12.2k3 gold badges39 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

dynamic find using multiple NOT LIKE

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