How to group subarrays by a column value

Question

I have the following array Array        0    gt  Array                        id    gt  96              shipping no    gt  212755-1              part no    gt  reterty              description    gt  tyrfyt              packaging type    gt  PC                 1    gt  Array                        id    gt  96              shipping no    gt  212755-1              part no    gt  dftgtryh              description    gt  dfhgfyh              packaging type    gt  PC                 2    gt  Array                        id    gt  97              shipping no    gt  212755-2              part no    gt  ZeoDark              description    gt  s c s c s              packaging type    gt  PC               How can I group the array by id  Is there any native php functions are available to do this  While this approach works  I want to do this using a foreach  since with the above I will get duplicate items  which I m trying to avoid  On the above example id have 2 items  so its need to be inside of the id

User · Answer

arr   array     foreach  old arr as  key   gt   item        arr  item  id     key     item     ksort  arr  SORT NUMERIC

User · Answer

It s trivial to do with LINQ  which is implemented in PHP in several libraries  including YaLinqo   It allows performing SQL-like queries on arrays and objects  The groubBy function is designed specifically for grouping  you just need to specify the field you want to group by    grouped array   from  array - gt groupBy   v  id    - gt toArray      Where   v  id    is a shorthand for function   v    return  v  id      which this library supports   The result will be exactly like in the accepted answer  just with less code     developed by me

User · Answer

This should group an associative array Ejm Group By Country  function getGroupedArray  array   keyFieldsToGroup            newArray   array         foreach   array as  record            newArray   getRecursiveArray  record   keyFieldsToGroup   newArray        return  newArray    function getRecursiveArray  itemArray   keys   newArray        if  count  keys   gt  1            newArray  itemArray  keys 0      getRecursiveArray  itemArray     array splice  keys  1    newArray  itemArray  keys 0          else          newArray  itemArray  keys 0         itemArray       return  newArray      countries   array array  Country   gt  USA    State   gt  California                       array  Country   gt  USA    State   gt  Alabama                       array  Country   gt  BRA    State   gt  Sao Paulo       grouped   getGroupedArray  countries  array  Country

User · Answer

I think this works better in PHP 5 5    IdVar   array column  data   id

User · Answer

function groupeByPHP  array  indexUnique  assoGroup  keepInOne    retour   array     id    array 0   indexUnique   foreach   keepInOne as  keep        retour  id   keep     array 0   keep     foreach   assoGroup as  cle  gt  arrayKey        arrayGrouped   array            foreach   array as  data               if  data  indexUnique      id                    id    data  indexUnique                   foreach   keepInOne as  keep                        retour  id   keep     data  keep                                               foreach   arrayKey as  val                    arrayGrouped  val     data  val                              retour  id   cle       arrayGrouped               retour  id   cle    array unique  retour  id   cle  SORT REGULAR               return   retour      Try this function   groupeByPHP  yourArray  id  array  desc   gt array  part no   packaging type    array  id   shipping no

User · Answer

for  i   0    i  lt  count  arr      i            tmpArr  arr  i   id       arr  i   id       vmpArr   array keys  tmpArr   print r  vmpArr

User · Answer

In a more functional programming style  you could use array reduce   groupedById   array reduce  data  function  array  accumulator  array  element       accumulator  element  id         element     return  accumulator

User · Answer

arr   Data Araay    fldName   Group By Colum Name   function array group by   arr   fldName         groups   array        foreach   arr as  rec             groups  rec  fldName      rec            return  groups     function object group by   obj   fldName         groups   array        foreach   obj as  rec             groups  rec- gt  fldName     rec            return  groups

User · Answer

There is no native one  just use a loop    result   array    foreach   data as  element         result  element  id         element

User · Answer

1  GROUP BY one key  This function works as GROUP BY for array  but with one important limitation  Only one grouping  column    identifier  is possible   function arrayUniqueByIdentifier array  array  string  identifier         ids   array column  array   identifier        ids   array unique  ids        array   array filter  array          function   key   value  use  ids                return in array  value  array keys  ids               ARRAY FILTER USE BOTH       return  array        2  Detecting the unique rows for a table  twodimensional array   This function is for filtering  rows   If we say  a twodimensional array is a table  then its each element is a row  So  we can remove the duplicated rows with this function  Two rows  elements of the first dimension  are equal  if all their columns  elements of the second dimension  are equal  To the comparsion of  column  values applies  If a value is of a simple type  the value itself will be use on comparing  otherwise its type  array  object  resource  unknown type  will be used   The strategy is simple  Make from the original array a shallow array  where the elements are imploded  columns  of the original array  then apply array unique      on it  and as last use the detected IDs for filtering of the original array   function arrayUniqueByRow array  table       string  implodeSeparator         elementStrings           foreach   table as  row               To avoid notices like  Array to string conversion            elementPreparedForImplode   array map              function   field                     valueType   gettype  field                    simpleTypes     boolean    integer    double    float    string    NULL                     field   in array  valueType   simpleTypes     field    valueType                  return  field                  row                     elementStrings     implode  implodeSeparator   elementPreparedForImplode              elementStringsUnique   array unique  elementStrings        table   array intersect key  table   elementStringsUnique       return  table      It s also possible to improve the comparing  detecting the  column  value s class  if its type is object   The  implodeSeparator should be more or less complex  z B  spl object hash  this      3  Detecting the rows with unique identifier columns for a table  twodimensional array   This solution relies on the 2nd one  Now the complete  row  doesn t need to be unique  Two  rows   elements of the first dimension  are equal now  if all relevant  fields   elements of the second dimension  of the one  row  are equal to the according  fields   elements with the same key    The  relevant   fields  are the  fields   elements of the second dimension   which have key  that equals to one of the elements of the passed  identifiers    function arrayUniqueByMultipleIdentifiers array  table  array  identifiers  string  implodeSeparator   null         arrayForMakingUniqueByRow    removeArrayColumns  table   identifiers  true        arrayUniqueByRow    arrayUniqueByRow  arrayForMakingUniqueByRow   implodeSeparator        arrayUniqueByMultipleIdentifiers   array intersect key  table   arrayUniqueByRow       return  arrayUniqueByMultipleIdentifiers     function removeArrayColumns array  table  array  columnNames  bool  isWhitelist   false        foreach   table as  rowKey   gt   row            if  is array  row                 if   isWhitelist                    foreach   row as  fieldName   gt   fieldValue                        if   in array  fieldName   columnNames                             unset  table  rowKey   fieldName                                                          else                   foreach   row as  fieldName   gt   fieldValue                        if  in array  fieldName   columnNames                             unset  table  rowKey   fieldName                                                                              return  table

