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();
Hello everyone! I'm excited to share with you how I'm enhancing my Laravel 10 API by enabling the capability to...
Dec-01-2023
This article will show us how to validate upload file type using javascript. Using this post we can easily check the sel...
Aug-03-2020
Here you will learn how to get random records from DB in laravel using the inRandomOrder() method. Explore an...
Nov-10-2023
In this article, we will see how to create a calendar event in laravel 9 using ajax. Here, we will learn how to add...
Dec-28-2022