Cipta Multiple Where Clause Query Using Laravel Eloquent?

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,
       '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...

Leave a Reply

Your email address will not be published. Required fields are marked *


Hubungi Kami Untuk sebarang Pertanyaan

FIND US ON GOOGLE MAPS

KAJANG OFFICE:
Jalan Reko Sentral 1, 43000 Kajang, Selangor

TECHNOLOG PARTNER

Google, Facebook, Bing, Microsoft .NET, PHP, Apache, Alexa, Moz, Semrush, Wordpress, Laravel, Node.JS, React Native, Android, Apple,

Contact Us At

Phone: 0175554451

Email Us At

Email: hi@rekaweb.my

© 2019 Rekaweb Web Design & SEO Agency . All rights reserved.

Term and Condition | Privacy Policy