Laravel Query with multiple where clause

In my Laravel-5.8, I have this query:

$companies = $this->getCompanies();
$company_credentials = OrgSocialiteSetting::where('id', $companies->id)->first();

$azureUser = Socialite::with('azure')->user();

$user = User::where('company_id', $company_credentials->company_id)->where('email', $azureUser->email)->orWhere('username', $azureUser->user['mailNickname'])->first();

I have two where and one orWhere

I want to tie where('email', $azureUser->email)->orWhere('username', $azureUser->user['mailNickname']) together.

How do I achieve that?

Thanks

MichalOravec

5 years ago

Best Answer

Level 75

Have you ever read a documentation?

$user = User::where('company_id', $company_credentials->company_id)->where(function ($query) use ($azureUser) {
    $query->where('email', $azureUser->email)
            ->orWhere('username', $azureUser->user['mailNickname']);
})->first();

Docs: https://laravel.com/docs/5.8/queries#parameter-grouping

noblemfd

5 years ago

Level 9

@michaloravec - I got Syntax error unexpected: }

})->first();

MichalOravec

5 years ago

Level 75

I fixed it.

Do you have still a problem to find what the error is?

After a few months I don't see any progress with your programing skills...

MichalOravec

5 years ago

Level 75

@noblemfd Any answer to my questions?

Please or to participate in this conversation.