How do I Sort a Multidimensional Array in PHP

Question

I have CSV data loaded into a multidimensional array  In this way each  row  is a record and each  column  contains the same type of data   I am using the function below to load my CSV file   function f parse csv  file   longest   delimiter       mdarray   array       file      fopen  file   r      while   line   fgetcsv  file   longest   delimiter           array push  mdarray   line         fclose  file     return  mdarray      I need to be able to specify a column to sort so that it rearranges the rows   One of the columns contains date information in the format of Y-m-d H i s and I would like to be able to sort with the most recent date being the first row

User · Answer

I prefer to use array multisort  See the documentation here

User · Answer

You can use array multisort    Try something like this   foreach   mdarray as  key   gt   row           replace 0 with the field s index key      dates  key      row 0      array multisort  dates  SORT DESC   mdarray     For PHP    5 5 0 just extract the column to sort by   No need for the loop   array multisort array column  mdarray  0   SORT DESC   mdarray

User · Answer

Multiple row sorting using a closure  Here s another approach using uasort   and an anonymous callback function  closure   I ve used that function regularly  PHP 5 3 required     no more dependencies          Sorting array of associative arrays - multiple row sorting using a closure     See also  http   the-art-of-web com php sortarray         param array  data input-array     param string array  fields array-keys     license Public Domain     return array     function sortArray   data   field          field    array   field      uasort   data  function  a   b  use  field             retval   0          foreach   field as  fieldname                 if   retval    0    retval   strnatcmp   a  fieldname    b  fieldname                       return  retval               return  data        example     data   array      array   firstname    gt   Mary    lastname    gt   Johnson    age    gt  25        array   firstname    gt   Amanda    lastname    gt   Miller    age    gt  18        array   firstname    gt   James    lastname    gt   Brown    age    gt  31        array   firstname    gt   Patricia    lastname    gt   Williams    age    gt  7        array   firstname    gt   Michael    lastname    gt   Davis    age    gt  43        array   firstname    gt   Sarah    lastname    gt   Miller    age    gt  24        array   firstname    gt   Patrick    lastname    gt   Miller    age    gt  27        data   sortArray   data   age      data   sortArray   data  array   lastname    firstname

User · Answer

You can use array multisort    Try something like this   foreach   mdarray as  key   gt   row           replace 0 with the field s index key      dates  key      row 0      array multisort  dates  SORT DESC   mdarray     For PHP    5 5 0 just extract the column to sort by   No need for the loop   array multisort array column  mdarray  0   SORT DESC   mdarray

User · Answer

The  Usort  function is your answer  http   php net usort

User · Answer

