Share this:

Hello dev, Today we are going to learn Laravel – Eloquent “Has”, “With”, “WhereHas” – What Do They Mean? Laravel, the popular PHP framework, provides an elegant and intuitive way to interact with databases using its ORM (Object-Relational Mapping) tool called Eloquent.

Eloquent simplifies database queries and enables developers to work with their data in a more expressive and efficient manner. In this blog post, we will explore three essential Eloquent methods: “has,” “with,” and “whereHas.”

We’ll discuss what they mean and how they can be used to enhance your Laravel application’s database interactions.

Eloquent “has” Method:

The “has” method in Eloquent allows you to retrieve records from a table based on the existence of a related record in a different table. It is particularly useful when dealing with relationships such as one-to-one, one-to-many, or many-to-many.

For example, let’s consider a blog application where we have two tables: “posts” and “comments.” To fetch all posts that have at least one comment, we can use the “has” method as follows:

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

This query will return all posts that have associated comments. The “has” method ensures that only the posts with related comments are retrieved, omitting any posts without comments.

Also Read: Get the Last Inserted Id Using Laravel Eloquent

Eloquent “with” Method:

The “with” method allows you to eager load relationships in a query to avoid the N+1 problem. When retrieving records that have relationships with other tables, using “with” can significantly optimize your queries.

Continuing with our blog application example, let’s say we want to retrieve all posts along with their associated comments. We can use the “with” method like this:

$posts = Post::with('comments')->get();

By eager loading the “comments” relationship, Laravel will retrieve all posts and their associated comments in a single query. This approach avoids the need to make additional queries for each post’s comments, resulting in improved performance.

Also Read: Laravel Checking If a Record Exists

Eloquent “whereHas” Method:

The “whereHas” method combines the power of “has” and “with” methods, allowing you to filter records based on a condition on a related table. It is useful when you want to retrieve records that meet certain criteria on their related models.

Let’s consider an example where we want to fetch all posts that have at least one comment containing the word “Laravel.” We can use the “whereHas” method as follows:

$posts = Post::whereHas('comments', function ($query) {
    $query->where('body', 'like', '%Laravel%');

This query will retrieve all posts that have comments containing the word “Laravel” in their body. The “whereHas” method applies the specified condition on the related “comments” table and filters the results accordingly.


Understanding and utilizing Eloquent’s “has,” “with,” and “whereHas” methods can significantly enhance your Laravel application’s database interactions.

These methods provide a concise and intuitive way to work with related models, optimize queries, and retrieve the data you need more efficiently.

By leveraging these powerful features of Laravel’s ORM, you can build robust and performant applications with ease.

Share this:

Categorized in: