how to add default array to given array list?

Question

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'];
}

@executable here is his sample data ^^ stackoverflow.com/questions/54004483/… — Anuga
– Anuga, Commented Jan 3, 2019 at 9:19
This question would be a lot simpler if you would just provide sample input and sample output. E.g. bpaste.net/raw/0de604fbd6ea — xate
– xate, Commented Jan 3, 2019 at 9:19

Dinesh Belkare · Accepted Answer · 2019-01-03 09:27:48Z

1

$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

answered Jan 3, 2019 at 9:27

Dinesh Belkare

6318 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to add default array to given array list?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related