Menu
Community /Pin to ProfileBookmark
@NogDogJul 05.2012 — #They are already in array variables, so there is really no need to assign them to other variables. Since you did not wrap your output in [noparse]@NogDogJul 05.2012 — #Sounds like a job for a [url=http://php.net]foreach[/url] () loop.
(Obviously you want to do something other than just echo stuff in the loop. ? )
Another JSON PHP question
Having a bit of confusion with this.
Using this test received JSON result (there is only 1 result in this example but other uses might have multiple results)
{
“success”: true,
“numResults”: 1,
“execTimeMs”: 10,
“results”:
[
{
{
“TestAccount”: “testingaccount1”,
“testnotes”: {
“test_department”: “creative”,
“test_office_location”: “98th Floor”
},
“testdescription”: “creative test descriptionn n”,
“testaccountcat”: “intl”,
“deptimages”:
[
“
“
],
“officenumber”: 8531212
}
]
}
trying to figure out a way to have all of these items assigned as PHP variables for another script that would insert them into a MYSQL database.
So far have this
$url = “[we would have the url where the JSON data is available here that would produce the output seen in the example above]”
$json = file_get_contents($url);
$out = json_decode($json,true);
If I output $out to a file, I get this
Array
(
[success] => 1
[numResults] => 1
[execTimeMs] => 10
[results] => Array
(
[0] => Array
(
[testAccount] => testingaccount1
[testnotes] => Array
(
[test_department] => creative
[test_office_location] => 98th Floor
)
[testdescription] =>
creative test descriptionn n
[testaccountcat] => intl
[deptimages] => Array
(
[0] => [url]http://www.test.com/creativedeptlogo.jpg
[1] => [url]http://www.test.com/creativedepthead.jpg[/url].
)
[officenumber] => 8531212
)
)
)
Thanks in advance for any assistance
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogJul 05.2012 — #They are already in array variables, so there is really no need to assign them to other variables. Since you did not wrap your output in [noparse]...[code=php]$out['results'][0]['testAccount'][/code].0
@NogDogJul 05.2012 — #Sounds like a job for a [code=php]
foreach($out['results'] as $record)
{
echo $record['testAccount'];
echo $record['testnotes']['test_department'];
echo $record['testnotes']['test_office_location'];
}
[/code](Obviously you want to do something other than just echo stuff in the loop. ? )