Laravel whereHas and orWhereHas Query Example

Websolutionstuff | Jan-19-2021 | Categories : Laravel PHP MySQL

In this article, we will see the laravel whereHas and orWhereHas query example. whereHas and orWhereHas query is used in laravel for relationships. So, here I will give you an example of how to use whereHas in laravel 7, laravel 8, and laravel 9, whereHas eloquent in laravel 7/8 work the same as the has() function.

has() is to filter the selecting model based on a relationship. So it acts very similarly to a normal WHERE condition. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation. whereHas() works basically the same as has() but allows you to specify additional filters for the related model to check.

So, let's see the laravel 7/8/9 whereHas() and orWhereHas() query example and the whereHas() query example in laravel 7/8/9 or orWhereHas() query example in laravel 7/8/9.

Example 1:

$posts = Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'code%');
})->get();

 

Example 2:

$users = User::whereHas('posts', function($q){
    $q->where('created_at', '>=', '2021-01-01 00:00:00');
})->get();
// only users that have posts from 2021 on forward are returned

 

Example 3:

$posts = Post::whereHas('comments', function (Builder $query) {
    $query->where('content', 'like', 'code%');
}, '>=', 10)->get();

 

Example 4:

$posts = Post::has('comments', '>=', 3)->get();

 

Recommended Post
Featured Post
How To Create React JS Application
How To Create React JS Applica...

In this article, we will see how to create React JS application. Creating React App is a comfortable envi...

Read More

Aug-10-2022

Laravel 9 Generate PDF File Using DomPDF
Laravel 9 Generate PDF File Us...

In this tutorial, we will see laravel 9 generate pdf file using dompdf. For generating pdf files we will use the la...

Read More

Feb-25-2022

Laravel 8 Form Validation Example
Laravel 8 Form Validation Exam...

In this article, we will see the laravel 8 form validation example. form validation in laravel is a very common fun...

Read More

Oct-10-2020

How To Install Tailwind CSS In Laravel 9
How To Install Tailwind CSS In...

In this article, we will see how to install tailwind CSS in laravel 9. Tailwind CSS works by scanning all of y...

Read More

Jun-13-2022