Laravel - How to write Multiple conditions in where clause?

Question

Actually my query is:

SELECT * FROM company WHERE status<>$status AND type=$b1 AND type=$b2

How to convert this in laravel?

I did this in laravel but it is not working:

$data['Company'] = DB::table('company')->where([["status","<>",$status], ["type","=",$b1],["type","=",$b2]])->get();

Please help me!

Try with this: $data['Company'] = DB::table('company')->where('status','<>',$status)->where('type',$b1)->where('type',$b2)->get(); — Hiren Gohel
– Hiren Gohel, Commented Aug 30, 2017 at 9:53

Poornima Subramani Naidu · Accepted Answer · 2018-03-14 07:18:08Z

1

The whereIn method verifies that a given column's value is contained within the given array:

$data['Company'] = DB::table('company') ->where('status','<>',$status) ->whereIn('type',['$b1','$b2') ->get();

answered Mar 14, 2018 at 7:18

Poornima Subramani Naidu

3932 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kuldeep Mishra · Accepted Answer · 2017-08-30 09:51:44Z

1

$data['company'] = DB::table('company')->where('status',$status)->where('type',$b1)->where('type',$b2)->get();

answered Aug 30, 2017 at 9:51

Kuldeep Mishra

4,0601 gold badge24 silver badges26 bronze badges

1 Comment

Kuldeep Mishra Over a year ago

use DB; in your controller

Yusuf Eka Sayogana · Accepted Answer · 2017-08-30 10:07:27Z

1

You should use where method in 1 condition

$data['Company'] = DB::table('company')->where('status','<>',$status)->where('t‌ype',$b1)->where('ty‌pe',$b2)->get();

answered Aug 30, 2017 at 10:07

Yusuf Eka Sayogana

4013 silver badges11 bronze badges

Comments

Abd0m1nals · Accepted Answer · 2017-08-30 11:20:39Z

1

Try this:

\App\Company::where('status','!=',$status)->where('type',$b1)->where('type',$b2)->get();

answered Aug 30, 2017 at 11:20

Abd0m1nals

2,48615 silver badges27 bronze badges

Collectives™ on Stack Overflow

Laravel - How to write Multiple conditions in where clause?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related