Introducing  a very generalized solution for PHP 5 3   I  d like to add my own solution here  since it offers features that other answers do not   Specifically  advantages of this solution include    It s reusable  you specify the sort column as a variable instead of hardcoding it  It s flexible  you can specify multiple sort columns  as many as you want  -- additional columns are used as tiebreakers between items that initially compare equal  It s reversible  you can specify that the sort should be reversed -- individually for each column  It s extensible  if the data set contains columns that cannot be compared in a  dumb  manner  e g  date strings  you can also specify how to convert these items to a value that can be directly compared  e g  a DateTime instance   It s associative if you want  this code takes care of sorting items  but you select the actual sort function  usort or uasort   Finally  it does not use array multisort  while array multisort is convenient  it depends on creating a projection of all your input data before sorting  This consumes time and memory and may be simply prohibitive if your data set is large    The code  function make comparer            Normalize criteria up front so that the comparer finds everything tidy      criteria   func get args        foreach   criteria as  index   gt   criterion             criteria  index    is array  criterion                array pad  criterion  3  null                array  criterion  SORT ASC  null              return function  first   second  use   amp  criteria            foreach   criteria as  criterion                   How will we compare this round              list  column   sortOrder   projection     criterion               sortOrder    sortOrder     SORT DESC   -1   1                  If a projection was defined project the values now             if   projection                     lhs   call user func  projection   first  column                     rhs   call user func  projection   second  column                              else                    lhs    first  column                    rhs    second  column                                 Do the actual comparison  do not return if equal             if   lhs  lt   rhs                    return -1    sortOrder                            else if   lhs  gt   rhs                    return 1    sortOrder                                   return 0     tiebreakers exhausted  so  first     second            How to use  Throughout this section I will provide links that sort this sample data set    data   array      array  zz    name    gt   Jack    number    gt  22   birthday    gt   12 03 1980        array  xx    name    gt   Adam    number    gt  16   birthday    gt   01 12 1979        array  aa    name    gt   Paul    number    gt  16   birthday    gt   03 11 1987        array  cc    name    gt   Helen    number    gt  44   birthday    gt   24 06 1967         The basics  The function make comparer accepts a variable number of arguments that define the desired sort and returns a function that you are supposed to use as the argument to usort or uasort   The simplest use case is to pass in the key that you  d like to use to compare data items  For example  to sort  data by the name item you would do  usort  data  make comparer  name       See it in action   The key can also be a number if the items are numerically indexed arrays  For the example in the question  this would be  usort  data  make comparer 0       0   first numerically indexed column   See it in action   Multiple sort columns  You can specify multiple sort columns by passing additional parameters to make comparer  For example  to sort by  number  and then by the zero-indexed column   usort  data  make comparer  number   0      See it in action   Advanced features  More advanced features are available if you specify a sort column as an array instead of a simple string  This array should be numerically indexed  and must contain these items   0   gt  the column name to sort on  mandatory  1   gt  either SORT ASC or SORT DESC  optional  2   gt  a projection function  optional    Let s see how we can use these features   Reverse sort  To sort by name descending   usort  data  make comparer   name   SORT DESC       See it in action   To sort by number descending and then by name descending   usort  data  make comparer   number   SORT DESC     name   SORT DESC       See it in action   Custom projections  In some scenarios you may need to sort by a column whose values do not lend well to sorting  The  birthday  column in the sample data set fits this description  it does not make sense to compare birthdays as strings  because e g   01 01 1980  comes before  10 10 1970    In this case we want to specify how to project the actual data to a form that can be compared directly with the desired semantics   Projections can be specified as any type of callable  as strings  arrays  or anonymous functions  A projection is assumed to accept one argument and return its projected form   It should be noted that while projections are similar to the custom comparison functions used with usort and family  they are simpler  you only need to convert one value to another  and take advantage of all the functionality already baked into make comparer   Let s sort the example data set without a projection and see what happens   usort  data  make comparer  birthday       See it in action   That was not the desired outcome  But we can use date create as a projection   usort  data  make comparer   birthday   SORT ASC   date create        See it in action   This is the correct order that we wanted   There are many more things that projections can achieve  For example  a quick way to get a case-insensitive sort is to use strtolower as a projection   That said  I should also mention that it s better to not use projections if your data set is large  in that case it would be much faster to project all your data manually up front and then sort without using a projection  although doing so will trade increased memory usage for faster sort speed   Finally  here is an example that uses all the features  it first sorts by number descending  then by birthday ascending   usort  data  make comparer        number   SORT DESC         birthday   SORT ASC   date create         See it in action

User · Answer

Here is a php4 php5 class that will sort one or more fields      a sorter class     php4 and php5 compatible class Sorter      var  sort fields    var  backwards   false    var  numeric   false     function sort          args   func get args         array    args 0       if    array  return array         this- gt sort fields   array slice  args  1       if    this- gt sort fields  return  array         if   this- gt numeric          usort  array  array  this   numericCompare           else         usort  array  array  this   stringCompare               return  array         function numericCompare  a   b        foreach  this- gt sort fields as  sort field          if   a  sort field      b  sort field             continue                return   a  sort field   lt   b  sort field       this- gt backwards   1   -1      this- gt backwards   -1   1             return 0         function stringCompare  a   b        foreach  this- gt sort fields as  sort field           cmp result   strcasecmp  a  sort field    b  sort field          if   cmp result    0  continue         return   this- gt backwards   - cmp result    cmp result             return 0                                  usage examples     some starting data  start data   array    array  first name    gt   John    last name    gt   Smith    age    gt  10     array  first name    gt   Joe    last name    gt   Smith    age    gt  11     array  first name    gt   Jake    last name    gt   Xample    age    gt  9          sort by last name  then first name  sorter   new Sorter    print r  sorter- gt sort  start data   last name    first name         sort by first name  then last name  sorter   new Sorter    print r  sorter- gt sort  start data   first name    last name         sort by last name  then first name  backwards   sorter   new Sorter     sorter- gt backwards   true  print r  sorter- gt sort  start data   last name    first name         sort numerically by age  sorter   new Sorter     sorter- gt numeric   true  print r  sorter- gt sort  start data   age

