Sort an Array by keys based on another Array

Question

Is it possible in PHP to do something like this  How would you go about writing a function  Here is an example  The order is the most important thing    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     And I d like to do something like    properOrderedArray   sortArrayByArray  customer  array  name    dob    address       Because at the end I use a foreach   and they re not in the right order  because I append the values to a string which needs to be in the correct order and I don t know in advance all of the array keys values    I ve looked through PHP s internal array functions but it seems you can only sort alphabetically or numerically

User · Answer

Take one array as your order    order   array  north    east    south    west      You can sort another array based on values using array intersect shy Docs      sort by value      array   array  south    west    north     sorted   array intersect  order   array   print r  sorted     Or in your case  to sort by keys  use array intersect key shy Docs      sort by key      array   array flip  array    sorted   array intersect key array flip  order    array   print r  sorted     Both functions will keep the order of the first parameter and will only return the values  or keys  from the second array   So for these two standard cases you don t need to write a function on your own to perform the sorting re-arranging

User · Answer

A bit late  but I couldn t find the way I implemented it  this version needs closure  php  5 3  but could be altered not to    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     order   array  name    dob    address      keys  array flip  order   uksort  customer  function  a   b use  keys       return  keys  a  -  keys  b       print r  customer     Of course  dontSortMe  needs to be sorted out  and may appear first in the example

User · Answer

function sortArrayByArray array  toSort  array  sortByValuesAsKeys         commonKeysInOrder   array intersect key array flip  sortByValuesAsKeys    toSort        commonKeysWithValue   array intersect key  toSort   commonKeysInOrder        sorted   array merge  commonKeysInOrder   commonKeysWithValue       return  sorted

User · Answer

function sortArrayByArray array  toSort  array  sortByValuesAsKeys         commonKeysInOrder   array intersect key array flip  sortByValuesAsKeys    toSort        commonKeysWithValue   array intersect key  toSort   commonKeysInOrder        sorted   array merge  commonKeysInOrder   commonKeysWithValue       return  sorted

User · Answer

I adopted the answer from  Darkwaltz4 for its brevity and would like to share how I adapted the solution to situations where the array may contain different keys for each iteration like so   Array 0        dob      12 08 1986     some key      some value    Array 1        dob      12 08 1986    Array 2        dob      12 08 1986     some key      some other value     and maintained a  master key  like so    master key   array   dob    gt          some key    gt           array merge would have executed the merge in the Array 1  iteration based on  master key and produced   some key         an empty value  for that iteration   Hence  array intersect key was used to modify  master key in each iterations like so   foreach   customer as  customer       modified key   array intersect key  master key   unordered array      properOrderedArray   array merge  modified key   customer

User · Answer

Without magic      array array 28  gt c 4  gt b 5  gt a    seq array 5 4 28       SortByKeyList  array  seq  result  array 5  gt a 4  gt b 28  gt c    function sortByKeyList  array  seq        ret array        if empty  array     empty  seq   return false      foreach  seq as  key   ret  key   dataset  key        return  ret

User · Answer

This function return a sub and sorted array based in second parameter  keys  function array sub sort array  values  array  keys        keys   array flip  keys       return array merge array intersect key  keys   values   array intersect key  values   keys        Example    array complete          a    gt  1       c    gt  3       d    gt  4       e    gt  5       b    gt  2      array sub sorted   array sub sort  array complete    a    b    c      return   a    gt  1   b    gt  2   c    gt  3

User · Answer

Take one array as your order    order   array  north    east    south    west      You can sort another array based on values using array intersect shy Docs      sort by value      array   array  south    west    north     sorted   array intersect  order   array   print r  sorted     Or in your case  to sort by keys  use array intersect key shy Docs      sort by key      array   array flip  array    sorted   array intersect key array flip  order    array   print r  sorted     Both functions will keep the order of the first parameter and will only return the values  or keys  from the second array   So for these two standard cases you don t need to write a function on your own to perform the sorting re-arranging

User · Answer

There you go   function sortArrayByArray array  array  array  orderArray         ordered   array        foreach   orderArray as  key            if  array key exists  key   array                  ordered  key     array  key               unset  array  key                        return  ordered    array

User · Answer

A bit late  but I couldn t find the way I implemented it  this version needs closure  php  5 3  but could be altered not to    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     order   array  name    dob    address      keys  array flip  order   uksort  customer  function  a   b use  keys       return  keys  a  -  keys  b       print r  customer     Of course  dontSortMe  needs to be sorted out  and may appear first in the example

User · Answer

Just use array merge or array replace  Array merge works by starting with the array you give it  in the proper order  and overwriting adding the keys with data from your actual array    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     properOrderedArray   array merge array flip array  name    dob    address      customer     Or   properOrderedArray   array replace array flip array  name    dob    address      customer       properOrderedArray - gt  array  name    gt   Tim    address    gt   123 fake st    dob    gt   12 08 1986    dontSortMe    gt   this value doesnt need to be sorted     ps - I m answering this  stale  question  because I think all the loops given as previous answers are overkill

User · Answer