User · Answer

Consume and cache the column value that you want to group by  then push the remaining data as a new subarray of the group you have created in the the result  function array group array  data   by column         result           foreach   data as  item             column    item  by column           unset  item  by column             result  column       item            return  result

User · Answer

Recursive function grouping 2-dimensional array by keys from first to last Input    arr   array       0    gt  array           key0    gt   value0            key1    gt   value1            key2    gt   value02               2    gt  array           key0    gt   value0            key1    gt   value1            key2    gt   value12               3    gt  array           key0    gt   value0            key1    gt   value3            key2    gt   value22              keys   array  key0    key1    key2      Output    arr   array       value0    gt  array           value1   gt  array               value02    gt  null               value12    gt  null                      value3    gt   value22               Code   function array group by keys  amp  arr   keys         if  count  arr   lt  2            arr   array shift  arr 0            return             foreach   arr as  k   gt   item             fvalue   array shift  item            arr  fvalue       item          unset  arr  k               array shift  keys       foreach   arr as  amp  sub arr            array group by keys  sub arr   keys

User · Answer

You can try the following    group   array     foreach    array as  value          group  value  id         value     var dump  group     Output   array   96   gt       array       0   gt           array            id    gt  int 96            shipping no    gt  string  212755-1   length 8             part no    gt  string  reterty   length 7             description    gt  string  tyrfyt   length 6             packaging type    gt  string  PC   length 2        1   gt           array            id    gt  int 96            shipping no    gt  string  212755-1   length 8             part no    gt  string  dftgtryh   length 8             description    gt  string  dfhgfyh   length 7             packaging type    gt  string  PC   length 2    97   gt       array       0   gt           array            id    gt  int 97            shipping no    gt  string  212755-2   length 8             part no    gt  string  ZeoDark   length 7             description    gt  string  s c s c s   length 9             packaging type    gt  string  PC   length 2

User · Answer

I just threw this together  inspired by  NET LINQ   lt  php     callable type hint may be  closure  type hint instead  depending on php version function array group by array  arr  callable  key selector       result   array      foreach   arr as  i         key   call user func  key selector   i        result  key       i          return  result       data   array          array 1   Andy    PHP            array 1   Andy    C             array 2   Josh    C             array 2   Josh    ASP            array 1   Andy    SQL            array 3   Steve    SQL             grouped   array group by  data  function  i    return  i 0        var dump  grouped      gt    And voila you get  array 3       1   gt    array 3         0   gt      array 3           0   gt        int 1         1   gt        string 4   Andy         2   gt        string 3   PHP             1   gt      array 3           0   gt        int 1         1   gt        string 4   Andy         2   gt        string 2   C              2   gt      array 3           0   gt        int 1         1   gt        string 4   Andy         2   gt        string 3   SQL               2   gt    array 2         0   gt      array 3           0   gt        int 2         1   gt        string 4   Josh         2   gt        string 2   C              1   gt      array 3           0   gt        int 2         1   gt        string 4   Josh         2   gt        string 3   ASP               3   gt    array 1         0   gt      array 3           0   gt        int 3         1   gt        string 5   Steve         2   gt        string 3   SQL

User · Answer

Expanding on  baba s answer  which I like  but creates a more complex three level deep multi-dimensional  array array array       group   array     foreach    array as  value         group  value  id         value          output only data from id 96 foreach   group as  key  gt  value      outer loop  foreach   value as  k  gt  v     inner loop   if  key  96     if outer loop is equal to 96  could be variable     for   i 0  i lt count  k   i       iterate over the inner loop         printf  key   has a part no  of    v  part no     and shipping no  of    v  shipping no     lt br gt                    Will output   96 has a part no  of reterty and shipping number of 212755-1  96 has a part no  of dftgtryh and shipping number of 212755-1

User · Answer

function array group by  arr  array  keys     if   is array  arr         trigger error  array group by    The first argument should be an array   E USER ERROR     if  count  keys   0        trigger error  array group by    The Second argument Array can not be empty   E USER ERROR         Load the new array  splitting by the target key  grouped       foreach   arr as  value         grouped  value  keys 0         value        Recursively build a nested grouping if more parameters are supplied    Each grouped array value is grouped according to the next sequential key if  count  keys   gt  1            foreach   grouped as  key   gt   value            parms   array merge   value    array slice  keys  1 count  keys              grouped  key    call user func array  array group by    parms            return  grouped

User · Answer

This array group by function achieves what you are looking for    grouped   array group by  arr   id      It even supports multi-level groupings    grouped   array group by  arr   id    part no

User · Answer

Check indexed function from Nspl   use function  nspl a indexed   grouped   indexed  data   id

[php] How to group subarrays by a column value?

Examples related to php

Examples related to arrays

Examples related to grouping