merge array keys and add the values-PHP

Question

I want to merge two same keys in an array and get the sum of the values. I want the same structure as it is now.Because this data needs to be converted to JSON.

This is what i get now.

{ "data": [{ "count_of_invites": 5, "user": "Rajesh", "id": "53" }, { "count_of_invites": 9, "user": "Student", "id": "45" }, { "count_of_invites": 4, "user": "Student", "id": "45" } ] }

As you can see the id 45 are repeated.As i want the result as,

Expected output { "data": [{ "count_of_invites": 5, "user": "Rajesh", "id": "53" }, { "count_of_invites": 13, "user": "Student", "id": "45" } ] }

As you can see the duplicate entry should be removed as well as the count_of_invites of duplicate entry should be added.

Hello and welcome to StackOverflow. Please take some time to read the help page, especially the sections named "What topics can I ask about here?" and "What types of questions should I avoid asking?". And more importantly, please read the Stack Overflow question checklist. You might also want to learn about Minimal, Complete, and Verifiable Examples. — Federico klez Culloca
– Federico klez Culloca, Commented Jun 18, 2018 at 10:18
yeah i know its not complicated but i've used some array function as well as loops but it doesn't end up in the desired result. — Kiran JB
– Kiran JB, Commented Jun 18, 2018 at 10:31
Then post what you have tried. And please include the array in json or var_export format. — Andreas
– Andreas, Commented Jun 18, 2018 at 10:35

Progrock · Accepted Answer · 2018-06-18 12:42:37Z

1

<?php
$data = [
    [
        'id' => 2,
        'name' => 'Paul',
        'count' => 4
    ],
    [
        'id' => 3,
        'name' => 'Peter',
        'count' => 5
    ],
    [
        'id' => 3,
        'name' => 'Peter',
        'count' => 7
    ]
];

foreach($data as $array)
    $counts[$array['id']][] = $array['count'];

$counts = array_map('array_sum', $counts);
foreach($data as $k => $array)
    $data[$k]['count'] = $counts[$array['id']];

$data = array_unique($data, SORT_REGULAR);
print json_encode($data, JSON_PRETTY_PRINT);

Output:

[
    {
        "id": 2,
        "name": "Paul",
        "count": 4
    },
    {
        "id": 3,
        "name": "Peter",
        "count": 12
    }
]

answered Jun 18, 2018 at 12:42

Progrock

7,4831 gold badge21 silver badges25 bronze badges

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

Comments

Lajos Arpad · Accepted Answer · 2018-06-18 10:54:59Z

0

You can achieve it this way:

$ids = array();
$output = array();

foreach ($input as $value) {
    if (!isset($ids[$value["id"]])) {
        $ids[$value["id"]]=$count($output);
        $output[]=$value;
    } else {
        $output[$ids[$value["id"]]]["count_of_invites"] = $value["count_of_invites"];
        $output[$ids[$value["id"]]]["user"] = $value["user"];
    }
}

edited Jun 18, 2018 at 10:54

answered Jun 18, 2018 at 10:37

Lajos Arpad

80.4k42 gold badges123 silver badges234 bronze badges

6 Comments

Kiran JB Over a year ago

[ { count_of_invites: 5, user: "Rajesh", id: "53" }, { count_of_invites: 4, user: "Student", id: "45", student: null } ]This is what i get after encoding it to json.As the value doent sum up

Lajos Arpad Over a year ago

@KiranJB I have edited my answer, please, check it out. The mistake was that in the else I have used a student field instead of the user field.

Kiran JB Over a year ago

The count_of_invites shows the last data only.not the sum of all the value.my problem is to get the sum of values which has same key and in single occurence

Andreas Over a year ago

@Kiran can you please update your question then as I asked an hour ago. I'm not too keen or typing your whole array in manually.

Kiran JB Over a year ago

@Lajos Arpad .There were some editing to your mentioned code .But I've solve the problem .Thank you Arpad .It was a great help.I appreciate it .I'm posting the edited code .

|

Kiran JB · Accepted Answer · 2018-06-18 12:23:33Z

0

The count method was declared as variable and i've added with addition assignment operator.

Thank You for helping.

$ids = array(); $output = array();

    foreach ($response as $value) {
        if (!isset($ids[$value["id"]])) {
            $ids[$value["id"]] = count($output);
            $output[]          = $value;
        }
        else {
            $output[$ids[$value["id"]]]["count_of_invites"] += $value["count_of_invites"];
            $output[$ids[$value["id"]]]["user"]             = $value["user"];
        }
    }

answered Jun 18, 2018 at 12:23

Kiran JB

13 bronze badges

Collectives™ on Stack Overflow

merge array keys and add the values-PHP

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related