Coding Cheatsheets - Learn to Code

Multiple condition in find CakePHP Example 1: If you want this query in CakePHP SELECT first_name, last_name,joining_date from employees WHERE id = 047 AND ((joining_date = Last_day(joining_date)         AND Month(joining_date) IN(3, 6, 9, 12))         OR (joining_date = '2015-12-10'))       $this->Employee->find('all',    array('fields' =>         array('first_name','last_name','joining_date'),         'conditions' =>        array('id' => 047,     'OR' => array(      array(       'joining_date = LAST_DAY(joining_date)',       'MONTH(joining_date)' => array(3,6,9,12)),     'joining_date' => '2015-12-10'))     )); Example 2:      $conditions = array(    'OR' => array(    ...