User · Answer

I prefer to use array multisort  See the documentation here

User · Answer

The  Usort  function is your answer  http   php net usort

User · Answer

Here is a php4 php5 class that will sort one or more fields      a sorter class     php4 and php5 compatible class Sorter      var  sort fields    var  backwards   false    var  numeric   false     function sort          args   func get args         array    args 0       if    array  return array         this- gt sort fields   array slice  args  1       if    this- gt sort fields  return  array         if   this- gt numeric          usort  array  array  this   numericCompare           else         usort  array  array  this   stringCompare               return  array         function numericCompare  a   b        foreach  this- gt sort fields as  sort field          if   a  sort field      b  sort field             continue                return   a  sort field   lt   b  sort field       this- gt backwards   1   -1      this- gt backwards   -1   1             return 0         function stringCompare  a   b        foreach  this- gt sort fields as  sort field           cmp result   strcasecmp  a  sort field    b  sort field          if   cmp result    0  continue         return   this- gt backwards   - cmp result    cmp result             return 0                                  usage examples     some starting data  start data   array    array  first name    gt   John    last name    gt   Smith    age    gt  10     array  first name    gt   Joe    last name    gt   Smith    age    gt  11     array  first name    gt   Jake    last name    gt   Xample    age    gt  9          sort by last name  then first name  sorter   new Sorter    print r  sorter- gt sort  start data   last name    first name         sort by first name  then last name  sorter   new Sorter    print r  sorter- gt sort  start data   first name    last name         sort by last name  then first name  backwards   sorter   new Sorter     sorter- gt backwards   true  print r  sorter- gt sort  start data   last name    first name         sort numerically by age  sorter   new Sorter     sorter- gt numeric   true  print r  sorter- gt sort  start data   age

User · Answer

With usort  Here s a generic solution  that you can use for different columns   class TableSorter     protected  column    function   construct  column         this- gt column    column        function sort  table        usort  table  array  this   compare         return  table        function compare  a   b        if   a  this- gt column      b  this- gt column           return 0            return   a  this- gt column   lt   b  this- gt column     -1   1          To sort by first column    sorter   new TableSorter 0      sort by first column  mdarray    sorter- gt sort  mdarray

User · Answer

You can use array multisort    Try something like this   foreach   mdarray as  key   gt   row           replace 0 with the field s index key      dates  key      row 0      array multisort  dates  SORT DESC   mdarray     For PHP    5 5 0 just extract the column to sort by   No need for the loop   array multisort array column  mdarray  0   SORT DESC   mdarray

User · Answer

I tried several popular array multisort   and usort   answers and none of them worked for me   The data just gets jumbled and the code is unreadable   Here s a quick a dirty solution   WARNING  Only use this if you re sure a rogue delimiter won t come back to haunt you later    Let s say each row in your multi array looks like  name  stuff1  stuff2      Sort by name  pull the other stuff along for the ride foreach   names stuff as  name stuff           To sort by stuff1  that would be first in the contatenation      sorted names      name stuff 0        name stuff 1         name stuff 2     sort  sorted names  SORT STRING     Need your stuff back in alphabetical order   foreach   sorted names as  sorted name         name stuff   explode      sorted name          use your  name stuff 0          use your  name stuff 1                   Yeah  it s dirty   But super easy  won t make your head explode

User · Answer

