PHP combine array based on value, add 0 if no match

Question

I have seen tons of questions that discuss portions of my question, but have been unable to work them into a solution. Hopefully someone can help me out.

I have two arrays, I'll call them Quantity and Shipping.

Here is Quantity:

Array(
    [0] => Array(
            [0] => 1
            [1] => Fed-Ex
        )
    [1] => Array(
            [0] => 2
            [1] => USPS
        )
    [2] => Array(
            [0] => 1
            [1] => USPS-E
        )
)

[0] is the quantity, and [1] is the name.

And here is Shipping:

Array(
    [0] => Array(
            [0] => 3
            [1] => Fed-Ex
        )
    [1] => Array(
            [0] => 1
            [1] => USPS
        )
    [2] => Array(
            [0] => 11
            [1] => USPS-A
        )
    [3] => Array(
            [0] => 10
            [1] => USPS-E
        )
)

[0] is the index, and [1] is the name.

I would like to combine them based on index 1 matches into something that looks like this. If there is no match I would like a 0 to be inserted instead (like in my USPS-A example).

I'll call it Master:

Array(
    [0] => Array(
            [0] => 3
            [1] => Fed-Ex
            [2] => 1
        )
    [1] => Array(
            [0] => 1
            [1] => USPS
            [2] => 2
        )
    [2] => Array(
            [0] => 11
            [1] => USPS-A
            [2] => 0
        )
    [3] => Array(
            [0] => 10
            [1] => USPS-E
            [2] => 1
        )
)

[0] is the index, [1] is the name, and [2] is the quantity.

Does anyone have any suggestions? I tried using nested foreach loops but I was ending up with duplicates even when I used break statements. Tried array_column and in_array as well but to no success.

Any help would be appreciated. Thank you.

Pascal Meunier · Accepted Answer · 2017-06-30 18:39:42Z

1

If you assume that the shipping array will always be bigger than the quantity, here is something that works.

$quantities = [
    [1, 'Fex-Ex'],
    [2, 'USPS'],
    [1, 'USPS-E']
];

$shippings = [
    [3, 'Fex-Ex'],
    [1, 'USPS'],
    [11, 'USPS-A'],
    [10, 'USPS-E'],
];

$master = array();
foreach ($shippings as $shipping) {
    $qty = 0;
    foreach ($quantities as $quantity) {
        if ($shipping[1] == $quantity[1]) {
            $qty = $quantity[0];
        }
    }
    $master[] = array(
        $shipping[0],
        $shipping[1],
        $qty
    );
}

var_dump($master);

answered Jun 30, 2017 at 18:39

Pascal Meunier

7156 silver badges15 bronze badges

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

1 Comment

blackandorangecat Over a year ago

Thank you - this does exactly what I was looking for.

Don't Panic · Accepted Answer · 2017-06-30 18:53:17Z

1

You don't need nested loops to do this. You can just loop over each of the arrays once.

First, iterate the $shipping array to build the $master array using the [1] key (name) as its index. You can add a zero value for quantity at index 2 at the same time.

foreach ($shipping as $s) {
    $master[$s[1]] = $s + [2 => 0];
}

Second, iterate the $quantity array to update the quantity values in $master.

foreach ($quantity as $q) {
    $master[$q[1]][2] = $q[0];
}

Keep in mind that with this approach, using the names as keys, if there are duplicate names they will be overwritten.

answered Jun 30, 2017 at 18:53

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

1 Comment

blackandorangecat Over a year ago

Very ingenious. Thanks for the answer.

Dariusz Majchrzak · Accepted Answer · 2017-06-30 19:26:23Z

0

I think that would do the job (without nested loops):

<?php 

$quantities = [
    [1, 'Fed-Ex'],
    [2, 'USPS'],
    [1, 'USPS-E']
];

$shippings = [
    [3, 'Fed-Ex'],
    [1, 'USPS'],
    [11, 'USPS-A'],
    [10, 'USPS-E'],
];

foreach($quantities as &$v) {
    $quantities[$v[1]] = $v[0];
    unset($v);
}

$master = [];

foreach($shippings as $v) {
    $master[] = [
        $v[0], 
        $v[1], 
        isset($quantities[$v[1]]) ? $quantities[$v[1]] : 0
    ];
}

answered Jun 30, 2017 at 19:26

Dariusz Majchrzak

1,2472 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

PHP combine array based on value, add 0 if no match

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related