Laravel Eloquent Array foreach

Question

Hey guys Im new to laravel. I have this table

How will i able to fetch count of 'is_correct' column for each subject?

Thanks guys!

Kenath · Accepted Answer · 2021-01-22 13:16:57Z

1

Try this, replace the Model with your eloquent model name

Model::select(
'subject_id',
 Illuminate\Support\Facades\DB::raw("COUNT(is_correct) as count")
)
->groupBy('subject_id')
->get();

edited Jan 22, 2021 at 13:16

answered Jan 22, 2021 at 13:05

Kenath

6306 silver badges13 bronze badges

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

4 Comments

JSTR Over a year ago

hey man tried this but no luck it gives me a database error 1055 thanks!

Kenath Over a year ago

Can you share the error message? and the code you tried?

Kenath Over a year ago

I've edited the answer. Please check whether it's working

JSTR Over a year ago

Hey dude @Kenath. I think it works now and had a syntax error. This is a great help thanks a lot. Anyway I also find this very similar if someone need it. similar_scenario

Collectives™ on Stack Overflow

Laravel Eloquent Array foreach

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related