Breaking News: Grepper is joining You.com. Read the official announcement!

multiple logical condition in laravel query

Add Answer

Fine Fox answered on May 9, 2020 Popularity 10/10 Helpfulness 4/10

answer multiple logical condition in laravel query

related laravel where multiple conditions

related laravel where multiple or

related two condition in one laravel query

related laravel where multiple or

multiple logical condition in laravel query

Comment

// ...
$q->where(function ($query) {
    $query->where('gender', 'Male')
        ->where('age', '>=', 18);
})->orWhere(function($query) {
    $query->where('gender', 'Female')
        ->where('age', '>=', 65);	
})

Popularity 10/10 Helpfulness 4/10 Language php

Source: laraveldaily.com

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Aug 04 2020

Fine Fox

0 Answers Avg Quality 2/10

Closely Related Answers

laravel where multiple conditions

Comment

$query->where([
    ['column_1', '=', 'value_1'],
    ['column_2', '<>', 'value_2'],
    [COLUMN, OPERATOR, VALUE],
    ...
])

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on May 09 2020

Xanthous Xenomorph

0 Answers Avg Quality 2/10

laravel where multiple or

Comment

$query->where([
    ['column_1', '=', 'value_1'],
    ['column_2', '<>', 'value_2'],
    [COLUMN, OPERATOR, VALUE],
    ...
])

Popularity 7/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: laravel php where wher

Link to this answer
Share Copy Link

Contributed on Jun 12 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel where multiple or

Comment

$results = User::where('this', '=', 1)
       ->where('that', '=', 1)
       ->where(
           function($query) {
             return $query
                    ->where('this_too', 'LIKE', '%fake%')
                    ->orWhere('that_too', '=', 1);
            })
            ->get();

Popularity 8/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: laravel php

Link to this answer
Share Copy Link

Contributed on Jun 12 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

two condition in one laravel query

Comment

 $data = Sub_sub_category::select('sub_sub_cat_name','id')->where('sub_cat_id',$request->id)->where('status','1')->get();

Popularity 10/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jul 02 2021

Different Dugong

0 Answers Avg Quality 2/10

laravel where multiple or

Comment

$users = User::where([
       'column1' => value1,
       'column2' => value2,
       'column3' => value3
])->get();

Popularity 7/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php where wher

Link to this answer
Share Copy Link

Contributed on Jun 12 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel where multiple or

Comment

$results = User::where('this', '=', 1)
->orWhere('that', '=', 1)
->orWhere('this_too', '=', 1)
->orWhere('that_too', '=', 1)
->orWhere('this_as_well', '=', 1)
->orWhere('that_as_well', '=', 1)
->orWhere('this_one_too', '=', 1)
->orWhere('that_one_too', '=', 1)
->orWhere('this_one_as_well', '=', 1)
->orWhere('that_one_as_well', '=', 1)
->get();

Popularity 7/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php where wher

Link to this answer
Share Copy Link

Contributed on Jun 12 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

multiple logical condition in laravel query

Contents

More Related Answers

multiple logical condition in laravel query

Closely Related Answers

laravel where multiple conditions

laravel where multiple or

laravel where multiple or

two condition in one laravel query

laravel where multiple or

laravel where multiple or

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.