Multiple orwhere condition in laravel in Codefunda

 <?php 

// Multiple orwhere condition in laravel in Codefunda

// multiple orwhere condition in laravel

public function index()

    {

        $search = "Har";

  

        $users = User::select("*")->where('status', 1)

                  ->where(function($query) use ($search){

                   $query->where('first_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('email', 'LIKE', '%'.$search.'%');

                    })->get();

  

        dd($users);

    }

# With Join

  public function index()

    {

        $search = "Har";

  

        $users = User::select("*")->where('status', 1)

                  ->where(function($query) use ($search){

                   $query->where('first_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('last_name', 'LIKE', '%'.$search.'%')

                   ->orWhere('email', 'LIKE', '%'.$search.'%');

                    })

          ->join('users_roles', 'users.id', '=', 'users_roles.user_id')

          ->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)->get();

  

        dd($users);

    }

    // laravel where multiple conditions

    $query->where([

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

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

        [COLUMN, OPERATOR, VALUE],

        ...

    ])

www.Codefunda.tk

?>