Hi Guys,
Are you looking for how to use union in laravel query builder? If yes then you are a right place.
Here i will show you example of union query in laravel 5 project. You can simply user union mysql query by using union() of laravel eloquent.
Here i write union query for two tables and get both tables data like as bellow query result:
Example:
$silver = DB::table("product_silver")
->select("product_silver.name"
,"product_silver.price"
,"product_silver.quantity");
$gold = DB::table("product_gold")
->select("product_gold.name"
,"product_gold.price"
,"product_gold.quantity")
->union($silver)
->get();
dd($gold);
Output:
Collection {#233 ▼
#items: array:5 [▼
0 => {#235 ▼
+"name": "Speaker"
+"price": 500
+"quantity": 100
}
1 => {#237 ▼
+"name": "Mobile"
+"price": 200
+"quantity": 100
}
2 => {#238 ▼
+"name": "Mobile"
+"price": 100
+"quantity": 500
}
3 => {#239 ▼
+"name": "Laptop"
+"price": 200
+"quantity": 600
}
4 => {#240 ▼
+"name": "Tables"
+"price": 600
+"quantity": 100
}
]
}
I hope you found your best solution...
Do you like below Tutorials ?
- How to Open URL in New Tab using Jquery?
- Laravel 7.x and 6.x Routing Tutorial
- Ng Bootstrap Modal in Angular 8 Example
- Bootstrap 4 Datepicker in Angular 9/8 Example
- Disable Registration Route in Laravel
- Bootstrap Timepicker in Angular Example
- Count Number of Pages in PDF - PHP Script
- Digital Signature PHP Script Example