Php, create new array on basis of value missing for key

Question

I have a multidimensional array:

$array = array(
    array(
        "name" => "one",
        "date" => "2016-10-10",
        "data"=> 30
    ),
    array(
        "name" => "one",
        "date" => "2016-10-11",
        "data"=> 30
    ),
    array(
        "name" => "two",
        "date" => "2016-10-10",
        "data"=> 40
    )
);

Now I want to merge the difference of arrays, like if an array (name => one) has two dates (2016-10-10 and 2016-10-10) but array (name => two) has only one date (2016-10-10), I want to add 2016-10-11 with array (name => two).

array(
    "name" => "two",
    "date" => "2016-10-11",
    "data"=> 0
)

It difficult to express what really i want :) in short actually i want to add array( "name" => "two", "date" => "2016-10-11", "data"=> 0 ) this. — Zeeshan
– Zeeshan, Commented Dec 1, 2017 at 16:39
array "name" => "two", don't have the date 2016-10-11 like array "name"=>"one" have, i just want to add this. — Zeeshan
– Zeeshan, Commented Dec 1, 2017 at 16:41
You want to add the new array with a name of "two" to the original array? — MCMXCII
– MCMXCII, Commented Dec 1, 2017 at 16:52

Don't Panic · Accepted Answer · 2017-12-01 17:01:20Z

1

There may be a simpler way I haven't thought of, but I think it looks like the solution takes three steps.

Group your values by date

foreach ($array as $row) {
    $dates[$row['date']][$row['name']] = $row['data'];
}

Get a unique list of all the names

$names = array_unique(array_column($array, 'name'));

Iterate the date groups and fill the missing values into your original array.

foreach ($dates as $date => $date_names) {
    foreach ($names as $name) {
        if (!isset($date_names[$name])) {
            $array[] = ['name' => $name, 'date' => $date, 'data' => 0];
        }
    }
}

(This should also work the same if you group by name and get a unique list of dates.)

answered Dec 1, 2017 at 17:01

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

1 Comment

Zeeshan Over a year ago

That's Perfect. :) Thank you.

Collectives™ on Stack Overflow

Php, create new array on basis of value missing for key

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related