[Solved] How to consume a json object in PHP

by


There are two steps to take:
1. load the JSON data
2. understand the JSON data
3. load the data in a database

Your code appears to load the JOSN data using curl. In my experience, curl is powerful but complex for beginners. Probable file_get_contents() http://php.net/manual/en/function.file-get-contents.php works as well and is more easy.

e.g.
$json_data = file_get_contents(“URL TO DATA”);

Second, there are some JSON function in PHP. I like the json_decode function http://php.net/manual/en/function.json-decode.php. e.g. by using

$array = (json_decode($json_data, true));

to get the data in an array.

Third, this totale depends on the database setup (mysql?). Make sure you have a connection, a database and a table. Then you can use an insert query and insert the data from the $array.

solved How to consume a json object in PHP