How to use OR_Where with AND condition in CodeIgniter?

Question

I am using CodeIgniter. I need to understand how where and or_where condition working in codeigniter query builder.

I need an output like where a="" AND b="" AND c="" OR d="" AND e=""

so I tried an associative array.

$where= array('a'=>$firstname,'b'=>$lastname,'c'=>1);
$or_where= array('d' =>$customer_mobile,'e'=>1);

But I am getting the output where a="" AND b="" AND c="" OR d="" OR e=""

Would you help in out in this?

Yes, My question is different. I asked about the or_where condition. Please check my expect output and getting output. And the duplicate question is different.

Possible duplicate of [Grouping WHERE clauses in Codeigniter](https://stackoverflow.com/questions/6470267/grouping-where-clauses-in-codeigniter) — iainn, Aug 07 '18 at 11:27
I think you haven't notice that or_where condition. Kindly check it again. I have multiple condition — user9437856, Aug 07 '18 at 11:30
use normal `query()`. I don't think, this can achievable. Even with Laravel i got same kind issue — Abdulla Nilam, Aug 07 '18 at 11:36
@AbdullaNilam, Thanks for the reply, Normal query means I have to use $or_where=('d'="" AND 'e'=""); something like this? — user9437856, Aug 07 '18 at 11:38
use normal SQL and add to this `$this->db->query("SELECT .....");` check https://stackoverflow.com/a/31285071/4595675 — Abdulla Nilam, Aug 07 '18 at 11:41

score 3 · Accepted Answer · answered Aug 07 '18 at 11:42

Hope this will help you :

Use query grouping like this : change your table name and variables according to you

$firstname = 'a';
$lastname = 'b';
$customer_mobile = 'd';
$this->db->select('*')->from('users')
        ->group_start()
                ->where('a', $firstname)
                ->where('b', $lastname)
                ->where('c', '1')
                ->or_group_start()
                        ->where('d', $customer_mobile)
                        ->where('e', '1')
                ->group_end()
        ->group_end()
->get();
echo $this->db->last_query();

The output will be like this :

SELECT * FROM `users` 
WHERE ( `a` = 'a' AND `b` = 'b' AND `c` = '1'
OR ( `d` = 'd' AND `e` = '1' ) )

For more : https://www.codeigniter.com/user_guide/database/query_builder.html#query-grouping

If I have to use join ->join('membership_details', 'members.member_id = membership_details.member_id', 'Left'); then I have to add before group_start ? — user9437856, Aug 07 '18 at 11:52

How to use OR_Where with AND condition in CodeIgniter?

1 Answers1