Merging datas from an array with PHP

Question

I have this type array

Array
(
    [0] => Array
        (
            [id] => 90
            [name] => Paul
            [company] => Google
            [date] => 2018-01-06
            [total] => 100.00
        )
    [1] => Array
        (
            [id] => 90
            [name] => Paul
            [company] => Google
            [date] => 2018-07-06
            [total] => 100.00
        )
    [2] => Array
        (
            [id] => 89
            [name] => Ethan
            [company] => Yahoo
            [date] => 2018-07-10
            [total] => 1140.00
        )
)

I need to create a new array from the previous one by merging id and name if they are the same.

The desired output should be:

[[
    [id] => 90
    [name] => Paul
    [company] => Google,
    [data] => [
        [date] => 2018-01-06,
        [total] => 100.00
    ],
    [
        [date] => 2018-07-06,
        [total] => 100.00
    ],
], [
    [id] => 89
    [name] => Ethan
    [company] => Yahoo
    [data] => [
        [date] => 2018-07-10,
        [total] => 1140.00
    ]
]]

What I have tried before:

$output = array();
foreach($input as $data){
    $output[$data['id']][] = $data;
    $output[$data['name']][] = $data;
    $output[$data['company']][] = $data;
}

What I'm missing here please ?

Thanks.

so, you need no duplicates or just checking 2 consecutive elements if they are same is enough? — Lemures
– Lemures, Commented Jul 11, 2018 at 12:47
Also, if you're getting the data from the database, I have the feeling you can solve this problem by modifying your query instead of php code. It may be more efficient — Lemures
– Lemures, Commented Jul 11, 2018 at 12:48
@Lemures, I need to check only the id but I do not want to duplicate each time the same infos name and company. — poipoi
– poipoi, Commented Jul 11, 2018 at 12:50
Your desired output is invalid. "Google" cannot be followed by an array. That array must be assigned to a new property. — trincot
– trincot, Commented Jul 11, 2018 at 12:52
Once again, I suggest you rethink you sql query. If you show me the table structure, I might help you. — Lemures
– Lemures, Commented Jul 11, 2018 at 12:53

BritishWerewolf · Accepted Answer · 2018-07-11 12:58:24Z

3

This should be something like what you're looking for:

foreach ($arr as $a) {
    if (empty($resp[$a['id']])) {
        $resp[$a['id']] = [
            'id' => $a['id'],
            'name' => $a['name'],
            'company' => $a['company'],
            'data' => []
        ];
    }
    $resp[$a['id']]['data'][] = [
        'date' => $a['date'],
        'total' => $a['total']
    ];
}

This is assuming that you only care about grouping the date and total into a repeated company and name.

edited Jul 11, 2018 at 12:58

BritishWerewolf

3,9785 gold badges34 silver badges54 bronze badges

answered Jul 11, 2018 at 12:55

DrRoach

1,3569 silver badges16 bronze badges

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

6 Comments

poipoi Over a year ago

Exactly what I needed. Thanks.

poipoi Over a year ago

How can I remove the first level of information? [90] => Array... and start directly with ( [KDX_Id] => 90 ?

DrRoach Over a year ago

What does the KDX_Id mean? Do you just want your array to start at 0 instead of the id?

poipoi Over a year ago

Yes. To make it minimal.

DrRoach Over a year ago

You can use array_values(). After the loop, you can call $resp = array_values($resp).

|

Collectives™ on Stack Overflow

Merging datas from an array with PHP

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related