The  Usort  function is your answer  http   php net usort

User · Answer

You can sort an array using usort function    array   array    array  price   gt  1000 50   product   gt  product 1      array  price   gt  8800 50   product   gt  product 2      array  price   gt  200 0   product   gt  product 3       function cmp  a   b      return  a  price    gt   b  price      usort  array   quot cmp quot    print r  array    Output   Array        0    gt  Array                        price    gt  134 50              product    gt  product 1                 1    gt  Array                        price    gt  2033 0              product    gt  product 3                 2    gt  Array                        price    gt  8340 50              product    gt  product 2               Example

User · Answer

Before I could get the TableSorter class to run I had came up with a function based on what Shinhan had provided   function sort2d bycolumn  array   column   method   has header        if   has header    header   array shift  array     foreach   array as  key     row         narray  key      row  column            array multisort  narray   method   array     if   has header  array unshift  array   header     return  array         array is the MD Array you want to sort   column is the column you wish to sort by   method is how you want the sort performed  such as SORT DESC  has header is set to true if the first row contains header values that you don t want sorted

User · Answer

With usort  Here s a generic solution  that you can use for different columns   class TableSorter     protected  column    function   construct  column         this- gt column    column        function sort  table        usort  table  array  this   compare         return  table        function compare  a   b        if   a  this- gt column      b  this- gt column           return 0            return   a  this- gt column   lt   b  this- gt column     -1   1          To sort by first column    sorter   new TableSorter 0      sort by first column  mdarray    sorter- gt sort  mdarray

User · Answer

You can sort an array using usort function    array   array    array  price   gt  1000 50   product   gt  product 1      array  price   gt  8800 50   product   gt  product 2      array  price   gt  200 0   product   gt  product 3       function cmp  a   b      return  a  price    gt   b  price      usort  array   quot cmp quot    print r  array    Output   Array        0    gt  Array                        price    gt  134 50              product    gt  product 1                 1    gt  Array                        price    gt  2033 0              product    gt  product 3                 2    gt  Array                        price    gt  8340 50              product    gt  product 2               Example

User · Answer

I prefer to use array multisort  See the documentation here

User · Answer

Before I could get the TableSorter class to run I had came up with a function based on what Shinhan had provided   function sort2d bycolumn  array   column   method   has header        if   has header    header   array shift  array     foreach   array as  key     row         narray  key      row  column            array multisort  narray   method   array     if   has header  array unshift  array   header     return  array         array is the MD Array you want to sort   column is the column you wish to sort by   method is how you want the sort performed  such as SORT DESC  has header is set to true if the first row contains header values that you don t want sorted

User · Answer

I know it s 2 years since this question was asked and answered  but here s another function that sorts a two-dimensional array  It accepts a variable number of arguments  allowing you to pass in more than one key  ie column name  to sort by  PHP 5 3 required   function sort multi array   array   key       keys   array      for   i 1  i lt func num args    i           keys  i-1    func get arg  i             create a custom search function to pass to usort    func   function   a   b  use   keys        for   i 0  i lt count  keys   i            if   a  keys  i       b  keys  i              return   a  keys  i    lt   b  keys  i      -1   1                    return 0          usort  array   func      return  array      Try it here  http   www exorithm com algorithm view sort multi array

User · Answer

The  Usort  function is your answer  http   php net usort

User · Answer

