<?php
$a = [array ( 'id' => '1', 'location' => 'A Capella Salon', 'blankets' => '11', 'sleepingbags' => '0',),
array ( 'id' => '2', 'location' => 'Allegan Library', 'blankets' => '22', 'sleepingbags' => '0', ),
array ( 'id' => '3', 'location' => 'Allegan library', 'blankets' => '13', 'sleepingbags' => '0', ),
array ( 'id' => '4', 'location' => 'Allegan Library', 'blankets' => '12', 'sleepingbags' => '2', ),
array ( 'id' => '5', 'location' => 'Avente', 'blankets' => '2', 'sleepingbags' => '0', ),
array ( 'id' => '6', 'location' => 'Biggby - Paw Paw ', 'blankets' => '10', 'sleepingbags' => '1', ),
array ( 'id' => '7', 'location' => 'Biggby - Paw Paw ', 'blankets' => '3', 'sleepingbags' => '0', ),
array ( 'id' => '8', 'location' => 'Biggby - Plainwell', 'blankets' => '7', 'sleepingbags' => '1', ),array ( 'id' => '9', 'location' => 'Biggby - Plainwell', 'blankets' => '7', 'sleepingbags' => '0', ),array ( 'id' => '10', 'location' => 'Biggby - Plainwell', 'blankets' => '7', 'sleepingbags' => '0', ),array ( 'id' => '11', 'location' => 'Biggby - Plainwell', 'blankets' => '5', 'sleepingbags' => '0', ),array ( 'id' => '12', 'location' => 'Biggby - Plainwell', 'blankets' => '2', 'sleepingbags' => '2', ),array ( 'id' => '13', 'location' => 'Biggby - Sprinkle', 'blankets' => '20', 'sleepingbags' => '0', ),array ( 'id' => '14', 'location' => 'Biggby - Sprinkle', 'blankets' => '5', 'sleepingbags' => '0', ),array ( 'id' => '15', 'location' => 'Biggby - West Main', 'blankets' => '10', 'sleepingbags' => '0', ),array ( 'id' => '16', 'location' => 'Biggby - Westnedge 311', 'blankets' => '6', 'sleepingbags' => '0', ),array ( 'id' => '17', 'location' => 'Biggby - Westnedge 311', 'blankets' => '2', 'sleepingbags' => '0', ),array ( 'id' => '18', 'location' => 'Biggby - Westnedge 311', 'blankets' => '1', 'sleepingbags' => '0', ),array ( 'id' => '19', 'location' => 'Biggby - Westnedge BestBuy', 'blankets' => '4', 'sleepingbags' => '0', ),array ( 'id' => '20', 'location' => 'Biggby - Williamston', 'blankets' => '21', 'sleepingbags' => '9', )];
$sumBlankets = [];
foreach ($a as $row) {
$k = $row['location']; // important
if (!array_key_exists($k, $sumBlankets)) {
$sumBlankets[$k] = ['blankets'=>0, 'sleepingbags'=>0];
}
$sumBlankets[$k]['blankets'] += $row['blankets'];
$sumBlankets[$k]['sleepingbags'] += $row['sleepingbags'];
}
var_export( $sumBlankets );
preferences:
56.16 ms | 402 KiB | 5 Q