主页 / 问题 / 1277750
Accepted
Иван
Asked:2022-05-04 01:00:21 +0000 UTC2022-05-04 01:00:21 +0000 UTC

如何从 JSON 中获取数据并将其保存到数据库？

  • 772

有一个这样的json字符串：

{"status":{"timestamp":"2021-05-03T16:47:16.362Z","error_code":0,"error_message":null,"elapsed":370,"credit_count":0,"notice":null},"data":{"2016-10-26T02:39:28.000Z":{"BTC":[1],"USD":[660.28167725,87283944,10525640015.288086]},"2016-10-27T02:39:28.000Z":{"BTC":[1],"USD":[702.39459229,89816296,11200777509.550781]}}}

如何从数据中获取数据？

对日期本身感兴趣，3 个版本的美元。

在此处输入图像描述

像这样尝试过，但无法让它工作：

$json = file_get_contents($json_url);
$data = json_decode($json);

foreach ($data as $item) {
    echo $item->USD;
}

结果：

stdClass Object
(
[status] => stdClass Object
    (
        [timestamp] => 2021-05-03T16:47:16.362Z
        [error_code] => 0
        [error_message] => 
        [elapsed] => 370
        [credit_count] => 0
        [notice] => 
    )

[data] => stdClass Object
    (
        [2016-10-26T02:39:28.000Z] => stdClass Object
            (
                [BTC] => Array
                    (
                        [0] => 1
                    )

                [USD] => Array
                    (
                        [0] => 660.28167725
                        [1] => 87283944
                        [2] => 10525640015.288
                    )

            )

        [2016-10-27T02:39:28.000Z] => stdClass Object
            (
                [BTC] => Array
                    (
                        [0] => 1
                    )

                [USD] => Array
                    (
                        [0] => 685.96984863
                        [1] => 93600296
                        [2] => 10936274615.024
                    )

            )
php

1 个回答

  1. Best Answer

    通过将 true 作为第二个参数添加到 json_decode 然后像这样的东西更容易转换为数组

    $data = json_decode($json, true);
foreach($data['data'] as $datetime => $v) {
   foreach($v['USD'] as $val) {
      echo "$datetime $val<br>\n";
   }
}
    • 2

相关问题