[RESOLVED] json_decode HELPPP

[gogiddem]

I seem to be getting this error message for this script. Does anyone know how I can fix it? Notice that the code works because the word "love" appears at the end of the error message. I just need to figure out how to get rid of the error...

This is the code:

$json='{"emotion":"love"}';

$json_a=json_decode($json,true);

echo $json_a[emotion];
?>

This is the output:

Notice: Use of undefined constant emotion - assumed 'emotion' in /Users/my_computer/Sites/widget_corp/content_test4.php on line 15 love

[bradgrafelman]

PHP manual can explain it as well (or better, probably) than I can:

Why is $foo[bar] wrong?

[gogiddem]

Thanks a lot man... It worked like a charm...

Does anyone have any incite as to why I'm getting an error for this?

It keeps outputting:
"Warning: Invalid argument supplied for foreach() in /Users/justinkline/Sites/widget_corp/content_test5.php on line 100"

I checked out line 100 and couldn't figure it out...

Here's the code:

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php
find_selected_page();
	?>
<?php include("includes/header.php"); ?>

<?php

function breaker()
{
echo "<br />";
}

$string='{"resultsPage":
{"results":
{"calendarEntry":
[
{"event":

{"popularity":0.05746,"uri":"http:\/\/www.songkick.com\/concerts\/8078716-xavier-rudd-at-930-club?utm_source=4686&utm_medium=partner", 
"location": 
{"city":"Washington, DC, US","lng":-77.023718,"lat":38.9178595
}
,"displayName":"Xavier Rudd and Honeyhoney at 9:30 Club (May 13, 2011)","id":8078716,"start":

{"time":"20:00:00","date":"2011-05-13",

"datetime":"2011-05-13T20:00:00-0500"
},

"type":"Concert","performance":
[
{"artist":
{"uri":"http:\/\/www.songkick.com\/artists\/240231-xavier-rudd?utm_source=4686&utm_medium=partner", "displayName":"Xavier Rudd","id":240231,"identifier":
[
{"href":"http:\/\/api.songkick.com\/api\/3.0\/artists\/mbid:6689a626-4de7-41d5-9ec3-5a289472a9e2.json", "mbid":"6689a626-4de7-41d5-9ec3-5a289472a9e2"
}
]
},"displayName":"Xavier Rudd", "billingIndex":1,"id":14926431, "billing":"headline"
},
{
"artist":
{"uri":"http:\/\/www.songkick.com\/artists\/2313849-honeyhoney?utm_source=4686&utm_medium=partner", "displayName":"Honeyhoney", "id" 2313849, "identifier":
[
{"href":"http:\/\/api.songkick.com\/api\/3.0\/artists\/mbid 449b43e3-2891-4a49-a150-3f22ea934eec.json", "mbid":"449b43e3-2891-4a49-a150-3f22ea934eec"
}
]
}, "displayName":"Honeyhoney", "billingIndex":2, "id":16018771, "billing":"headline"
}
], "venue":

{"uri":"http:\/\/www.songkick.com\/venues\/922-930-club utm_source=4686&utm_medium=partner", "displayName":"9:30 Club","id":922,"lng":-77.023718, "metroArea":

{"uri":"http:\/\/www.songkick.com\/metro_areas\/1409-us-washington?utm_source=4686&utm_medium=partner", "displayName":"Washington", "country":

{"displayName":"US"},

"id":1409,

"state":
{"displayName":"DC"
}
},

"lat":38.9178595
},"status":"ok"
}, "reason":

{"trackedArtist":
[

{"uri":"http:\/\/www.songkick.com\/artists\/240231-xavier-rudd?utm_source=4686&utm_medium=partner", "displayName":"Xavier Rudd","id":240231,"onTourUntil":"2011-07-30", "identifier":
[
{"href":"http:\/\/api.songkick.com\/api\/3.0\/artists\/mbid:6689a626-4de7-41d5-9ec3-5a289472a9e2.json", "eventsHref":"http:\/\/api.songkick.com\/api\/3.0\/artists\/mbid:6689a626-4de7-41d5-9ec3-5a289472a9e2\/calendar.json",

"mbid":"6689a626-4de7-41d5-9ec3-5a289472a9e2",

"setlistsHref":"http:\/\/api.songkick.com\/api\/3.0\/artists\/mbid:6689a626-4de7-41d5-9ec3-5a289472a9e2\/setlists.json"
}
]
}
]
},

"createdAt":"2011-03-01T19:31:43+0000"
}
}
]
}
}
}';

// create array from string
$json_a=json_decode($string,true);
// create object from string
$json_o=json_decode($string);

// array method
foreach($json_a['resultsPage']['results']['calendarEntry'] as $p)
{
echo '

Event Popularity: '.$p['event']['popularity'].',
City: '.$p['location']['city'].'';
breaker();

}
?>

