how to convert mysql query to laravel querybuilder

Question

I try to convert my query to laravel query builder but i cant get succeed, my query is in mysql as below:

SELECT p.seller, p.purchase_date, p.report_no FROM purchases AS p UNION SELECT ps.seller, ps.purchase_date, ps.report_no FROM purchase_solds AS ps ORDER BY purchase_date DESC

So how do i convert it into laravel query-builder or laravel eloquent?

HirenMangukiya · Accepted Answer · 2017-04-17 07:23:50Z

1

Have you tried

$purchases = DB::table('purchases')
                 ->select('seller', 'purchase_date', 'report_no');

$purchase_solds = DB::table('purchase_solds')
                      ->select('seller', 'purchase_date', 'report_no')
                      ->union($purchases)
                      ->orderBy('purchase_date', 'desc')
                      ->get();

edited Apr 17, 2017 at 7:23

HirenMangukiya

6553 gold badges14 silver badges30 bronze badges

answered Apr 17, 2017 at 6:45

linktoahref

8,0273 gold badges32 silver badges54 bronze badges

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

2 Comments

HirenMangukiya Over a year ago

Thanks for your answer but it gives me error Method getBindings does not exist

linktoahref Over a year ago

Hi, I've updated the code, could you please check again!

Collectives™ on Stack Overflow

how to convert mysql query to laravel querybuilder

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related