我有一個json api提要，我想對其進行重組以在Google折線圖中使用，但是我不知道如何遍歷json數據以在php中創(chuàng)建一個新數組。為了使事情復雜化，我要為每個項目繪制的數據位于不同的行上。這是json數據{ "records": [ { "id": "2", "groupno": "1", "urlsource": "https://www.amazon.co.uk/Boot-Buddy-fastest-simplest-footwear/dp/B014UPAHO4?pd_rd_wg=lVVK6&pd_rd_r=bf1ba871-fb59-4c66-a146-e94dde7c8e6d&pd_rd_w=gWC2F&ref_=pd_gw_ri&pf_rd_r=W68MX1TXFDDJ8Q8Z08CP&pf_rd_p=cecd4520-32f6-5499-ae19-cd4e83816acd", "name": "Boot buddy", "date": "2019-04-14 16:00:29.595", "price": "￡14.99" }, { "id": "1", "groupno": "1", "urlsource": "https://www.amazon.co.uk/dp/B07CH6JKW3/ref=gw_uk_desk_h1_aucc_cp_mp?pf_rd_p=e4e5a2e6-ddbd-473a-a5fb-e8cc09a11f88&pf_rd_r=1MN25BRXY8YDQ4TBK4X6", "name": "Amazon echo", "date": "2019-04-14 16:00:29.595", "price": "￡19.99" }, { "id": "2", "groupno": "1", "urlsource": "https://www.amazon.co.uk/Boot-Buddy-fastest-simplest-footwear/dp/B014UPAHO4?pd_rd_wg=lVVK6&pd_rd_r=bf1ba871-fb59-4c66-a146-e94dde7c8e6d&pd_rd_w=gWC2F&ref_=pd_gw_ri&pf_rd_r=W68MX1TXFDDJ8Q8Z08CP&pf_rd_p=cecd4520-32f6-5499-ae19-cd4e83816acd", "name": "Boot buddy", "date": "2019-04-14 21:50:31.362", "price": "￡14.99" },我真的不知道從哪里開始。我發(fā)現的其他問題/解決方案沒有相同的原始數據格式。任何幫助表示贊賞！
1 回答
忽然笑
TA貢獻1806條經驗 獲得超5個贊
您可以在json上循環(huán)兩次-首先在數組上獲取所需的數據并將其格式化。
首先，將json循環(huán)為：
$arr = jsone_decode($jsonStr, true);
foreach($arr as $e) {
$data[$e["date"]][$e["name"]] = $e["price"];
}
現在，再次循環(huán)$data以格式化輸出：
$res[] = ['Date time', 'Boot buddy price', 'Amazon echo price']; // set the header
foreach($data as $k => $e) {
$res[] = [$k, $e["Boot buddy"], $e["Amazon echo"]];
}
而$res將包含你的愿望格式
- 1 回答
- 0 關注
- 129 瀏覽
添加回答
舉報
0/150
提交
取消