traversing unknown json keys

Question

I don't know how to ~~parsing~~ traversing array data like this

{
  "foo-1": [
    [
      A,
      3
    ],
    [
      B,
      3
    ]
  ],
  "foo-2": [
    [
      A,
      1
    ],
    [
      B,
      7
    ]
  ],
  "foo-3": [
    [
      A,
      1
    ],
    [
      B,
      6
    ]
  ]
}

I want result like this

(foo-1,foo-2,foo-3)
(A,B)
(3,3)(1,7)(1,6)

my code

$data = file_get_contents("example/data");
$parsing = json_decode($data, true);

foreach($parsing as $row=>$val){
   $data1 .= $row; //success

   foreach($row as $rows){ // don't know how to parsing child data
    $data2 .= $rows[0];
    $data3 .= $rows[1];
    }
}

Does this answer your question? [How do I extract data from JSON with PHP?](https://stackoverflow.com/questions/29308898/how-do-i-extract-data-from-json-with-php) — El_Vanja, Mar 28 '20 at 16:47
i want to parse dynamic data for foo-1,foo-2,foo-3 and all child data, please try my code, its look like simple but i don't how to do that — fitra, Mar 28 '20 at 16:55

The Codesee · Accepted Answer · 2020-03-28T18:02:25.290

Give this a go and let me know if it's what you want:

//$arrays = array("foo-1" => array(array("A", 3), array("B", 3)), "foo-2" => array(array("A", 1), array("B", 7)), "foo-3" => array(array("A", 1), array("B", 6)));

$data = file_get_contents("example/data"); // enter your link here
$arrays = json_decode($data, true);

$names = "(";
$letters = "(";
$numbers = "";
$coordinate = "";

foreach($arrays as $arrayName => $array) {
    if(array_search($arrayName, array_keys($arrays)) == 0) {
        $names .= $arrayName;
    }else{
        $names .= ",".$arrayName;
    }
    foreach($array as $key => $nestedArray) {
        foreach($nestedArray as $letterOrNum => $value) {
            if($letterOrNum == 0) { // it's a letter
                if($key + 1 == 1) {
                    $nextLetter = $array[$key + 1][0];
                    if (!strpos($letters, $value.','.$nextLetter) !== false) {
                        if($key == 0 && array_search($arrayName, array_keys($arrays)) == 0) {
                            $letters .= $value;
                        }else{
                        $letters .= ",".$value;
                        }
                    }
                }else{
                    $previousLetter = $array[$key - 1][0];
                    if (!strpos($letters, $previousLetter.','.$value) !== false) {
                        if($key == 0 && array_search($arrayName, array_keys($arrays)) == 0) {
                            $letters .= $value;
                        }else{
                        $letters .= ",".$value;
                        }
                    }
                }
            }else{ // its a number
                if($key == 0) {
                    $coordinate .= "(".$value.",";
                }else{
                    $coordinate .= $value.")";
                }
                $numbers .= $coordinate;
                $coordinate = "";
            }
        }
    }
}

$names .= ")";
$letters .= ")";

echo $names;
echo $letters;
echo $numbers;

Demo: https://3v4l.org/mMoT6

sorry sir tag foo-1, foo-2, foo-3 its dynamic can be change with other name — fitra, Mar 28 '20 at 17:22
thank you so much @The Codesee i stuck 3 days with this code — fitra, Mar 28 '20 at 17:31
@fitra Because your array is dynamic, I've made a few changes to my answer — The Codesee, Mar 28 '20 at 17:56

traversing unknown json keys

1 Answers1