cakephp 查找所有条件 AND OR

本文介绍了cakephp 查找所有条件 AND 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) ), ),

做:

'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) )), ),