Merge two JSON arrays and then sort them

Question

How would I merge both JSON arrays and then sort the value of ID so that the result displays the highest number to the lowest number?

For example, my desired output from the script below would be:

1 - Jimbo
2 - Bob
6 - Luke
12 - Chris
16 - Jonas
36 - Sam

Here's my JSON arrays:

$json1 ='
{
    "error": "trueee",
    "info": {
        "collections": [{
            "ID": "1"
            "Name": "Jimbo"
        }, {
            "ID": "36"
            "Name": "Sam"
        }, {
            "ID": "2",
            "Name": "Bob"
        }]
    }
}
';

$json2 ='
{
    "error": "trueee",
    "info": {
        "collections": [{
            "ID": "12"
            "Name": "Chris"
        }, {
            "ID": "6"
            "Name": "Luke"
        }, {
            "ID": "16"
            "Name": "Jonas"
        }]
    }
}
';

Community · Accepted Answer · 2021-01-18 12:35:56Z

1

You need to merge the arrays from the json string. First json decode for getting the arr with associative array than get the columns of ID using array_column, after that you need to merge the two array and finally sort them.

Online Check and a Long Conversation

$json1 ='
{
    "error": "trueee",
    "info": {
        "collections": [{
            "ID": "1"
        }, {
            "ID": "36"
        }, {
            "ID": "2"
        }]
    }
}
';

$json2 ='
{
    "error": "trueee",
    "info": {
        "collections": [{
            "ID": "12"
        }, {
            "ID": "6"
        }, {
            "ID": "16"
        }]
    }
}
';

$arr1 = json_decode($json1, true);
$arr2 = json_decode($json2, true);

$arr1 = array_column($arr1['info']['collections'], "ID");
$arr2 = array_column($arr2['info']['collections'], "ID");

$arr = array_merge($arr1, $arr2);
sort($arr);
echo '<pre>';
print_r($arr);

Result:

Array
(
    [0] => 1
    [1] => 2
    [2] => 6
    [3] => 12
    [4] => 16
    [5] => 36
)

edited Jan 18, 2021 at 12:35

CommunityBot

11 silver badge

answered May 25, 2016 at 17:28

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

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

3 Comments

Murad Hasan Over a year ago

I make my answer from the json string, Did the loop needed for some validation checking?

Murad Hasan Over a year ago

If you can explain some about the loop than i can hep you better ways.

Murad Hasan Over a year ago

Let us continue this discussion in chat.

Collectives™ on Stack Overflow

Merge two JSON arrays and then sort them

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related