Sorting and merge associative array (PHP)

Question

I have 2 associative arrays:

[0] => Array (
    [time] => 09:00:00
    [name] => To do something 1
    )
[1] => Array (
    [time] => 09:30:00
    [name] => To do something 2
    )
[2] => Array (
    [time] => 10:00:00
    [name] => To do something 3
    )

and

[0] => Array (
    [time] => 09:00:00
    )
[1] => Array (
    [time] => 09:15:00
    )
[2] => Array (
    [time] => 09:30:00
    )
[3] => Array (
    [time] => 09:45:00
    )
[4] => Array (
    [time] => 10:00:00
    )

Need to do another associative array:

if the field [time] in second array equals field [time] in first array then add [name];
if field [time] in second array not equals field [time] in first array then add empty [name].

Should look like this:

[0] => Array (
    [time] => 09:00:00
    [name] => To do something 1
    )
[1] => Array (
    [time] => 09:15:00
    [name] => 
    )
[2] => Array (
    [time] => 09:30:00
    [name] => To do something 2
    )
[3] => Array (
    [time] => 09:45:00
    [name] => 
    )
[4] => Array (
    [time] => 10:00:00
    [name] => To do something 3
    )

Niki van Stein · Accepted Answer · 2015-09-23 08:17:08Z

1

After some puzzling I made it work for you.

This is the code you can use:

$array3 = array();

foreach ($array2 as $key2 => $value2){
    $found = false;

    foreach ($array1 as $key1 => $value1){
        if ($array1[$key2]['time'] == $array2[$key2]['time']) {
            $array3[$key2]['time']  = $array1[$key1]['time'];
            $array3[$key2]['name'] = $array1[$key1]['name'];
            $found = true;
        }
    }
    if (!$found){
        //add
        $array3[$key2]['time']  = $array2[$key2]['time'];
        $array3[$key2]['name'] = "";

    }
}

print_r($array3);

answered Sep 23, 2015 at 8:17

Niki van Stein

10.8k3 gold badges33 silver badges63 bronze badges

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

1 Comment

Vasiliy Schitov Over a year ago

Unfortunately it doesn't work, it shows only one last record [name] in the array and other elements in array show with empty [name] key, but I understood your idea. Thank you.

Collectives™ on Stack Overflow

Sorting and merge associative array (PHP)

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