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

使用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条回答 默认 最新

  • doulidai6316 2018-04-28 01:45
    关注

    If you look at the decoded json (print_r($data)), you will see this:

    Array
    (
        [status] => 1
        [response] => Array
            (
                [Aviator Goggles] => Array
                    (
                        [price] => 1009
                        [quantity] => 269
                    )
    
                [Aviator Sunglasses] => Array
                    (
                        [price] => 460
                        [quantity] => 187
                    )
    
                [BIKER CRATE] => Array
                    (
                        [price] => 29
                        [quantity] => 3569
                    )
    
            )
    
        [time] => 1524852778
    )
    

    To do your database insert (I am replicating your mysql calls here but you really should upgrade, at the very least to MySQLI but in my opinion PDO is better and also to using prepared statements), you need to iterate through $data['response']:

    foreach ($data['response'] as $key => $item) {
        mysql_query("INSERT INTO `c5f` (response, price, quantity) 
            VALUES ('$key','{$item['price']}','{$item['quantity']}')") or die(mysql_error());
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?