Online PHP editor | refs for nHijY

<?php $dates = ['01.01.18', '02.01.18', '03.01.18']; //Dates are getting from daterange datepicker and preparing dates using php and stored in array. foreach($dates as $date) { // fetching data from table where date is matching with "$date". $bookings = [ ['date' => '01.01.18', 'beds' => '2'], ['date' => '01.01.18', 'beds' => '3'], ['date' => '01.01.18', 'beds' => '5'], ['date' => '02.01.18', 'beds' => '7'], ['date' => '02.01.18', 'beds' => '6'], ['date' => '02.01.18', 'beds' => '5'], ['date' => '03.01.18', 'beds' => '2'], ['date' => '03.01.18', 'beds' => '5'], ]; } $arr = array(); foreach($bookings as $booking) { $date = $booking['date']; if(array_key_exists($date, $arr)) $arr[$date][] = $booking['beds']; else $arr[$date] = array($booking['beds']); } foreach($arr as $key => $value) { $count = count($value); $sum = array_sum($value); echo "on {$key} I have {$count} bookings and sum of beds is {$sum}\r\n"; }