Welcome to all phpBB2 Refugees!This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area. |
|
Author |
Message |
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: Wed Jul 04, 2012 12:56 pm Post subject: 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 description\n \n",
"testaccountcat": "intl",
"deptimages":
[
"http://www.test.com/creativedeptlogo.jpg",
"http://www.test.com/creativedepthead.jpg.jpg"
],
"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 description\n \n
[testaccountcat] => intl
[deptimages] => Array
(
[0] => http://www.test.com/creativedeptlogo.jpg
[1] => http://www.test.com/creativedepthead.jpg.
)
[officenumber] => 8531212
)
)
)
Thanks in advance for any input _________________ http://www.jlaforums.com |
|
Back to top |
|
|
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: Thu Jul 05, 2012 1:04 pm Post subject: Re: JSON PHP Question |
|
|
Wanted to clarify a bit
Sorry, here are the items in code brackets
Using this test received JSON result (there is only 1 result in this example but other uses might have multiple results)
Code: | {
"success": true,
"numResults": 1,
"execTimeMs": 10,
"results":
[
{
{
"TestAccount": "testingaccount1",
"testnotes": {
"test_department": "creative",
"test_office_location": "98th Floor"
},
"testdescription": "creative test description\n \n",
"testaccountcat": "intl",
"deptimages":
[
"http://www.test.com/creativedeptlogo.jpg",
"http://www.test.com/creativedepthead.jpg.jpg"
],
"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
Code: | $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
Code: | 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 description\n \n
[testaccountcat] => intl
[deptimages] => Array
(
[0] => http://www.test.com/creativedeptlogo.jpg
[1] => http://www.test.com/creativedepthead.jpg.
)
[officenumber] => 8531212
)
)
) |
Someone made a comment
Quote: | They are already in array variables, so there is really no need to assign them to other variables. |
Quote: | but for example, if you want to reference the "testingaccount1" value, it would appear to be: Code: | $out['results'][0]['testAccount'] |
|
I understand what was said there. I should have used the multiple result example as it is more relevant to the point of my question - so I'll provide and example output for $out with a multiple result JSON decode
Code: |
[0] => Array
(
[testAccount] => testingaccount1
[testnotes] => Array
(
[test_department] => creative
[test_office_location] => 98th Floor
)
[testdescription] =>
creative test description\n \n
[testaccountcat] => intl
[deptimages] => Array
(
[0] => http://www.test.com/creativedeptlogo.jpg
[1] => http://www.test.com/creativedepthead.jpg
)
[officenumber] => 8531212
)
[1] => Array
(
[testAccount] => testingaccount2
[testnotes] => Array
(
[test_department] => security
[test_office_location] => 97th Floor
)
[testdescription] =>
security test description\n \n
[testaccountcat] => govt
[deptimages] => Array
(
[0] => http://www.test.com/securitydeptlogo.jpg
[1] => http://www.test.com/securitydepthead.jpg
)
[officenumber] => 8765309
)
)
)
|
So when we have these decoded JSON results, there may be anywhere from 1 to 200 results. So each individual result set starts with
Code: | [0] => Array
then the next result set is
[1] => Array
and the next
[2] => Array
and so on..... |
We need to take each of the items from each result set and inject them into a MYSQL Table that contains matching fields. Just not sure the easiest way to do this since the result set numbers change and the number of results can be different each time.
Thanks again. _________________ http://www.jlaforums.com |
|
Back to top |
|
|
drathbun Board Member
Joined: 24 Jul 2008
Posts: 729 Location: Texas
|
Posted: Mon Jul 09, 2012 9:43 am Post subject: Re: JSON PHP Question |
|
|
I've never used this technique, so I am not familiar with it. Sorry... _________________ phpBBDoctor Blog |
|
Back to top |
|
|
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: Wed Jul 18, 2012 12:21 pm Post subject: Re: JSON PHP Question |
|
|
No problem. We figured it out.
Thanks _________________ http://www.jlaforums.com |
|
Back to top |
|
|
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: Tue Nov 20, 2012 11:37 am Post subject: Re: JSON PHP Question |
|
|
Figured we would share a bit of code that starts this all out in case anyone else is working on this issue
Code: |
//JSON Code Snipped - JLA
//Using PHP 5.2.X
//After you make a query of your stored JSON URLs
foreach($jsonurls as $jsonstuff)
{
echo "-->Assigning URL variable for Json query\n";
$jsonurl = $jsonstuff['URL'];
echo "-->Successfully assigned URL variable\n";
echo "-->Now querying Json URL $jsonurl\n\n";
$json = file_get_contents($jsonurl);
$out = json_decode($json,true);
foreach($out['results'] as $record)
{
echo "-->Assigning variables from Json data URL $jsonurl\n";
$yourvariable = $record['someJsonrecord'];
$yourvariable1 = $record['someJsonrecord1'];
echo "-->Variables assigned successfully\n";
}
}
//END JSON Code Snippet - JLA
|
_________________ http://www.jlaforums.com |
|
Back to top |
|
|
Holger Board Member
Joined: 19 Jan 2009
Posts: 509 Location: Hanover
|
Posted: Wed Nov 21, 2012 3:49 am Post subject: Re: JSON PHP Question |
|
|
Ummmm, what does this actually do? _________________ Love your data! Back it up! |
|
Back to top |
|
|
JLA Board Member
Joined: 30 Apr 2009
Posts: 451 Location: U.S.A
|
Posted: Wed Nov 21, 2012 10:41 am Post subject: Re: JSON PHP Question |
|
|
Holger wrote: | Ummmm, what does this actually do? |
Allows you to use PHP to take a JSON source http://www.json.org/ and use and/or manipulate the data for your choosing. _________________ http://www.jlaforums.com |
|
Back to top |
|
|
|
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0687 seconds using 17 queries. (SQL 0.0104 Parse 0.0007 Other 0.0575) |
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com
|
|