Kajang, Malaysia 20:35
Hubungi Kami

Rekaweb Insights Laravel

Cipta Multiple Where Clause Query Using Laravel Eloquent?

Cara Array list $query->where([ [‘column_1’, ‘=’, ‘value_1’], [‘column_2’, ‘’, ‘value_2’], [COLUMN, OPERATOR, VALUE], … ]) sample: $users = User::where([ ‘column1’ => value1, ‘column2’ => value2,

1 Min Read Laravel

Cara Array list

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

sample:

$users = User::where([
       'column1' => value1,
       'column2' => value2,
       'column3' => value3
])->get();
$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();

 

Menggunakan fungsi Antonymous 

$users = User::where('column1', '=', value1)
               ->where(function($query) use ($variable1,$variable2){
                    $query->where('column2','=',$variable1)
                   ->orWhere('column3','=',$variable2);
               })
              ->where(function($query2) use ($variable1,$variable2){
                    $query2->where('column4','=',$variable1)
                   ->where('column5','=',$variable2);
              })->get();

No votes yet.
Please wait…

Share Article

Rekaweb Digital

PerlukanWebsite?

Bina kehadiran digital yang lebih profesional.

Rekaweb membantu perniagaan membina website moden, pantas dan mesra pengguna.

Bincang Projek →