Here is a php4 php5 class that will sort one or more fields      a sorter class     php4 and php5 compatible class Sorter      var  sort fields    var  backwards   false    var  numeric   false     function sort          args   func get args         array    args 0       if    array  return array         this- gt sort fields   array slice  args  1       if    this- gt sort fields  return  array         if   this- gt numeric          usort  array  array  this   numericCompare           else         usort  array  array  this   stringCompare               return  array         function numericCompare  a   b        foreach  this- gt sort fields as  sort field          if   a  sort field      b  sort field             continue                return   a  sort field   lt   b  sort field       this- gt backwards   1   -1      this- gt backwards   -1   1             return 0         function stringCompare  a   b        foreach  this- gt sort fields as  sort field           cmp result   strcasecmp  a  sort field    b  sort field          if   cmp result    0  continue         return   this- gt backwards   - cmp result    cmp result             return 0                                  usage examples     some starting data  start data   array    array  first name    gt   John    last name    gt   Smith    age    gt  10     array  first name    gt   Joe    last name    gt   Smith    age    gt  11     array  first name    gt   Jake    last name    gt   Xample    age    gt  9          sort by last name  then first name  sorter   new Sorter    print r  sorter- gt sort  start data   last name    first name         sort by first name  then last name  sorter   new Sorter    print r  sorter- gt sort  start data   first name    last name         sort by last name  then first name  backwards   sorter   new Sorter     sorter- gt backwards   true  print r  sorter- gt sort  start data   last name    first name         sort numerically by age  sorter   new Sorter     sorter- gt numeric   true  print r  sorter- gt sort  start data   age

User · Answer

With usort  Here s a generic solution  that you can use for different columns   class TableSorter     protected  column    function   construct  column         this- gt column    column        function sort  table        usort  table  array  this   compare         return  table        function compare  a   b        if   a  this- gt column      b  this- gt column           return 0            return   a  this- gt column   lt   b  this- gt column     -1   1          To sort by first column    sorter   new TableSorter 0      sort by first column  mdarray    sorter- gt sort  mdarray

User · Answer

Introducing  a very generalized solution for PHP 5 3   I  d like to add my own solution here  since it offers features that other answers do not   Specifically  advantages of this solution include    It s reusable  you specify the sort column as a variable instead of hardcoding it  It s flexible  you can specify multiple sort columns  as many as you want  -- additional columns are used as tiebreakers between items that initially compare equal  It s reversible  you can specify that the sort should be reversed -- individually for each column  It s extensible  if the data set contains columns that cannot be compared in a  dumb  manner  e g  date strings  you can also specify how to convert these items to a value that can be directly compared  e g  a DateTime instance   It s associative if you want  this code takes care of sorting items  but you select the actual sort function  usort or uasort   Finally  it does not use array multisort  while array multisort is convenient  it depends on creating a projection of all your input data before sorting  This consumes time and memory and may be simply prohibitive if your data set is large    The code  function make comparer            Normalize criteria up front so that the comparer finds everything tidy      criteria   func get args        foreach   criteria as  index   gt   criterion             criteria  index    is array  criterion                array pad  criterion  3  null                array  criterion  SORT ASC  null              return function  first   second  use   amp  criteria            foreach   criteria as  criterion                   How will we compare this round              list  column   sortOrder   projection     criterion               sortOrder    sortOrder     SORT DESC   -1   1                  If a projection was defined project the values now             if   projection                     lhs   call user func  projection   first  column                     rhs   call user func  projection   second  column                              else                    lhs    first  column                    rhs    second  column                                 Do the actual comparison  do not return if equal             if   lhs  lt   rhs                    return -1    sortOrder                            else if   lhs  gt   rhs                    return 1    sortOrder                                   return 0     tiebreakers exhausted  so  first     second            How to use  Throughout this section I will provide links that sort this sample data set    data   array      array  zz    name    gt   Jack    number    gt  22   birthday    gt   12 03 1980        array  xx    name    gt   Adam    number    gt  16   birthday    gt   01 12 1979        array  aa    name    gt   Paul    number    gt  16   birthday    gt   03 11 1987        array  cc    name    gt   Helen    number    gt  44   birthday    gt   24 06 1967         The basics  The function make comparer accepts a variable number of arguments that define the desired sort and returns a function that you are supposed to use as the argument to usort or uasort   The simplest use case is to pass in the key that you  d like to use to compare data items  For example  to sort  data by the name item you would do  usort  data  make comparer  name       See it in action   The key can also be a number if the items are numerically indexed arrays  For the example in the question  this would be  usort  data  make comparer 0       0   first numerically indexed column   See it in action   Multiple sort columns  You can specify multiple sort columns by passing additional parameters to make comparer  For example  to sort by  number  and then by the zero-indexed column   usort  data  make comparer  number   0      See it in action   Advanced features  More advanced features are available if you specify a sort column as an array instead of a simple string  This array should be numerically indexed  and must contain these items   0   gt  the column name to sort on  mandatory  1   gt  either SORT ASC or SORT DESC  optional  2   gt  a projection function  optional    Let s see how we can use these features   Reverse sort  To sort by name descending   usort  data  make comparer   name   SORT DESC       See it in action   To sort by number descending and then by name descending   usort  data  make comparer   number   SORT DESC     name   SORT DESC       See it in action   Custom projections  In some scenarios you may need to sort by a column whose values do not lend well to sorting  The  birthday  column in the sample data set fits this description  it does not make sense to compare birthdays as strings  because e g   01 01 1980  comes before  10 10 1970    In this case we want to specify how to project the actual data to a form that can be compared directly with the desired semantics   Projections can be specified as any type of callable  as strings  arrays  or anonymous functions  A projection is assumed to accept one argument and return its projected form   It should be noted that while projections are similar to the custom comparison functions used with usort and family  they are simpler  you only need to convert one value to another  and take advantage of all the functionality already baked into make comparer   Let s sort the example data set without a projection and see what happens   usort  data  make comparer  birthday       See it in action   That was not the desired outcome  But we can use date create as a projection   usort  data  make comparer   birthday   SORT ASC   date create        See it in action   This is the correct order that we wanted   There are many more things that projections can achieve  For example  a quick way to get a case-insensitive sort is to use strtolower as a projection   That said  I should also mention that it s better to not use projections if your data set is large  in that case it would be much faster to project all your data manually up front and then sort without using a projection  although doing so will trade increased memory usage for faster sort speed   Finally  here is an example that uses all the features  it first sorts by number descending  then by birthday ascending   usort  data  make comparer        number   SORT DESC         birthday   SORT ASC   date create         See it in action

