PHP中的PHP / JSON解码多数组[关闭]

Question

Hy Guys,

i have problem with decode json data in php.

There is json input:

{
    "name":" Test",
    "data":[
        [
            1388617200,
            35
        ],
        [
            1388703600,
            35.2
        ],
        [
            1388962800,
            35.15
        ],
        [
            1389049200,
            34.95
        ],
        [
            1389135600,
            35.1
        ],
        [
            1389222000,
            35.1
        ]
    ]
}

How to parsing field data array , these data need to be saved in MySQL DB

Many thanks for help

Answer 1

It's like:

$d = json_decode($yourArray["data"]);
foreach($d as $x) {
    $timestamp = $x[0];
    $whatever  = $x[1];
    mysql_query("insert into yourTable set
        field1='$timestamp',
        field2='$whatever'
    ");
 }

Approximately. This example is not to be used in production of course, I'm not even sure it doesn't have typos or something - but the principle should be clear. If this looks messy and you can't implement it in your project, (really-really no offense but) I suggest you to keep reading PHP docs and learn how its data structures work.