PHP Sort a complex multi-dimensional array by value

Question

I have a multi-dimensional array that generates an HTML table.

Data in array:

HTML Table renders like so:

+---------+-----------------+----------------------+----------+------------+--------------+--------------+
| Compare |     Product     |    Type of Cover     | Roadside | Nationwide |    Price     |              |
+---------+-----------------+----------------------+----------+------------+--------------+--------------+
| Logo    | Product Cover 2 | Vehicle & Personal 2 | Yes      | No         | from £75 GBP | Visit site > |
| Logo    | Product Cover 3 | Vehicle & Personal 3 | No       | Yes        | from £73 GBP | Visit site > |
| Logo    | Product Cover 4 | Vehicle & Personal 4 | Yes      | Yes        | from £84 GBP | Visit site > |
| Logo    | Product Cover 5 | Vehicle & Personal 5 | No       | No         | from £96 GBP | Visit site > |
+---------+-----------------+----------------------+----------+------------+--------------+--------------+

Now I want to be able to sort by "price" but as you can see in the array the 'content' key for the price cell is a string and we need to sort it by the 'sort_value' key. Other sortable columns like 'Roadside' or 'Nationwide' should be sortable too by their 'sort_value' key.

I have tried different combinations of array_multisort or usort but was not successful.

Any help on this would be much appreciated. If you have questions, please feel free to ask.

Thanks in advance.

you forgot to post your codes

Kevin
– Kevin

2020-07-27 09:04:16 +00:00
Commented Jul 27, 2020 at 9:04 — Kevin
– Kevin, Commented Jul 27, 2020 at 9:04

Nick · Accepted Answer · 2020-07-27 09:10:50Z

1

Here's a function that will sort your list the way you want it to. It first searches for the key of the field to sort on in the headers part of the array, then sorts the row part based on the sortable values for that key:

function sort_list($list, $field, $ascending = true) {
    $headers = array_values($list['header'])[0];
    if (($key = array_search($field, array_column($headers, 'content'))) === false || $headers[$key]['sortable'] == 0) {
        // can't find field or field is not sortable, do nothing
        return $list;
    }
    usort($list['row'], function ($a, $b) use ($key, $ascending) {
        return $ascending ? $a[$key]['sort_value'] <=> $b[$key]['sort_value'] : $b[$key]['sort_value'] <=> $a[$key]['sort_value'];
    });
    return $list;
}

Sample usage:

sort_list($data, 'Price');

Demo on 3v4l.org

answered Jul 27, 2020 at 9:10

Nick

147k23 gold badges67 silver badges106 bronze badges

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

Collectives™ on Stack Overflow

PHP Sort a complex multi-dimensional array by value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related