php - JSON API 到 MySQL 表

Question

我有一个 API 请求，我需要将它放入 MySQL 数据库

API 示例

"items": [
    {
        "market_name": "\u2605 Bayonet",
        "market_hash_name": "\u2605 Bayonet",
        "icon_url": "\/\/steamcommunity-a.akamaihd.net\/economy\/image\/-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXU5A1PIYQh5hlcX0nvUOGsx8DdQBJjIAVHubSaKQZ53P3NZXMXvYmykdLSxqWkZ7-HkjMIvpIj3u2Y84733gzh_RU_MG_zIYLEdQ45fxiOrdJh0ExF",
        "name_color": "8650AC",
        "quality_color": "EB4B4B"
    },
    {
        "market_name": "\u2605 Bayonet | Blue Steel (Battle-Scarred)",
        "market_hash_name": "\u2605 Bayonet | Blue Steel (Battle-Scarred)",
        "icon_url": "\/\/steamcommunity-a.akamaihd.net\/economy\/image\/-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KU0Zwwo4NUX4oFJZEHLbXH5ApeO4YmlhxYQknCRvCo04DEVlxkKgpotLu8JAllx8zJYAJA4MmzkL-DkvbiKvXTkzNVucNzj7mX9tWk21Xkr0JvN231JYGcdA47NF3Y81Hoxebs1sftot2XnmcyW1u0",
        "name_color": "8650AC",
        "quality_color": "EB4B4B"
    },

和我的 PHP 文件

$json = file_get_contents('API Link');
$obj = json_decode($json,true);

$hostname="localhost";
$database="API";
$username="XxX";
$password="XxX";

$link = mysql_connect($hostname, $username, $password);
 mysql_select_db($database) or die('Could not select database');

我知道使用一个项目很热

$obj['items'][0]['market_name'];

我需要自动将数字从 0 更改为 7226，然后将其添加到数据库中。你能帮帮我吗？

Answer 1

试试这个:

$items = $obj['items'];
for($i=0; $i<count($items);$i++){
    //Do the stuff whatever you want to do inside the loop
    // $i will change the index from 0 to the last index of array $items

    $market_name = $items[$i]['market_name'];
}