JSON Read from API

[DaemonProjects]

Hello All,

This is my first time playing JSON and php. When I try to pull and use json_decode I get some inforamtion then PHP gives me an error

$decodedJSON = json_decode($response, true);
foreach($decodedJSON as $review){
    echo $review['Name']."<br>";
    echo $review['RouterIP']."<br>";
}

Warnings

Warning: Illegal string offset 'Name'
Warning: Illegal string offset 'RouterIP' 

I am trying to pull all this data as well as the graph data to pump into a data base

any ideas how to do this?

I have attached the json file

[ATTACH]5377[/ATTACH]

info.json.txt

[DaemonProjects]

Looks like the warnings are because its a URL

I tried this but dont get any data returned

$response = file_get_contents('http://<iphere:8080/nfaapi/json/device/getTrafficData?apiKey=<apikeyhere&Type=percentage&granularity=1&DeviceID=5000001&TimeFrame=hourly');

//decoding the above JSON string
$json = json_decode($response,true);

$Name = $json->Data[0]->Name;
echo $Name;

[DaemonProjects]

Figured it out yay

had to use the following

$Name = $json['Data']['Name'];
echo $Name;

[DaemonProjects]

Issue I have now is that the JSON data has an array within "trafficdata" I am unable to loop through it, any ideas?

//decoding the above JSON string
$json = json_decode($response,true);

$Name = $json['Data']['Name'];
$RouterIP = $json['Data']['RouterIP'];

// Get main Info
echo $Name."<br>";
echo $RouterIP."<br>";

// Get Traffic Info
$trafficdata = $json['Data']['trafficdata'];
print_r($trafficdata);

// Loop through Traffic Array
foreach($json['Data']['trafficdata'] as $key => $traffic) {
	echo $traffic['Traffic IN']."<Br>";
}

When I do a print_r I get the following array

Array ( [0] => Array ( [0] => Traffic IN [1] => 0.06 % [2] => 0.02 [3] => 155.52 MB [4] => 0.12% [5] => 0.03% [6] => 0.01% ) [1] => Array ( [0] => Traffic OUT [1] => 0.03 % [2] => 0.01 [3] => 74.58 MB [4] => 0.04% [5] => 0.02% [6] => 0.00% ) )

Is there a better way than this to get the data?

// Loop through Traffic Array
foreach($json['Data']['trafficdata'] as $traffic) {
	echo $traffic[0]." | ".$traffic[1]." | ".$traffic[3]." | ".$traffic[4]." | ".$traffic[5]." | ".$traffic[6]."<Br>";
}

[NogDog]

If the intent is to omit index #2, I might do something like this to make it a bit cleaner:

foreach($json['Data']['trafficdata'] as $traffic) {
  unset $traffic[2]; // we're working with a copy at this point, so no harm to source data
  echo implode(' | ', $traffic).'<br>';
}