使用PHP在MYSQL中插入JSON值

Question

I've this JSON string:

$json = '{
    "bigprodlist": {
        "prods": [
            {
                "code": 55,
                "name": "Comix Book",
                "link": "weblink"
            },
            {
                "code": 85,
                "name": "IT Book",
                "link": "weblink"
            },
            {
                "code": 95,
                "name": "Manga Book",
                "link": "weblink"
            }

        }
    }';

I'd like to print every single entry on a webpage using php and then save these entries on a mysql db. In the db there is already a "code", "name" and "link" field..

This is what I've tried without luck (to print the stuff on a page):

$obj = json_decode($json,true);
echo ($obj["bigprodlist"]["prods"][0]["name"]);

Thank you very much for the help

Answer 1

First, fix your JSON missing end bracket that makes JSON decoding fail (add the ] after the prods data ), then expand your echo statement with some foreach loops to get the data printed. This is only a simple example to get you on the right track:

foreach ($obj["bigprodlist"]["prods"] as $p):
    echo "<div>";
    foreach ($p as $name=>$value):
        echo "<span>".$name.": ".$value."</span>";
    endforeach;
   echo "</div>";
endforeach;

You can then use the same loop procedure to get the data into your DB.