dougu1045
2018-04-27 18:39
浏览 124
已采纳

使用PHP将JSON数据插入MySQL

I tried to insert it to MySQL Base but its not work for me, please help to solve this. This is how JSON looks like:

{
    "status": 1,
    "response": {
        "Aviator Goggles": {
        "price": 1009,
        "quantity": 269
    },
    "Aviator Sunglasses": {
        "price": 460,
        "quantity": 187
    },
    "BIKER CRATE": {
        "price": 29,
        "quantity": 3569
    }
 },
    "time": 1524852778
}

My php code to parse and insert the data:

<?php
$jsonurl = "https://api.opskins.com/IPricing/GetAllLowestListPrices/v1/?appid=578080&format=json_pretty";
$json = file_get_contents($jsonurl);
$data = json_decode($json, true);
print_r ($data);

mysql_connect("127.0.0.1", "root", "") or die (mysql_error ());
mysql_select_db("pubg") or die(mysql_error());

foreach($data as $item) {

       mysql_query("INSERT INTO `c5f` (response, price, quantity) 
       VALUES ('".$item['response']."','".$item['price']."','".$item['quantity']."')") or die(mysql_error());
     }
?>
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

3条回答 默认 最新

相关推荐 更多相似问题