Laravel Eloquent - distinct() and count() not working properly together

laravel count eloquent distinct
Inigo EC picture Inigo EC · Feb 21, 2015 · Viewed 291.4k times · Source

So I'm trying to get the number of distinct pids on a query, but the returned value is wrong.

This is what I try to do:

$ad->getcodes()->groupby('pid')->distinct()->count()

what returns the value "2", while the value it should return, should be "1".

As a workaround, I'm doing this:

count($ad->getcodes()->groupby('pid')->distinct()->get())

what works fine and returns "1"

Is there any rule where count and distinct cannot be on the same query? I find the workaround kind of "heavy", I would like to make the original query work :(

Answer

Suresh Bala picture Suresh Bala · Apr 19, 2015

The following should work

$ad->getcodes()->distinct('pid')->count('pid');

Related questions

Laravel 5.3 Pagination Total number of pages

I have a Paginator instance $paginator in Laravel App, I want to display 'Last' in pagination, so I need a link to the last page. How to get the last page number in laravel 5.3?

Read More
PHP 7.2 count() function is not working

I have a working php application and it is running fine on php 7.0 version. But when I upgrade a php version to 7.2. I am getting this error: count(): Parameter must be an array or an object that implements Countable I …

Read More
How Do I Get the Query Builder to Output Its Raw SQL Query as a String?

Given the following code: DB::table('users')->get(); I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users. How do I do …

Read More