Count Multiple Models in Laravel

Question

I have multiple models: User, Track, Tutorial, Chapter, Lesson, & SolvedLesson.

Below is what I've done to for counting each model.

$data = [
    'userCount' => \App\User::count(),
    'userRegisteredToday' => \App\User::whereCreatedAt(date('Y-m-d'))->count(),
    'trackCount' => \App\Models\Track::count(),
    'tutorialCount' => \App\Models\Tutorial::count(),
    'chapterCount' => \App\Models\Chapter::count(),
    'lessonCount' => \App\Models\Lesson::count(),
    'solvedLessonCount' => \App\Models\SolvedLesson::count(),
];

Laravel provides relationships and eager loading to efficiently query. Is there any method to convert the above query into one single query for better performance?

Could you also provide the relationship between this models? I think a couple of counts can be avoided.. — Kenny Horna
– Kenny Horna, Commented Jan 4, 2019 at 4:53
what are you trying to achieve. its just the count of each model in dashboard — ManojKiran
– ManojKiran, Commented Jan 4, 2019 at 5:23

Brian Lee · Accepted Answer · 2019-01-04 06:21:41Z

1

The withCount method allows you to count the number of results for model relationships.

Assuming you've defined a one to many relation between the User and SolvedLesson models:

// you can optionally alias the appended count attribute
$users = User::withCount('solvedLessons as solved_count')->get();

// total users
$users->count()

// iterate users to get the number of solved lessons for each
$users->each(function (User $user) {
    // using the alias defined above
    echo $user->solved_count;
});

You're not limited to a single relation either, passing an array will get the count for each relation:

$tracks = Track::withCount(['tutorials', 'users'])->get();

// total tracks
$tracks->count()

// access each relation count per track
$tracks->each(function (Track $track) {
    echo $track->tutorial_count;
    echo $track->user_count;
});

answered Jan 4, 2019 at 6:21

Brian Lee

18.3k3 gold badges45 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Count Multiple Models in Laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related