Sort json object laravel

Question

I have two merged queries and I need to sort (orderBy) by id.

$query1= DB::table('contract')->where('to_user_id',$to_user_id)->get();
$query2= DB::table('contract')->where('from_user_id',$to_user_id)->get();
$query1= $query1->merge($query2);

I tried to orderBy('id') but it ordered individualy not together.

have a look on this link

Jigar Shah
– Jigar Shah

2018-01-29 12:09:42 +00:00
Commented Jan 29, 2018 at 12:09 — Jigar Shah
– Jigar Shah, Commented Jan 29, 2018 at 12:09

Darren · Accepted Answer · 2018-01-29 12:15:35Z

2

Instead of performing 2 queries and merging them, would it be better to just pull the relevant records in 1 go?

For example:

$query1= DB::table('contract')
        ->where('to_user_id',$to_user_id)
        ->orWhere('from_user_id', $to_user_id)
        ->get();

answered Jan 29, 2018 at 12:15

Darren

761 silver badge6 bronze badges

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

Comments

Sohel0415 · Accepted Answer · 2018-01-29 12:50:13Z

0

You can use sortBy() to sort the collection and values() method to reset the keys to consecutively numbered indexes -

$query1 = $query1->merge($query2);
$query1 = $query1->sortBy('id');

$query1 = $query1->values()->all();

edited Jan 29, 2018 at 12:50

answered Jan 29, 2018 at 12:44

Sohel0415

9,89124 silver badges32 bronze badges

Collectives™ on Stack Overflow

Sort json object laravel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related