Sort a multidimensional array in Laravel

Question

I am using laravel and want to sort this array based on ['messages'] "updated_at" field. The array should show latest message on top. I tried array_multisort( array_column($yourArray, "price"), SORT_ASC, $yourArray ) but didn't work.

Here is my multidimensional array which I want to sort by date.

How can I achieve this?

Eduardo Ortiz · Accepted Answer · 2020-05-05 16:59:01Z

2

Use usort function https://www.php.net/manual/en/function.usort.php

Write a callback comparing the nested created_at attribute

Also if you have a laravel collection you can use

$collection = $collection->sort(function ($a, $b) {
    if ($a == $b) {
        return 0;
    }
    return ($a < $b) ? -1 : 1;
});

Or if you are using eloquent you can order from SQL

Message::where(...)->orderBy('created_at', 'DESC')->paginate(20)

From a user relation

$user->with(['messages' => function ($query) {
    $query->orderBy('created_at', 'DESC');
}]);

edited May 5, 2020 at 16:59

answered May 5, 2020 at 16:53

Eduardo Ortiz

4075 silver badges12 bronze badges

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

3 Comments

SharmaV Over a year ago

I am getting data from this

$claims = Claim::query();  $claims = $claims->where('status', $status);  $claims->load('user', 'item', 'item.category', 'actions', 'actions.user', 'messages', 'messages.user');

how can I use this $user->with(['messages' => function ($query) { $query->orderBy('created_at', 'DESC'); }]);

Eduardo Ortiz Over a year ago

do you need order only the messages or all collection?

SharmaV Over a year ago

I need to order all collection

Collectives™ on Stack Overflow

Sort a multidimensional array in Laravel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related