php arrays add value from one array to another array

Question

I have 2 arrays, both generated from separate mysql queries as shown below:

ARRAY 1

[0] => Array
    (
        [value] => black
        [hex_colour] => #000000
    )

[1] => Array
    (
        [value] => blue
        [hex_colour] => #4e5f98
    )

[2] => Array
    (
        [value] => brown
        [hex_colour] => #a3775e
    )

ARRAY 2

[0] => Array
    (
        [value] => black
        [count] => 122
    )

[1] => Array
    (
        [value] => blue
        [count] => 33
    )

[2] => Array
    (
        [value] => brown
        [count] => 5
    )

My question is how do I add [count] to ARRAY 1 so the result would be:

New ARRAY

[0] => Array
    (
        [value] => black
        [hex_colour] => #000000
        [count] => 122
    )

[1] => Array
    (
        [value] => blue
        [hex_colour] => #4e5f98
        [count] => 33
    )

[2] => Array
    (
        [value] => brown
        [hex_colour] => #a3775e
        [count] => 5

    )

I apologise I haven't got examples of code that I've tried, but I have searched google using a number of different search terms but with no luck. Any help would be greatly received.

Are they always in the same order? Is [0] in array1 == [0] in array2? — Andreas
– Andreas, Commented Dec 26, 2017 at 12:04

Akhilendra · Accepted Answer · 2017-12-26 12:11:35Z

4

$data= Array(
    'value' => 'black',
   'hex_colour' => '#000000'
);
$data1= Array(
    'value' => 'black',
   'count' => '122'
);


print_r(array_merge($data1, $data));

answered Dec 26, 2017 at 12:11

Akhilendra

1,1671 gold badge16 silver badges31 bronze badges

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

Comments

Jaimin Vyas · Accepted Answer · 2017-12-26 12:18:09Z

2

I think this is fullfillment your requirement.

$arrayName1[0] = array(
        'value' => "black",
        'hex_colour' => "#000000",
    );
    $arrayName1[1] = array(
        'value' => "blue",
        'hex_colour' => "#4e5f98",
    );
    $arrayName1[2] = array(
        'value' => "brown",
        'hex_colour' => "#a3775e",
    );

    $arrayName2[0] = array(
        'value' => "black",
        'count' => "122",
    );
    $arrayName2[1] = array(
        'value' => "blue",
        'count' => "33",
    );
    $arrayName2[2] = array(
        'value' => "brown",
        'count' => "5",
    );

    foreach ($arrayName1 as $key => $row1) {
        foreach ($arrayName2 as $key => $row2) {
            if($row1['value'] == $row2['value'] ){
                $row1['count'] = $row2['count'];
                $data[] = $row1;
                break;
            }
        }
    }

In $data you got same array as mentioned in your quetions. If you have any doubt, please comment below.

answered Dec 26, 2017 at 12:18

Jaimin Vyas

1145 bronze badges

1 Comment

David Over a year ago

Hi Jaimin, thank you it works as does Deepak's above.

Deepak Kumar T P · Accepted Answer · 2017-12-26 12:10:34Z

2

$count_array=[];

foreach($array2 as $count)
{
    $count_array[$count['value']]=$count['count'];
}
$final=[];
foreach($array1 as $value)
{
    $final=[
             "value"=>$value['value'],
             "hex_colour"=>$value['hex_colour'],
             "count"=>$count_array[$value['value']]
        ];
}

answered Dec 26, 2017 at 12:10

Deepak Kumar T P

1,07610 silver badges20 bronze badges

Comments

Aftab H. · Accepted Answer · 2018-03-04 17:21:12Z

2

You can try below code-

  $array1= array(
    'value' => 'black',
   'hex_colour' => '#000000'
);
$array2= array(
    'value' => 'black',
   'count' => '122'
);

$result = array_merge($array1, $array2);

print_r($result);

For reference http://php.net/manual/en/function.array-merge.php

edited Mar 4, 2018 at 17:21

answered Dec 26, 2017 at 12:17

Aftab H.

1,5476 gold badges13 silver badges25 bronze badges

Collectives™ on Stack Overflow

php arrays add value from one array to another array

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related