CODEWITHSUNDEEP
php
user1687891
user1687891

Reputation: 864

how to add default array to given array list?

From the query, I get name year and month name and its rate. From the query some year have only 4 months. So how can I add other missing months with default rate 0.0 to following array?

$data = array();
foreach($result as $key => $val){
    $data[$val['name']][$val['year']][date('F', strtotime("2000-".$val['month']."-01"))]= $val['rate'];
}

Upvotes: 0

Views: 57

Answers (1)

Dinesh Belkare
Dinesh Belkare

Reputation: 631

$data = array();
foreach($result as $key => $val){
    if(!isset($data[$val['name']][$val['year']])) {
        //Initialize year array
        $data[$val['name']][$val['year']] = array(
        "January" => "0.0","February" => "0.0","March" => "0.0","April" => "0.0","May" => "0.0","June" => "0.0","July" => "0.0","August" => "0.0","September" => "0.0","October" => "0.0","November" => "0.0","December" => "0.0"
        ); 
    }
    $data[$val['name']][$val['year']][date('F', strtotime("2000-".$val['month']."-01"))]= $val['rate'];
}

Initialize year array as given in above code

Upvotes: 1

Related Questions