fork download
copy 
  1. <?php
  2.  
  3. $orders = [
  4.     [
  5.         'orderID' => 1,
  6.         'Name' => 'Sam',
  7.         'orderList' => [
  8.             ['SKU' => 'A001', 'Qty' => 2],
  9.             ['SKU' => 'A003', 'Qty' => 4]
  10.         ]
  11.     ],
  12.     [
  13.         'orderID' => 2,
  14.         'Name' => 'Sam',
  15.         'orderList' => [
  16.             ['SKU' => 'A001', 'Qty' => 1],
  17.             ['SKU' => 'A002', 'Qty' => 1]
  18.         ]
  19.     ],
  20.     [
  21.         'orderID' => 3,
  22.         'Name' => 'Sam',
  23.         'orderList' => [
  24.             ['SKU' => 'A001', 'Qty' => 2],
  25.             ['SKU' => 'A004', 'Qty' => 2]
  26.         ]
  27.     ],
  28.     [
  29.         'orderID' => 4,
  30.         'Name' => 'Sam',
  31.         'orderList' => [
  32.             ['SKU' => 'A003', 'Qty' => 3],
  33.             ['SKU' => 'A002', 'Qty' => 1]
  34.         ]
  35.     ],
  36.     [
  37.         'orderID' => 5,
  38.         'Name' => 'Sam',
  39.         'orderList' => [
  40.             ['SKU' => 'A002', 'Qty' => 1],
  41.             ['SKU' => 'A003', 'Qty' => 1]
  42.         ]
  43.     ]
  44. ];
  45.  
  46. $skuTotals = [];
  47.  
  48. foreach ($orders as $order) {
  49.     foreach ($order['orderList'] as $item) {
  50.         if (array_key_exists($item['SKU'], $skuTotals)) {
  51.             $skuTotals[$item['SKU']] += $item['Qty'];
  52.         } else {
  53.             $skuTotals[$item['SKU']] = $item['Qty'];
  54.         }
  55.     }
  56. }
  57.  
  58. echo "<table>";
  59. echo "<tr><th>item</th><th>Qty</th></tr>";
  60.  
  61. foreach ($skuTotals as $sku => $qty) {
  62.     echo "<tr><td>$sku</td><td>$qty</td></tr>";
  63. }
  64.  
  65. echo "</table>";
Success #stdin #stdout 0.03s 26208KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
<table><tr><th>item</th><th>Qty</th></tr><tr><td>A001</td><td>5</td></tr><tr><td>A003</td><td>8</td></tr><tr><td>A002</td><td>3</td></tr><tr><td>A004</td><td>2</td></tr></table>
https://ideone.com/5cVy33
language:
PHP (php 7.3.5)
created:
87 days ago
visibility:
secret

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!