cakephp找到所有条件和OR

本文介绍了cakephp找到所有条件和OR的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

以下是我的条件：

'OR' => array( 'AND' => array( array('EventCompetitor.is_black' => 1), array('EventCompetitor.is_adult' => 1) ), 'AND' => array( array('EventCompetitor.is_black' => 0), array('EventCompetitor.is_adult' => 0) ), ),

当我调试我的查询这是错误的：

When i debug my query, it comes something like this, which is wrong:

AND ((`EventCompetitor`.`is_black` = 0) AND (`EventCompetitor`.`is_adult` = 0)) AND

现在，这不是我想要的类似这样：

Now, that's not what i want, I want it something like this:

((`EventCompetitor`.`is_black` = 1) AND (`EventCompetitor`.`is_adult` = 1)) OR ((`EventCompetitor`.`is_black` = 0) AND (`EventCompetitor`.`is_adult` = 0))

任何想法，我该如何实现？

Any idea, how can i achieve it?

谢谢！

推荐答案

您的OR键控数组中的子键是相同的名称，第二个键有效地覆盖第一个键。您需要将这些AND条件封装在自己的数组中，以防止键冲突。

your subkeys in your "OR" keyed array are the same name, with the second key effectively overwriting the first. you need to encapsulate those "AND" conditions in their own arrays, to prevent the key collision.

例如。而非：

'OR' => array( 'AND' => array( array('EventCompetitor.is_black' => 1), array('EventCompetitor.is_adult' => 1) ), 'AND' => array( array('EventCompetitor.is_black' => 0), array('EventCompetitor.is_adult' => 0) ), ),

do：

'OR' => array( array('AND' => array( array('EventCompetitor.is_black' => 1), array('EventCompetitor.is_adult' => 1) )), array('AND' => array( array('EventCompetitor.is_black' => 0), array('EventCompetitor.is_adult' => 0) )), ),