Multiple where laravel in Codefunda

 <?php 

// Multiple where laravel in Codefunda

// laravel where multiple conditions

$query->where([

    ['column_1', '=', 'value_1'],

    ['column_2', '<>', 'value_2'],

    [COLUMN, OPERATOR, VALUE],

    ...

])

laravel where multiple conditions on single colmn

// here, i have used two different where condition on a single column

$data = Users::where('type',1)

        ->where(function($query) {

            return $query->whereDate('updated_at','!=', Carbon::today())

            ->orWhere('updated_at',null);

         })

         ->get();

         

www.Codefunda.tk

?>