Laravel Query Builder - Convert MySQL quert to Laravel Query Builder

Question

I have a query in MySQL:

SELECT student, ((SUM(mark1)+SUM(mark2))/SUM(mark3)) AS avg FROM your_table

and

SELECT student, (mark1+mark2-mark3) AS result FROM your_table

I like to convert them to Laravel's query builder format query.

But I can't find any way to do that.

Thanks for answering, but I like to avoid DB:raw. Is there any way? — S M Abrar Jahin
– S M Abrar Jahin, Commented Sep 17, 2015 at 1:28

Kyle · Accepted Answer · 2015-09-17 01:25:11Z

1

You need something like this

Student::select( DB::raw('student, ((SUM(mark1)+SUM(mark2))/SUM(mark3)) AS avg ')->get();

answered Sep 17, 2015 at 1:25

Kyle

4052 silver badges6 bronze badges

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

5 Comments

S M Abrar Jahin Over a year ago

Thanks for answering, but I like to avoid DB:raw. Is there any way?

Kyle Over a year ago

Querybuilder is trying to help you write SQL... it's a helper. So all of the php you write is eventually going to be converted to SQL anyways. Not all cases will fit into it though so you have to use DB::raw() for advanced use cases. This isn't a bad thing so don't sell yourself on the fact that it is. Raw SQL is 10x faster than php anyways.

S M Abrar Jahin Over a year ago

Yes, but BD:RAW has a security hole, so everyone should try to avoid that.

Kyle Over a year ago

Only if your passing it unsanitized data which you shouldn't be doing.

S M Abrar Jahin Over a year ago

Thanks for let me know

S M Abrar Jahin · Accepted Answer · 2015-09-17 01:38:25Z

0

Thanks for helping, but I have found the solution-

 $baseQuery =   DB::table('employee')->select('employee_name', DB::raw('employee_salary/employee_extension as employee_salary'), 'employee_position', 'employee_city', 'employee_extension',"employee_joining_date", 'employee_age', 'employee_id');

Should be in this format

answered Sep 17, 2015 at 1:38

S M Abrar Jahin

14.7k24 gold badges116 silver badges170 bronze badges

Collectives™ on Stack Overflow

Laravel Query Builder - Convert MySQL quert to Laravel Query Builder

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related