Get result of raw SQL query in Laravel 5 Eloquent

Question

I need help to build a Laravel query from my raw SQL Query. I tried many way and did not find my Luck. Can anybody help me? My Raw SQL code is given bellow.

SELECT exams. * , count( question_details.exam_id ) AS qus_enter
FROM exams
INNER JOIN question_details ON exams.id = question_details.exam_id GROUP BY exams.id

This is what I've tried:

$examListsID = DB::table('exams')
                 ->join('question_details', function($join) {
                     $join->on('exams.id', '=', 'question_details.exam_id as qus_enter');
                 })
                 ->whereraw('count(qus_enter) = exams.total_question')
                 ->select('exams.id as examID','qus_enter','exams.total_question')
                 ->count('qus_enter')
                 ->groupby('exams.id')
                 ->get();

$examLists = Addexam::where('id','=',$examListsID->examID)

And I Get this Error:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as qus_enter where count(qus_enter) = exams.total_question' at line 1 (SQL: select count(qus_enter) as aggregate from exams inner join question_details on exams.id = question_details.exam_id as qus_enter where count(qus_enter) = exams.total_question)

I have two table one is 'exams' and 'question_details'. in my 'exams' table i set the total question of that exam and in my 'question_details' I entered the questions with 'exam_id'. I want to load only that exam which have all question inserted in 'question_details' table. — Shahadat Hossain
– Shahadat Hossain, Commented May 4, 2015 at 7:30
I mean I want you to update your answer with the Laravel query code (even if it's not working) — lukasgeiter
– lukasgeiter, Commented May 4, 2015 at 7:31
$examListsID = DB::table('exams') ->join('question_details', function($join) { $join->on('exams.id', '=', 'question_details.exam_id as qus_enter'); }) ->whereraw('count(qus_enter) = exams.total_question') ->select('exams.id as examID','qus_enter','exams.total_question') ->count('qus_enter') ->groupby('exams.id') ->get(); $examLists = Addexam::where('id','=',$examListsID->examID); — Shahadat Hossain
– Shahadat Hossain, Commented May 4, 2015 at 7:33
For the next time, please edit your question to add details. I've done that now for you... — lukasgeiter
– lukasgeiter, Commented May 4, 2015 at 7:36

Sameer Shaikh · Accepted Answer · 2015-05-04 07:45:37Z

1

$result = DB::table('exams')->join('question_details','exams.id','=','question_details.exam_id')->select([
  exams.*,
  DB::raw('count( question_details.exam_id ) AS qus_enter')
])->GroupBy('exams.id')->get()

Hope this helps

answered May 4, 2015 at 7:45

Sameer Shaikh

2651 gold badge9 silver badges21 bronze badges

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

Comments

Amol · Accepted Answer · 2021-06-21 11:23:45Z

0

DB::listen(function ($data) { 
var_dump($data->bindings);
    dd($data->sql);
});

answered Jun 21, 2021 at 11:23

Amol

1251 silver badge4 bronze badges

1 Comment

Jeremy Caney Over a year ago

Welcome. Can you offer an explanation of what you are doing here? That will help future readers with similar problems, but who may be unfamiliar with this syntax.

Collectives™ on Stack Overflow

Get result of raw SQL query in Laravel 5 Eloquent

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related