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

laravel multiple where

Add Answer

Vivacious Vulture answered on June 11, 2023 Popularity 6/10 Helpfulness 1/10

answer laravel multiple where

related laravel multiple where

related laravel where multiple or

related laravel multiple where

laravel multiple where

Comment

$matchThese = ['field' => 'value', 'another_field' => 'another_value', ...];

// if you need another group of wheres as an alternative:
$orThose = ['yet_another_field' => 'yet_another_value', ...];

Popularity 6/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

Closely Related Answers

laravel multiple where

Comment

$users = DB::table('users')
            ->whereColumn([
                ['first_name', '=', 'last_name'],
                ['updated_at', '>', 'created_at']
            ])->get();

$users = User::whereColumn([
                ['first_name', '=', 'last_name'],
                ['updated_at', '>', 'created_at']
            ])->get();

Popularity 9/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

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 11 2023

Vivacious Vulture

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

laravel multiple where

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 6/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

Comment

UserModel::where('id_user', $id_user)
                    ->where('estado', 1)
                    ->pluck('id_rol');

Popularity 6/10 Helpfulness 3/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

Comment

User::where('this', '=', 1)
    ->whereNotNull('created_at')
    ->whereNotNull('updated_at')
    ->where(function($query){
        return $query
        ->whereNull('alias')
        ->orWhere('alias', '=', 'admin');
    });

Popularity 6/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

Comment

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

Popularity 6/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

Comment

$query=DB::table('users')
        ->whereRaw("users.id BETWEEN 1003 AND 1004")
        ->whereNotIn('users.id', [1005,1006,1007])
        ->whereIn('users.id',  [1008,1009,1010]);
    $query->where(function($query2) use ($value)
    {
        $query2->where('user_type', 2)
            ->orWhere('value', $value);
    });

   if ($user == 'admin'){
        $query->where('users.user_name', $user);
    }

Popularity 6/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

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 6/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: laravel php where

Link to this answer
Share Copy Link

Contributed on Jun 11 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

laravel multiple where

Contents

More Related Answers

laravel multiple where

Closely Related Answers

laravel multiple where

laravel multiple where

laravel where multiple or

laravel where multiple or

laravel multiple where

laravel multiple where

laravel multiple where

laravel multiple where

laravel multiple where

laravel multiple where

Grepper

Documentation

Social

Legal

Contact

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