Array in Array in Array - Cant get data from JSON String

Question

The data I provided was only one line. I have many lines of the same with different "Bestaende" and "Menge":

[{"Ean":"","Barcode":"010241770148","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90},      
 {"Ean":"","Barcode":"010241770149","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90},
 {"Ean":"","Barcode":"010241770151","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90},
 {"Ean":"","Barcode":"010241770152","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90}]

The foreach you describe I understand, but it doesn't work as expected .

$jsonarray = json_decode($jsonfile,true);
echo 'Array 0 Menge: '.$jsonarray['0']['Bestaende']['0']['Menge'].'<br>'; 
echo 'Array 1 Menge: '.$jsonarray['1']['Bestaende']['0']['Menge'].'<br>'; 
echo 'Array 2 Menge: '.$jsonarray['2']['Bestaende']['0']['Menge'].'<br>'; 
echo 'Array 3 Menge: '.$jsonarray['3']['Bestaende']['0']['Menge'].'<br>';

brings out

Array 0 Menge: 1
Array 1 Menge: 1
Array 2 Menge: 1
Array 3 Menge: 1

Okay. But when I try to foreach it (because I have a list of base data), the output is only one row. I get only one entry "1". Nothing more.

$x=0;
foreach($jsonarray[$x]['Bestaende'] as $idx => $Bestaende) {
   echo 'Print Menge: ';
   print_r($Bestaende['Menge']); 
 $x++;
}

So I try to loop over the Array to get the data. The Result is:

Array ( [Filiale] => 1 [FilialeBez] => Laden [Menge] => 1 [Gln] => [Dispo] => 0 )
Print Menge: 1

I have a problem with the array in array in array ... Is there a better way to get the data I want?

Or is my foreach loop wrong?

Yes, your foreach is wrong.

faerin
– faerin

2017-11-15 10:36:22 +00:00
Commented Nov 15, 2017 at 10:36 — faerin
– faerin, Commented Nov 15, 2017 at 10:36

Philipp · Accepted Answer · 2017-11-15 10:20:34Z

1

You loop only over $jsonarray[0]['Bestaende'] which only contains one item. You should loop over $jsonarray and from there dive in deeper.

foreach($jsonarray as $item) {
    echo 'Print Menge: ';
    print_r($item['Bestaende']['0']['Menge']); 
    // or even dive in deeper
    foreach ($item['Bestaende'] as $bestaende) {
        // .. $bestaende['Menge'];
    }
}

answered Nov 15, 2017 at 10:20

Philipp

15.7k4 gold badges38 silver badges54 bronze badges

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

Comments

Praveen Kumar · Accepted Answer · 2017-11-15 10:27:53Z

0

Try it like this

foreach($jsonarray as $k=>$alldata) 
{
   foreach($alldata["Bestaende"] as $idx => $Bestaende) 
   {
       echo '<pre>';
       echo 'Print Menge: '.$Bestaende['Menge'];
       echo '</pre>';
   }
}

edited Nov 15, 2017 at 10:27

answered Nov 15, 2017 at 10:20

Praveen Kumar

2,3981 gold badge14 silver badges21 bronze badges

Comments

Subhankar Mitra · Accepted Answer · 2017-11-15 10:35:39Z

Try this code..
$j = '[{"Ean":"","Barcode":"010241770148","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90},      
 {"Ean":"","Barcode":"010241770149","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90},
 {"Ean":"","Barcode":"010241770151","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90},
 {"Ean":"","Barcode":"010241770152","Bezeichnung":"Richard 1516","Bestaende":[{"Filiale":1,"FilialeBez":"Laden","Menge":1,"Gln":null,"Dispo":0}],"Bestand":1,"Dispo":0,"Uvp":269.90,"Vk":269.90}]';

$a = json_decode($j,true);

foreach($a as $key => $value){
    if(!empty($value['Bestaende'])){
        foreach($value['Bestaende'] as $k=>$v){
             echo 'Print Menge: '.(!empty($v['Menge']) ? $v['Menge'] : '').'</br>';
        }
    }
}

Collectives™ on Stack Overflow

Array in Array in Array - Cant get data from JSON String

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related