A simple way to get a single array containing all the integers that are contained within a nested object in PHP

Question

I have the following structure:

  {
    "produto_id" : 54,
    "descricao_id" : 25,
    "contas" : [
        {
            "marketplace_id" : 8,
            "contas_ids" : [
                 6, 8, 9
                ]
        },
        {
            "marketplace_id" : 9,
            "contas_ids" : [
                 44, 100
                ]
        }
        ]
}

I want to get an array contained all the "contas_ids" like this:

  [6, 8, 9, 44, 100]

I've tried array_map but I had to use so many. With array_column I achieve something close but it divided the output in several arrays.

 $ids = array_column($contas,  'contas_ids');

using "dd" I get this.

   array:2 [
  0 => array:3 [
    0 => 6
    1 => 8
    2 => 9
  ]
  1 => array:2 [
    0 => 44
    1 => 100
  ]
]

Can someone help me produce a single array with all "contas_id"?

You're right. Even so, it's not clear what `$contas` is--is it the full structure or just the subarray? Adding the parsing code would be helpful as part of a [mcve]. — ggorlen, Jun 21 '19 at 21:13
@ggorlen Agreed, looks like it's just the `contas` array. That's what I assumed in my answer. — miken32, Jun 21 '19 at 21:17
You mentioned using dd, is this in a Laravel app? If that data comes from a query, there's probably a better way to do this. — Don't Panic, Jun 21 '19 at 21:17
Why is this json invalid? I am getting this json from a post request. — Diego Alves, Jun 22 '19 at 14:37

score 0 · Answer 1 · answered Jun 21 '19 at 20:57

0

After you get the sub-arrays with $ids = array_column($contas, 'contas_ids');, you can combine the arrays using array_merge, as outlined in this question: Merge all sub arrays into one

call_user_func_array("array_merge", $ids);

answered Jun 21 '19 at 20:57

zeterain

1,140
1
10
15

score 0 · Answer 2 · answered Jun 21 '19 at 21:08

This should get you what you need.

$json = '{
    "produto_id" : 54,
    "descricao_id" : 25,
    "contas" : [{
        "marketplace_id" : 8,
        "contas_ids" : [ 6, 8, 9 ]
    },
    {
            "marketplace_id" : 9,
            "contas_ids" : [ 44, 100 ]
    }
    ]
}
';

$ids=[];
foreach(json_decode($json,true)['contas'] as $key => $val){
    $ids = array_merge($ids, $val['contas_ids']);
}
var_dump($ids);

score 0 · Answer 3 · answered Jun 21 '19 at 21:15

One more array_merge() solution, but this time with an obscure operator!

<?php
$json = '{
    "produto_id" : 54,
    "descricao_id" : 25,
    "contas" : [
        {
            "marketplace_id" : 8,
            "contas_ids" : [
                 6, 8, 9
                ]
        },
        {
            "marketplace_id" : 9,
            "contas_ids" : [
                 44, 100
                ]
        }
        ]
}';
$contas = json_decode($json, true);
$ids = array_column($contas["contas"], "contas_ids");
$integers = array_merge(...$ids);
print_r($integers);

Output:

Array
(
    [0] => 6
    [1] => 8
    [2] => 9
    [3] => 44
    [4] => 100
)

A simple way to get a single array containing all the integers that are contained within a nested object in PHP

3 Answers3