Write multiple laravel query at once

Question

im new to laravel, I just want to know if there's any way to efficiently rewrite this code?

$answer1 = SurveyAnswer::where('answer_1','=','1')->get()->count();
$answer2 = SurveyAnswer::where('answer_1','=','2')->get()->count();
$answer3 = SurveyAnswer::where('answer_1','=','3')->get()->count();
$answer4 = SurveyAnswer::where('answer_1','=','4')->get()->count();
$answer5 = SurveyAnswer::where('answer_1','=','5')->get()->count();

Hi, thanks for the answers, both worked. Im sorry if my question was incomplete. But what im trying to do is to count specific data in my table and display it in a page. I have 20 queries from different questions. Each questions have 5 answers. I want to count how many of each answers were recorded. I just want to know if there's better way to do it so that I won't have to write the same lines of codes 20 times. Thank you so much for your time. — Cath
– Cath, Commented Jun 10, 2017 at 14:12

Alexey Mezenin · Accepted Answer · 2017-06-10 13:35:07Z

1

Get the data first:

$answers = SurveyAnswer::whereIn('answer_1', [1, 2, 3, 4, 5])->get();

Then count answers using loaded collection:

$answer1 = $answers->where('answer_1', 1)->count();
$answer2 = $answers->where('answer_1', 2)->count();
...

This code will generate just one DB query instead of five.

answered Jun 10, 2017 at 13:35

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

user320487 · Accepted Answer · 2017-06-10 13:27:37Z

0

Try this:

$matches = [1,2,3,4,5];

$answer = SurveyAnswer::whereId('answer_1', $matches)->groupBy('answer_1')->get();

answered Jun 10, 2017 at 13:27

user320487

Comments

Mohamed Akram · Accepted Answer · 2017-06-10 16:52:24Z

0

You can easily do it with an agregate function with a case expression, since mysql doesnot support native pivoting functions Following is a sample, and try to rewrite according to your requirement and runt it against database directly, if it works, then you can use it with laravel raw sql.

 select id,
 sum(case when value = 1 then 1 else 0 end) ANSWER1_COUNT,
 sum(case when value = 2 then 1 else 0 end) ANSWER2_COUNT
from survey
group by answer

answered Jun 10, 2017 at 16:52

Mohamed Akram

2,11716 silver badges22 bronze badges

Collectives™ on Stack Overflow

Write multiple laravel query at once

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related