User · Answer

I know it s 2 years since this question was asked and answered  but here s another function that sorts a two-dimensional array  It accepts a variable number of arguments  allowing you to pass in more than one key  ie column name  to sort by  PHP 5 3 required   function sort multi array   array   key       keys   array      for   i 1  i lt func num args    i           keys  i-1    func get arg  i             create a custom search function to pass to usort    func   function   a   b  use   keys        for   i 0  i lt count  keys   i            if   a  keys  i       b  keys  i              return   a  keys  i    lt   b  keys  i      -1   1                    return 0          usort  array   func      return  array      Try it here  http   www exorithm com algorithm view sort multi array

User · Answer

With usort  Here s a generic solution  that you can use for different columns   class TableSorter     protected  column    function   construct  column         this- gt column    column        function sort  table        usort  table  array  this   compare         return  table        function compare  a   b        if   a  this- gt column      b  this- gt column           return 0            return   a  this- gt column   lt   b  this- gt column     -1   1          To sort by first column    sorter   new TableSorter 0      sort by first column  mdarray    sorter- gt sort  mdarray

User · Answer

I tried several popular array multisort   and usort   answers and none of them worked for me   The data just gets jumbled and the code is unreadable   Here s a quick a dirty solution   WARNING  Only use this if you re sure a rogue delimiter won t come back to haunt you later    Let s say each row in your multi array looks like  name  stuff1  stuff2      Sort by name  pull the other stuff along for the ride foreach   names stuff as  name stuff           To sort by stuff1  that would be first in the contatenation      sorted names      name stuff 0        name stuff 1         name stuff 2     sort  sorted names  SORT STRING     Need your stuff back in alphabetical order   foreach   sorted names as  sorted name         name stuff   explode      sorted name          use your  name stuff 0          use your  name stuff 1                   Yeah  it s dirty   But super easy  won t make your head explode

User · Answer

