Laravel Count result based on specific value [duplicate]

Question

I have a simply query like this:

$events = EventHistory::where('u_h_id', $id) ->where('has_read', 0) ->get(['event_type']);

This will return a result that looks like this:

[ { event_type: 1 }, { event_type: 2 }, { event_type: 2 }, { event_type: 4 }, { event_type: 6 }, { event_type: 1 }, { event_type: 3 }, { event_type: 1 }, { event_type: 4 }, { event_type: 1 }, { event_type: 4 }, { event_type: 4 }]

But now I need a way to count the specific values so I can return now many results exist in the different event types

eg, on the result above I want to return

$type1 = 4; $type2 = 2; $type3 = 1; $type4 = 4; $type6 = 1;

There are 4 results that has a event_type value of 1 etc..

Do you want RDBMS server do it for you or you want to do it in PHP script (via collections). Also share table schema. — Kyslik
– Kyslik, Commented Aug 2, 2017 at 17:43

Kyslik · Accepted Answer · 2017-08-02 17:58:38Z

Dummy way to do it is use foreach

$result = []; foreach($events as $key => $value) { $result[$value['event_type']] = isset($result[$value['event_type']]) ? $result[$value['event_type']]+1 : 1; } // now you have indexed array $result with the desired output

http://sandbox.onlinephpfunctions.com/code/b49150f192b99b218708d5dd8037fe5a23457a79

Kiow · Accepted Answer · 2017-08-02 18:41:41Z

Got it to work using this:

$events = EventHistory::where('u_h_id', $id) ->where('has_read', 0) ->select('event_type', \DB::raw('count(*) as count')) ->groupBy('event_type') ->get();

Well of course, I linked you to the duplicate, I hope this gets closed, next time do search before asking.

Collectives™ on Stack Overflow

Laravel Count result based on specific value [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related