{"id":329,"date":"2016-10-20T11:16:11","date_gmt":"2016-10-20T11:16:11","guid":{"rendered":"https:\/\/www.vibidsoft.com\/blog\/?p=329"},"modified":"2025-05-23T09:44:27","modified_gmt":"2025-05-23T09:44:27","slug":"sort-multidimensional-array-by-multiple-keys-php","status":"publish","type":"post","link":"https:\/\/www.vibidsoft.com\/blog\/sort-multidimensional-array-by-multiple-keys-php\/","title":{"rendered":"Sort multidimensional arrays by multiple keys – PHP"},"content":{"rendered":"

We would like to share PHP Solution for sorting of multidimensional array with Multiple Keys. As developers, it’s likely that you encountered this situation where you have a list of items in the database that are fetched in a specific order but you want to display them in the front-end sorted by a value of that item.<\/p>\n

Input Array :<\/strong><\/p>\n

$mylist <\/span>=<\/span> array<\/span>(<\/span>\narray<\/span>(<\/span>'ID'<\/span> =><\/span> 1<\/span>,<\/span> 'title'<\/span> =><\/span> 'Boring Meeting'<\/span>,<\/span> 'event_type'<\/span> =><\/span> 'meeting'<\/span>),<\/span>\narray<\/span>(<\/span>'ID'<\/span> =><\/span> 2<\/span>,<\/span> 'title'<\/span> =><\/span> 'Find My Stapler'<\/span>,<\/span> 'event_type'<\/span> =><\/span> 'meeting'<\/span>),<\/span>\narray<\/span>(<\/span>'ID'<\/span> =><\/span> 3<\/span>,<\/span> 'title'<\/span> =><\/span> 'Mario Party'<\/span>,<\/span> 'event_type'<\/span> =><\/span> 'party'<\/span>),<\/span>\narray<\/span>(<\/span>'ID'<\/span> =><\/span> 4<\/span>,<\/span> 'title'<\/span> =><\/span> 'Duct Tape Party'<\/span>,<\/span> 'event_type'<\/span> =><\/span> 'party'<\/span>)<\/span>\n);<\/span><\/code><\/pre>\n
Sorting Logic using array_mulitsort :<\/strong><\/p>\n
# get a list of sort columns and their data to pass to array_multisort<\/span>\n$sort <\/span>=<\/span> array<\/span>();<\/span>\nforeach<\/span>(<\/span>$mylist <\/span>as<\/span> $k<\/span>=><\/span>$v<\/span>)<\/span> {<\/span>\n$sort<\/span>[<\/span>'title'<\/span>][<\/span>$k<\/span>]<\/span> =<\/span> $v<\/span>[<\/span>'title'<\/span>];<\/span>\n$sort<\/span>[<\/span>'event_type'<\/span>][<\/span>$k<\/span>]<\/span> =<\/span> $v<\/span>[<\/span>'event_type'<\/span>];<\/span>\n}<\/span>\n# sort by event_type desc and then title asc<\/span>\narray_multisort<\/span>(<\/span>$sort<\/span>[<\/span>'event_type'<\/span>],<\/span> SORT_DESC<\/span>,<\/span> $sort<\/span>[<\/span>'title'<\/span>],<\/span> SORT_ASC<\/span>,<\/span>$mylist<\/span>);<\/span><\/code><\/pre>\n
Final Output of $mylist:<\/strong><\/p>\n
array <\/span>(<\/span>\n  0<\/span> =><\/span> \n  array <\/span>(<\/span>\n    'ID'<\/span> =><\/span> 4<\/span>,<\/span>\n    'title'<\/span> =><\/span> 'Duct Tape Party'<\/span>,<\/span>\n    'event_type'<\/span> =><\/span> 'party'<\/span>,<\/span>\n  ),<\/span>\n  1<\/span> =><\/span> \n  array <\/span>(<\/span>\n    'ID'<\/span> =><\/span> 3<\/span>,<\/span>\n    'title'<\/span> =><\/span> 'Mario Party'<\/span>,<\/span>\n    'event_type'<\/span> =><\/span> 'party'<\/span>,<\/span>\n  ),<\/span>\n  2<\/span> =><\/span> \n  array <\/span>(<\/span>\n    'ID'<\/span> =><\/span> 1<\/span>,<\/span>\n    'title'<\/span> =><\/span> 'Boring Meeting'<\/span>,<\/span>\n    'event_type'<\/span> =><\/span> 'meeting'<\/span>,<\/span>\n  ),<\/span>\n  3<\/span> =><\/span> \n  array <\/span>(<\/span>\n    'ID'<\/span> =><\/span> 2<\/span>,<\/span>\n    'title'<\/span> =><\/span> 'Find My Stapler'<\/span>,<\/span>\n    'event_type'<\/span> =><\/span> 'meeting'<\/span>,<\/span>\n  ),<\/span>\n)<\/span><\/code><\/pre>\n
Vibidsoft has expertise to solve this kind of Custom Programming problems and expert in custom application development.For more information mail us on inquiry@vibidsoft.com<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
We would like to share PHP Solution for sorting of multidimensional array with Multiple Keys. As developers, it’s likely that you encountered this situation where you have a list of items in the database that are fetched in a specific… Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":335,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[103,110],"tags":[111,113,105,112,20],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/posts\/329"}],"collection":[{"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":4,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":2387,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/posts\/329\/revisions\/2387"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/media\/335"}],"wp:attachment":[{"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vibidsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}