Online PHP editor | refs for X7haS

<?php $dbData = [ ["rate"=>'["1.55","1","1","1"]'], ["rate"=>'["2.55","2.55","2.55","2.55"]'], ["rate"=>'["1","1","1","1"]'], ["rate"=>'["1.55","2.55","3.55","4.56"]'] ]; $rate = array_map(function($a){ return json_decode($a['rate']); },$dbData); var_dump($rate); /* Replace by code above $rate = [ ["1.55","1","1","1"], ["2.55","2.55","2.55","2.55"], ["1","1","1","1"], ["1.2","1.21","1.2","1.2"] ]; */ $results =[]; // Count the columns in the first row for ($i = 0; $i<sizeof ($rate[0]); $i++) { // Extract each column in turn $col = array_column($rate, $i); // Calculate and store the averages $results[]= array_sum($col)/count($col); } var_dump($results);