loop json array and return values in php

Question

I use a library for Synchronize a local WebSQL DB to a server specifically https://github.com/orbitaloop/WebSqlSync. I use PHP: 5.4.7 this is json var $json

{
"info":"",
"data":{
    "clientes":[],
    "conceptos_gastos":[],
    "formaspago":[{
        "idFormaPago":7,
        "FormaPago":"quwuw",
        "Dias":1,
        "Cuotas":1,
        "last_sync_date":null
    }],
    "listaprecios":[],
    "producto":[],
    "repartidores":[],
    "tipodocumento":[],
    "vehiculos":[],
    "zonas":[]
}
}

when I try to get the values

$js=json_decode($json,true);
foreach ($js['formaspago'] as $row ) {
   echo $row["Formapago"];

}

I get this error:

Invalid argument supplied for foreach

any help is appreciated

You should learn to debug your code. Try to add this right before the foreach line, it will pretty-print your array. It's quite obvious that the key $js['formaspago'] doesn't exist, it's really $js['data']['formaspago']... echo '<pre>'; var_dump($js); — JimL
– JimL, Commented Jul 15, 2013 at 21:37

Tobias Golbs · Accepted Answer · 2013-07-15 21:36:37Z

2

use json_decode

//array
$data = json_decode($json, true);
foreach($data["data"]["formaspago"] as $row) {
    echo $row["Formapago"];
}

Thanks @JimL for the hint.

edited Jul 15, 2013 at 21:36

answered Jul 15, 2013 at 21:30

Tobias Golbs

4,6164 gold badges31 silver badges50 bronze badges

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

1 Comment

JimL Over a year ago

json_decode($json) returns an object. json_decode($json, true) returns an array :)

Willem Ellis · Accepted Answer · 2013-07-15 21:34:13Z

1

You're not passing a valid array to the foreach loop. However, even if you parse the json you've supplied, a foreach won't work because it's an object not an array.

$json = '{
"info":"",
"data":{
    "clientes":[],
    "conceptos_gastos":[],
    "formaspago":[{
        "idFormaPago":7,
        "FormaPago":"quwuw",
        "Dias":1,
        "Cuotas":1,
        "last_sync_date":null
    }],
    "listaprecios":[],
    "producto":[],
    "repartidores":[],
    "tipodocumento":[],
    "vehiculos":[],
    "zonas":[]
}
}';

$obj = json_decode($json);

print $obj->info will return an empty string.

$obj->data is an object that has various properties some of which are empty arrays. Passing these into the foreach should work. i.e.

foreach($obj->data->clients as client) {
  // Do something here
}

Further, $obj->data->formaspago has exactly one element in the array, which is an object. You can access this object with a foreach loop:

foreach($obj->data->formaspago as formaspago) {
  print formaspago->idFormaPago; // Will print 7
  print formaspago->FormaPago; // Will print "quwuw"
  print formaspago->Dias; // Will print 1
  print formaspago->Cuotas; // Will print 1
  print formaspago->last_sync_date; // Will print nothing
}

answered Jul 15, 2013 at 21:34

Willem Ellis

5,0467 gold badges40 silver badges55 bronze badges

1 Comment

Razmi Martinez Over a year ago

Your answer helped me a lot but had to treat it like an array: $obj= json_decode($json, true);

Collectives™ on Stack Overflow

loop json array and return values in php

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related