Group multidimensional array data based on two column values and sum values of one column in each group

by

This function should do the job.

function groupByPartAndType($input) {
  $output = Array();

  foreach($input as $value) {
    $output_element = &$output[$value['part'] . "_" . $value['type']];
    $output_element['part'] = $value['part'];
    $output_element['type'] = $value['type'];
    !isset($output_element['count']) && $output_element['count'] = 0;
    $output_element['count'] += $value['count'];
  }

  return array_values($output);
}

If both databases are on the same database server you would be able to do this using SQLs GROUP BY feature.

More Related Contents:

  1. How to group a multidimensional array by a particular subarray value?
  2. Group array data on one column and sum data from another column
  3. Group 2d array rows by one column and sum another column [duplicate]
  4. Merge two indexed arrays of indexed arrays based on first column value
  5. Group 2d array data using column value to create a 3d array
  6. Group 2d array data by one column and sum other columns in each group (separately)
  7. Group array data on one column and sum data from another column to form a flat associative array
  8. Group 2d array’s row data by one column and sum another column within each group to produce a reduced 2d array
  9. Merge 2d array rows with same column value and sum another column [duplicate]
  10. Group rows in a 2d array and count number of rows in each respective group
  11. in_array() and multidimensional array
  12. How to group subarrays by a column value?
  13. Sum values of multidimensional array by key without loop
  14. Sorting a php array of arrays by custom order
  15. Cartesian Product of N arrays
  16. How do I sort a multidimensional array by one of the fields of the inner array in PHP? [duplicate]
  17. Sort array of objects by one property
  18. String with array structure to Array [duplicate]
  19. Implode a column of values from a two dimensional array [duplicate]
  20. Recursively remove empty elements and subarrays from a multi-dimensional array
  21. Convert flat array to the multi-dimensional
  22. PHP remove duplicate values from multidimensional array
  23. Checking if array is multidimensional or not?
  24. Dynamic array keys
  25. Converting an array from one to multi-dimensional based on parent ID values
  26. Chunk and transpose a flat array into rows with a specific number of columns
  27. Grouping arrays in PHP
  28. Merge arrays of associative arrays by shared column values
  29. Group subarrays by one column, make comma-separated values from other column within groups
  30. Group array values based on key in php? [duplicate]

Leave a Comment