function sortArrayByArray array  toSort  array  sortByValuesAsKeys         commonKeysInOrder   array intersect key array flip  sortByValuesAsKeys    toSort        commonKeysWithValue   array intersect key  toSort   commonKeysInOrder        sorted   array merge  commonKeysInOrder   commonKeysWithValue       return  sorted

User · Answer

IF you have array in your array  you ll have to adapt the function by Eran a little bit     function sortArrayByArray  array  orderArray         ordered   array        foreach  orderArray as  key   gt   value            if array key exists  key  array                      ordered  key     array  key                   unset  array  key                        return  ordered    array

User · Answer

This function return a sub and sorted array based in second parameter  keys  function array sub sort array  values  array  keys        keys   array flip  keys       return array merge array intersect key  keys   values   array intersect key  values   keys        Example    array complete          a    gt  1       c    gt  3       d    gt  4       e    gt  5       b    gt  2      array sub sorted   array sub sort  array complete    a    b    c      return   a    gt  1   b    gt  2   c    gt  3

User · Answer

I adopted the answer from  Darkwaltz4 for its brevity and would like to share how I adapted the solution to situations where the array may contain different keys for each iteration like so   Array 0        dob      12 08 1986     some key      some value    Array 1        dob      12 08 1986    Array 2        dob      12 08 1986     some key      some other value     and maintained a  master key  like so    master key   array   dob    gt          some key    gt           array merge would have executed the merge in the Array 1  iteration based on  master key and produced   some key         an empty value  for that iteration   Hence  array intersect key was used to modify  master key in each iterations like so   foreach   customer as  customer       modified key   array intersect key  master key   unordered array      properOrderedArray   array merge  modified key   customer

User · Answer

PHP has functions to help you with this    arrayToBeSorted   array  west    east    south    north     order   array  north    south    east    west        sort array usort  arrayToBeSorted  function  a   b  use   order          sort using the numeric index of the second array      valA   array search  a   order        valB   array search  b   order           move items that don t match to end     if   valA     false          return -1      if   valB     false          return 0       if   valA  gt   valB          return 1      if   valA  lt   valB          return -1      return 0        Usort does all the work for you and array search provides the keys   array search   returns false when it can t find a match so items that are not in the sort array naturally move to the bottom of the array   Note  uasort   will order the array without affecting the key    value relationships

User · Answer

There you go   function sortArrayByArray array  array  array  orderArray         ordered   array        foreach   orderArray as  key            if  array key exists  key   array                  ordered  key     array  key               unset  array  key                        return  ordered    array

User · Answer

How about this solution   order   array 1 5 2 4 3 6     array   array      1   gt   one       2   gt   two       3   gt   three       4   gt   four       5   gt   five       6   gt   six      uksort  array  function  key1   key2  use   order        return  array search  key1   order   gt  array search  key2   order

User · Answer

Without magic      array array 28  gt c 4  gt b 5  gt a    seq array 5 4 28       SortByKeyList  array  seq  result  array 5  gt a 4  gt b 28  gt c    function sortByKeyList  array  seq        ret array        if empty  array     empty  seq   return false      foreach  seq as  key   ret  key   dataset  key        return  ret

User · Answer

Another way for PHP    5 3 0    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     customerSorted   array replace array flip array  name    dob    address      customer     Result   Array      name    gt  Tim    dob    gt  12 08 1986    address    gt  123 fake st    dontSortMe    gt  this value doesnt need to be sorted     Works fine with string and numeric keys

User · Answer

First Suggestion    function sortArrayByArray  array  orderArray         ordered   array        foreach  orderArray as  key            if array key exists  key  array                  ordered  key     array  key               unset  array  key                        return  ordered    array      Second Suggestion   properOrderedArray   array merge array flip array  name    dob    address      customer     I wanted to point out that both of these suggestions are awesome  However  they are apples and oranges  The difference  One is non-associative friendly and the other is associative friendly  If you are using 2 fully associative arrays then the array merge flip will actually merge and overwrite the other associative array  In my case that is not the results I was looking for  I used a settings ini file to create my sort order array  The data array I was sorting did not need to written over by my associative sorting counterpart  Thus array merge would destroy my data array  Both are great methods  both need to be archived in any developers toolbox  Based on your needs you may find you actually need both concepts in your archives

User · Answer

IF you have array in your array  you ll have to adapt the function by Eran a little bit     function sortArrayByArray  array  orderArray         ordered   array        foreach  orderArray as  key   gt   value            if array key exists  key  array                      ordered  key     array  key                   unset  array  key                        return  ordered    array

User · Answer

I used the Darkwaltz4 s solution but used array fill keys instead of array flip  to fill with NULL if a key is not set in  array    properOrderedArray   array replace array fill keys  keys  null    array

User · Answer

