Laravel Eager Loading with Count Relationship Example

By Hardik Savani | August 18, 2019 | | 1302 Viewer | Category : Laravel


Eager Loading is a concept of laravel relationship and it is a best. But when you are working with model relationship with eager loading then you require to get count number of records for relation model. At that we can use withcount() for eager loading count in laravel 5.8.

Whenever you require to count rows of relation model then we will use withcount(). So that can help us. you can see bellow example. i will count number of comments for each posts. you can see bellow example.

Let's see bellow example. So might be it can help you.

Simple Count Example:

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

// comments_count

Multiple Counts Example:

$posts = Post::withCount([

'comments',

'tags'

])->get();

// comments_count

// tags_count

Count with Condition Example:

$posts = Post::withCount([

'comments',

'comments as active_comments' => function (Builder $query) {

$query->where('approved', 1);

}

])->get();

// comments_count

// active_comments

I hope it can help you...



Hardik Savani
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.
***Do you want me hire for your Project Work? Then Contact US.


We are Recommending you: