Codeigniter AND OR AND [duplicate]

Question

It is posible to do: (condition 1 AND condition2) OR (condition3 AND condition4) in codigniter?

I try:

$this->db->where(condition1 - condition2);
$this->db->or_where(condition3 - condition4);

But this is: (condition1 AND condition2) OR (condition3 OR condition4)

Answer 1

Just write it out in your where

$this->db->where("(condition1 AND condition2) OR (condition3 AND condition4)");

this will still escape data and you don't have to fool with the or_where method.

Answer 2

yes it is possible,for convenience take whatever conditions you want to used into one variable

$where ="(condition 1 AND condition2) OR (condition3 AND condition4)";
$this->db->where($where);