How to count the rows by created date in Laravel query builder?

Question

I am trying to count the rows by created_at like

Created_at                        COUNT(*)
----------------------------------- ----------
2017-08-13                                    5
2017-08-12                                    6
2017-08-11                                    7
2017-07-10                                    8
2017-07-19                                    1

So I can show the client like in 2017-07-10, there are 8 people signed up. In 2017-08-13, there are 5 people signed up or something like that.

Here is what I tried,

$count=DB::table('jobseekers')->select('created_at')->groupBy('created_at')->count();
    // return $count;
    dd($count);

but this is just showing only the number.

Christos · Accepted Answer · 2017-08-27 06:41:11Z

4

You could try something like this:

$count = DB::table('jobseekers')
             ->select('created_at', DB::raw('count(*) as peoples'))
             ->groupBy('created_at')
             ->get();

answered Aug 27, 2017 at 6:41

Christos

54.1k9 gold badges82 silver badges114 bronze badges

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

2 Comments

Soul Coder Over a year ago

Hi how to union the other tables using this concept? Can you show me the tips? thanks dude

Christos Over a year ago

@ThanHtutOo I don't see any other tables? Could you please make another question and state there explicitly which are the tables you want to perform a union, with a sample input and a sample output? This way it would be helpful for others also. Thanks !

Collectives™ on Stack Overflow

How to count the rows by created date in Laravel query builder?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related