PHP process a JSON and write to mySQL

So the data provider gives me a JSON by the following export:

http://www.wardb.com/ExGuild.aspx?id=2295

I want to process it using PHP and enter all the data into my MySQL database. My site has a nice MySQL class which gives me the following usage for an example db write:

$db->query_write("REPLACE guildlist (class, demand) VALUES('Sorcerer', '$Sorcerer')");

So essentially, whats the most efficient way to get that JSON data into the DB?



Start Free Trial