sort as requested save for int-keys  because of array replace  don t return keys are not existing in inputArray  optionally  filter keys no existing in given keyList   Code           sort keys like in key list    filter  remove keys are not listed in keyList      c   gt  red    d   gt  2016-12-29     sortAndFilterKeys   d   gt  2016-12-29    c   gt  red    a   gt 3       c    d    z            param array  inputArray     param string   int    keyList     param bool  removeUnknownKeys     return array     static public function sortAndFilterKeys  inputArray   keyList   removeUnknownKeys true        keysAsKeys   array flip  keyList        result   array replace  keysAsKeys   inputArray      result   sorted keys   values from input         result   array intersect key  result   inputArray      remove keys are not existing in inputArray      if   removeUnknownKeys             result   array intersect key  result   keysAsKeys      remove keys are not existing in keyList            return  result

User · Answer

function sortArrayByArray array  toSort  array  sortByValuesAsKeys         commonKeysInOrder   array intersect key array flip  sortByValuesAsKeys    toSort        commonKeysWithValue   array intersect key  toSort   commonKeysInOrder        sorted   array merge  commonKeysInOrder   commonKeysWithValue       return  sorted

User · Answer

sort as requested save for int-keys  because of array replace  don t return keys are not existing in inputArray  optionally  filter keys no existing in given keyList   Code           sort keys like in key list    filter  remove keys are not listed in keyList      c   gt  red    d   gt  2016-12-29     sortAndFilterKeys   d   gt  2016-12-29    c   gt  red    a   gt 3       c    d    z            param array  inputArray     param string   int    keyList     param bool  removeUnknownKeys     return array     static public function sortAndFilterKeys  inputArray   keyList   removeUnknownKeys true        keysAsKeys   array flip  keyList        result   array replace  keysAsKeys   inputArray      result   sorted keys   values from input         result   array intersect key  result   inputArray      remove keys are not existing in inputArray      if   removeUnknownKeys             result   array intersect key  result   keysAsKeys      remove keys are not existing in keyList            return  result

User · Answer

There you go   function sortArrayByArray array  array  array  orderArray         ordered   array        foreach   orderArray as  key            if  array key exists  key   array                  ordered  key     array  key               unset  array  key                        return  ordered    array

User · Answer

How about this solution   order   array 1 5 2 4 3 6     array   array      1   gt   one       2   gt   two       3   gt   three       4   gt   four       5   gt   five       6   gt   six      uksort  array  function  key1   key2  use   order        return  array search  key1   order   gt  array search  key2   order

User · Answer

PHP has functions to help you with this    arrayToBeSorted   array  west    east    south    north     order   array  north    south    east    west        sort array usort  arrayToBeSorted  function  a   b  use   order          sort using the numeric index of the second array      valA   array search  a   order        valB   array search  b   order           move items that don t match to end     if   valA     false          return -1      if   valB     false          return 0       if   valA  gt   valB          return 1      if   valA  lt   valB          return -1      return 0        Usort does all the work for you and array search provides the keys   array search   returns false when it can t find a match so items that are not in the sort array naturally move to the bottom of the array   Note  uasort   will order the array without affecting the key    value relationships

User · Answer

There you go   function sortArrayByArray array  array  array  orderArray         ordered   array        foreach   orderArray as  key            if  array key exists  key   array                  ordered  key     array  key               unset  array  key                        return  ordered    array

User · Answer

First Suggestion    function sortArrayByArray  array  orderArray         ordered   array        foreach  orderArray as  key            if array key exists  key  array                  ordered  key     array  key               unset  array  key                        return  ordered    array      Second Suggestion   properOrderedArray   array merge array flip array  name    dob    address      customer     I wanted to point out that both of these suggestions are awesome  However  they are apples and oranges  The difference  One is non-associative friendly and the other is associative friendly  If you are using 2 fully associative arrays then the array merge flip will actually merge and overwrite the other associative array  In my case that is not the results I was looking for  I used a settings ini file to create my sort order array  The data array I was sorting did not need to written over by my associative sorting counterpart  Thus array merge would destroy my data array  Both are great methods  both need to be archived in any developers toolbox  Based on your needs you may find you actually need both concepts in your archives

User · Answer

Another way for PHP    5 3 0    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     customerSorted   array replace array flip array  name    dob    address      customer     Result   Array      name    gt  Tim    dob    gt  12 08 1986    address    gt  123 fake st    dontSortMe    gt  this value doesnt need to be sorted     Works fine with string and numeric keys

User · Answer

Just use array merge or array replace  Array merge works by starting with the array you give it  in the proper order  and overwriting adding the keys with data from your actual array    customer  address      123 fake st    customer  name      Tim    customer  dob      12 08 1986    customer  dontSortMe      this value doesnt need to be sorted     properOrderedArray   array merge array flip array  name    dob    address      customer     Or   properOrderedArray   array replace array flip array  name    dob    address      customer       properOrderedArray - gt  array  name    gt   Tim    address    gt   123 fake st    dob    gt   12 08 1986    dontSortMe    gt   this value doesnt need to be sorted     ps - I m answering this  stale  question  because I think all the loops given as previous answers are overkill

User · Answer

I used the Darkwaltz4 s solution but used array fill keys instead of array flip  to fill with NULL if a key is not set in  array    properOrderedArray   array replace array fill keys  keys  null    array

[php] Sort an Array by keys based on another Array?

Examples related to php

Examples related to arrays

Examples related to sorting