<?php include("includes/footer.php"); ?>

[bradgrafelman]

$json_a['resultsPage']['results']['calendarEntry'] is not an array, according to the error message. That's probably because $json_a itself will be NULL, since the JSON data you posted is malformed.

Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

[gogiddem]

Hello Brad,

What I really am trying to do is convert a large JSON file's data into a database. I was thinking that I could decode the JSON into an array using json_decode() and then use _POST to get that array into the Mysql database...

I'm a little new to PHP... Maybe you can help shed light on what could be a better approach.

[bradgrafelman]

The problem has nothing to do with your current methodology; it's just that the JSON data you have in the code snippet above is invalid and can't be parsed.

So.. my suggestion for a better approach would be: use valid JSON data. 😉

[gogiddem]

First off, thanks a lot! I really appreciate the help...

I'm dealing with a lot of data so I tried to extract a small portion of the entire feed manually so that I wouldn't have so much to work with. I attached a link to the entire JSON feed...

I tried inserting this feed within my previous code and I'm getting "Parse error: syntax error, unexpected T_STRING in /Users/justinkline/Sites/widget_corp/content_test5.php on line 23."

This message board doesn't allow me to post that many characters so I've added a link to a page that I posted all JSON data to, along with my PHP...

I'm a little lost since there is so much data to work with... I've been trying to figure out what would be the best way to get this data nicely organized within a mysql database...

Any ideas?

the URL to my code is: http://www.gogiddem.com/json.php

Thanks again,
Justin

[bradgrafelman]

You're missing a closing single quote on the $string variable.

[gogiddem]

Cool, I tried that but then I got this error: "Parse error: syntax error, unexpected T_VARIABLE in /Users/justinkline/Sites/widget_corp/content_test5.php on line 21"

I think it's referring to this code:

// create array from string
$json_a=json_decode($string,true);
// create object from string
$json_o=json_decode($string);

[bradgrafelman]

Sounds like you put the ending quote after the semicolon instead of before it.

[gogiddem]

I fixed that and now I'm getting another error...

Below is my code. I am using the JSON data from http://gogiddem.com/json_raww.php

Don't worry about the raww.php vs. raw.php... raww.php is so you can see the JSON data verbatim...

raw.php is just a file that I'm including so that I can use my $json variable which is just a consolidated form of the raww.php JSON data...

got to http://gogiddem.com/live_json.php to see the error that the code below is causing.

<html>
<head>
</head>
<body>
<?php

include("http://gogiddem.com/json_raw.php");

$string= '$json';





// create array from string 
$json_a=json_decode($string,true); 
// create object from string 
$json_o=json_decode($string); 
// array method 
foreach($json_a['resultsPage']['results']['calendarEntry'] as $p) { 
echo ' Event Popularity: '.$p['event']['popularity'].', 
City: '.$p['location']['city'].''; 
//} 


?>
</head>
</html>

Let me know what you think.

Thanks!

[gogiddem]

I think my foreach loop is off but I don't know how to fix it...

[bradgrafelman]

The URL http://gogiddem.com/json_raw.php outputs nothing but:

<br /><br />

so that's what your script is attempting to parse as JSON code.

EDIT: In addition, inside your foreach() loop you're attempting to access $p['location']['city'], which suggests that the 'location' element is a child of 'calendarEntry', yet in the JSON code you're using it appears to be another child of 'event' (just like 'popularity').

[gogiddem]

This is what's in the raw.php file...

I erased:
echo "<brb />";
echo "<brb />";

I'm still getting an error message for some reason...

<?php 

$username = "USERNAME";
$your_api_key = "MYKEY";
$song_conn = "http://api.songkick.com/api/3.0/users/{$username}/calendar.json?reason=tracked_artist&apikey={$your_api_key}";

$api_connect = file_get_contents($song_conn);



$json = $api_connect;






?>

[bradgrafelman]

You're getting an error message because now your code doesn't output anything, so the include() statement might as well be removed.

You should instead be include()'ing the above script via a local file path. Using include() on URLs means that PHP is going to make a request to the webserver, download the output, and then attempt to evaluate it as code. In other words, PHP is going to get the same data that you'd get in your browser (which, as I just said, is nothing at all now).

[gogiddem]

Brad, you're awesome, man!

I fixed it...

I really owe you one.

You wouldn't happen to have any suggestions for pulling and organizing the data so that it can be put in a database do you?

I want to have the columns in the database dynamically ingest the data below:
Artist or displayname
Time
Location or address
Venue
Latitude
Longitude
Popularity
URL
ID

Right now it looks like I am able to connect with the json data and create VERY simple arrays but I need to create meaningful data that is ready to send to MySQL...

Thanks again man!