Here is a php4 php5 class that will sort one or more fields      a sorter class     php4 and php5 compatible class Sorter      var  sort fields    var  backwards   false    var  numeric   false     function sort          args   func get args         array    args 0       if    array  return array         this- gt sort fields   array slice  args  1       if    this- gt sort fields  return  array         if   this- gt numeric          usort  array  array  this   numericCompare           else         usort  array  array  this   stringCompare               return  array         function numericCompare  a   b        foreach  this- gt sort fields as  sort field          if   a  sort field      b  sort field             continue                return   a  sort field   lt   b  sort field       this- gt backwards   1   -1      this- gt backwards   -1   1             return 0         function stringCompare  a   b        foreach  this- gt sort fields as  sort field           cmp result   strcasecmp  a  sort field    b  sort field          if   cmp result    0  continue         return   this- gt backwards   - cmp result    cmp result             return 0                                  usage examples     some starting data  start data   array    array  first name    gt   John    last name    gt   Smith    age    gt  10     array  first name    gt   Joe    last name    gt   Smith    age    gt  11     array  first name    gt   Jake    last name    gt   Xample    age    gt  9          sort by last name  then first name  sorter   new Sorter    print r  sorter- gt sort  start data   last name    first name         sort by first name  then last name  sorter   new Sorter    print r  sorter- gt sort  start data   first name    last name         sort by last name  then first name  backwards   sorter   new Sorter     sorter- gt backwards   true  print r  sorter- gt sort  start data   last name    first name         sort numerically by age  sorter   new Sorter     sorter- gt numeric   true  print r  sorter- gt sort  start data   age

User · Answer

I prefer to use array multisort  See the documentation here

User · Answer

Multiple row sorting using a closure  Here s another approach using uasort   and an anonymous callback function  closure   I ve used that function regularly  PHP 5 3 required     no more dependencies          Sorting array of associative arrays - multiple row sorting using a closure     See also  http   the-art-of-web com php sortarray         param array  data input-array     param string array  fields array-keys     license Public Domain     return array     function sortArray   data   field          field    array   field      uasort   data  function  a   b  use  field             retval   0          foreach   field as  fieldname                 if   retval    0    retval   strnatcmp   a  fieldname    b  fieldname                       return  retval               return  data        example     data   array      array   firstname    gt   Mary    lastname    gt   Johnson    age    gt  25        array   firstname    gt   Amanda    lastname    gt   Miller    age    gt  18        array   firstname    gt   James    lastname    gt   Brown    age    gt  31        array   firstname    gt   Patricia    lastname    gt   Williams    age    gt  7        array   firstname    gt   Michael    lastname    gt   Davis    age    gt  43        array   firstname    gt   Sarah    lastname    gt   Miller    age    gt  24        array   firstname    gt   Patrick    lastname    gt   Miller    age    gt  27        data   sortArray   data   age      data   sortArray   data  array   lastname    firstname

User · Answer

Before I could get the TableSorter class to run I had came up with a function based on what Shinhan had provided   function sort2d bycolumn  array   column   method   has header        if   has header    header   array shift  array     foreach   array as  key     row         narray  key      row  column            array multisort  narray   method   array     if   has header  array unshift  array   header     return  array         array is the MD Array you want to sort   column is the column you wish to sort by   method is how you want the sort performed  such as SORT DESC  has header is set to true if the first row contains header values that you don t want sorted

User · Answer

Before I could get the TableSorter class to run I had came up with a function based on what Shinhan had provided   function sort2d bycolumn  array   column   method   has header        if   has header    header   array shift  array     foreach   array as  key     row         narray  key      row  column            array multisort  narray   method   array     if   has header  array unshift  array   header     return  array         array is the MD Array you want to sort   column is the column you wish to sort by   method is how you want the sort performed  such as SORT DESC  has header is set to true if the first row contains header values that you don t want sorted

User · Answer

You can use array multisort    Try something like this   foreach   mdarray as  key   gt   row           replace 0 with the field s index key      dates  key      row 0      array multisort  dates  SORT DESC   mdarray     For PHP    5 5 0 just extract the column to sort by   No need for the loop   array multisort array column  mdarray  0   SORT DESC   mdarray

[php] How do I Sort a Multidimensional Array in PHP

Examples related to php

Examples related to sorting

Examples related to multidimensional-array