phpjsonmultidimensional-arraynested-loopsjson-flattener

Trying to Remove Nesting from Json Array in PHP


As you can see i have a json array with multiple elements, and I have been trying to remove the nesting ("DEMARCHE") element and I want the array to be flattened. but It is only giving a single output array, but my json file consists more than 1 array. I would really be thankful if someone can help me. _ Thank you

** This is the input **

[
    {
    "CHEPTEL":"12001116",
    "NOM":"La Ferme de Jean-Marc et Aurélien ",
    "CODE_POSTAL":"12630",
    "VILLE":"AGEN D AVEYRON",
    "LATITUDE":"44.343518",
    "LONGITUDE":"2.716004",
    "DESCRIPTIF_FERME":"",
    "DEMARCHE" : [
    {
    "DEMA_CODE":"08-93",
    "ANNEE_ADHESION":"2016",
    "RACE_MERES":"Limousine",
    "DESCRIPTIF_ATELIER":""
    }
    ]        
    },
    {
    "CHEPTEL":"12001",
    "NOM":"La Ferme ",
    "CODE_POSTAL":"12630",
    "VILLE":"AGEN D AVEYRON",
    "LATITUDE":"44.343518",
    "LONGITUDE":"2.716004",
    "DESCRIPTIF_FERME":"",
    "DEMARCHE" : [
    {
    "DEMA_CODE":"08-93",
    "ANNEE_ADHESION":"2016",
    "RACE_MERES":"Limousine",
    "DESCRIPTIF_ATELIER":""
    }
    ]        
    }
    ]

** And I want the output to be **

[
    {
    "CHEPTEL":"12001116",
    "NOM":"La Ferme de Jean-Marc et Aurélien ",
    "CODE_POSTAL":"12630",
    "VILLE":"AGEN D AVEYRON",
    "LATITUDE":"44.343518",
    "LONGITUDE":"2.716004",
    "DESCRIPTIF_FERME":"",
    "DEMA_CODE":"08-93",
    "ANNEE_ADHESION":"2016",
    "RACE_MERES":"Limousine",
    "DESCRIPTIF_ATELIER":""     
    },
    {
    "CHEPTEL":"12001",
    "NOM":"La Ferme ",
    "CODE_POSTAL":"12630",
    "VILLE":"AGEN D AVEYRON",
    "LATITUDE":"44.343518",
    "LONGITUDE":"2.716004",
    "DESCRIPTIF_FERME":"",
    "DEMA_CODE":"08-93",
    "ANNEE_ADHESION":"2016",
    "RACE_MERES":"Limousine",
    "DESCRIPTIF_ATELIER":""       
    }
    ]

** My code is here **

<?php
   
    
    $array1 = json_decode($json,true);
    
    
    function array_flatten($array) {
    
       $return = array();
       foreach ($array as $key => $value) {
           if (is_array($value))
           { $return = array_merge($return, array_flatten($value));
                             }
           else {$return[$key] = $value;
                }
       }
       return $return;
    
    }
    
    $array  = $array1;
    
    $result = array_flatten($array);
    
    $jsonnew = json_encode($result);
    
    var_dump($jsonnew);
    
    
    ?>

Solution

  • Try this:

    <?php
      $json = '[
        {
          "CHEPTEL":"12001116",
          "NOM":"La Ferme de Jean-Marc et Aurélien ",
          "CODE_POSTAL":"12630",
          "VILLE":"AGEN D AVEYRON",
          "LATITUDE":"44.343518",
          "LONGITUDE":"2.716004",
          "DESCRIPTIF_FERME":"",
          "DEMARCHE" : [
            {
            "DEMA_CODE":"08-93",
            "ANNEE_ADHESION":"2016",
            "RACE_MERES":"Limousine",
            "DESCRIPTIF_ATELIER":""
            }
          ]        
        },
        {
          "CHEPTEL":"12001",
          "NOM":"La Ferme ",
          "CODE_POSTAL":"12630",
          "VILLE":"AGEN D AVEYRON",
          "LATITUDE":"44.343518",
          "LONGITUDE":"2.716004",
          "DESCRIPTIF_FERME":"",
          "DEMARCHE" : [
            {
            "DEMA_CODE":"08-93",
            "ANNEE_ADHESION":"2016",
            "RACE_MERES":"Limousine",
            "DESCRIPTIF_ATELIER":""
            }
          ]        
        }
        ]';
        
      $array1 = json_decode($json, true);
      $newArr = array_map(function ($arr) {
        foreach ($arr as $key => $val) {
          if ($key === 'DEMARCHE') {
            foreach ($val[0] as $key1 => $val1) {
              $arr[$key1] = $val1;
            }
          }
        }
        
        unset($arr['DEMARCHE']);
        
        return $arr;
      }, $array1);
      
      echo json_encode($newArr, JSON_PRETTY_PRINT); // done!