Laravel 4 where condition

Question

below is my query...

    DB::table('sometable')
    ->join('sometable','sometable.ID','=','manytable.ID')
    ->where('manytable.SBPlan','00')
    ->where('manytable.NetStatus','0')
    ->select()->get();

for the above query i need one more condition

    ->where('manytable.Status','00')
    ->where('manytable.Status','21')

if manytable.Status==00 or manytable.Status==21 then select.. how do we fix this? i have already tried

    ->orwhere('manytable.Status','00')
    ->orwhere('manytable.Status','21')

but did got a wrong result...

score 0 · Accepted Answer · edited May 23 '17 at 12:12

0

->where('manytable.SBPlan','00')
->where('manytable.NetStatus','0')
->where(function ($query) {
    $query->where('manytable.Status','00')
      ->orWhere('manytable.Status','21');
    })

reference - Laravel 4 eloquent WHERE with OR AND OR? / Laravel or where

edited May 23 '17 at 12:12

Community

1
1

answered Sep 15 '14 at 06:31

Sougata Bose

30,871
8
44
87

Laravel 4 where condition

1 Answers1