How to merge two table data in laravel?

Question

I need all users data in one blade, I have table1 and table2.

table1

'id','name','phone','email','status','created_at'

table2

'id','name','mobile','email','status','created_at'

I tried to do this but not an expected result.

 $usersTbl = DB::table('table1')->select('id','name','phone','email','status','created_at')->groupBy('phone')->paginate(20);

 $ordersTbl = DB::table('table2')->select('id','name','mobile','email','status','created_at')->groupBy('mobile')->paginate(20);

 $items=$ordersTbl->merge($usersTbl);
 dd($items);exit;

What's the end goal? are they going to be in 1 big array or are you looking for something else? — Frosty
– Frosty, Commented Dec 26, 2019 at 7:06
once you fetch the data from both tables you can merge the result instead of the merging table — Amit Sharma
– Amit Sharma, Commented Dec 26, 2019 at 7:07
maybe you need to use union, so you can merge using SQL query instead laravel/php — Muhammad Dyas Yaskur
– Muhammad Dyas Yaskur, Commented Dec 26, 2019 at 7:07

TsaiKoga · Accepted Answer · 2019-12-26 07:32:35Z

4

You have pagination, if you merge it the pagination need to recalculate.

You need to use unionAll and then paginate:

$usersTbl = DB::table('table1')->select('id','name','phone','email','status','created_at')->groupBy('phone');

$ordersTbl = DB::table('table2')->select('id','name','mobile AS phone','email','status','created_at')->groupBy('phone');

$mergeTbl = $usersTbl->unionAll($ordersTbl);
DB::table(DB::raw("({$mergeTbl->toSql()}) AS mg"))->mergeBindings($mergeTbl)->paginate(20);

edited Dec 26, 2019 at 7:32

answered Dec 26, 2019 at 7:08

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

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

5 Comments

Mukund Bharti Over a year ago

(1/1) BadMethodCallException Method Illuminate\Support\Collection::unionAll does not exist.

TsaiKoga Over a year ago

@WorldsHero Do you get them or use paginate in usersTbl?

Mukund Bharti Over a year ago

use paginate in usersTbl

TsaiKoga Over a year ago

@WorldsHero don't use it. Follow my code, groupBy them and then unionAll them, and then paginate.

Mukund Bharti Over a year ago

Let us continue this discussion in chat.

Shamsheer · Accepted Answer · 2019-12-26 09:00:38Z

-1

Try This Method:

public function Details($id) {
    /** Make an empty array **/
        $patients = array();
    /** Get Data from first model **/
        $user_details = User::where(['id' => $id])->first();
    /** Get Data from second model **/
        $profile_details = Profile::where(['id' => $id])->first();
        $patients[] = $user_details; 
        $patients[] = $profile_details; 
        }
        return view('custom-view', compact('patients'));
    }

answered Dec 26, 2019 at 9:00

Shamsheer

7444 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to merge two table data in laravel?

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