主页 / 问题 / 1057912
Accepted
JoelKamp
Asked:2020-12-13 02:02:37 +0000 UTC2020-12-13 02:02:37 +0000 UTC

如何按值连接这些 JSON？

  • 772

有这样的items.json：

[
  {
    "name": "Fluted Guard of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxMfcRlFwIBYYpbaaOA9vxv_MdC8M7tq0xoaOzvb2Z7iJxD8GsJIi0--Up9Sh0A2yr0pvZ22iJdXGdVQ5NUaQpAZGHIGG2g"
  },
  {
    "name": "Lion Quiver of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxtraRVhmahdbiauwIhFlwb2aImoS7oWwzIPYwqetYeKExm9SsMAg3b7AoNz32QDkqUNtMD2lJdPGbEZgNjYx8IO6"
  },
  {
    "name": "Bow of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiS1cDEHE54GgZYofT2e1cwgKWRc2pB74SyzNbYwfamZL6BwjgF65wn3eyRp96sjVbg_xFofSmtc2nZXSY6"
  }
]

这是 price.json：

{
    "data": [
        {
          "updated_at": 1576048969000,
          "prices": {
            "last": 5300
          },
          "name": "Lion Quiver of the Moon Rider"
        },
        {
          "updated_at": 1576048969000,
          "prices": {
            "last": 2000.12
          },
          "name": "Dragon Sheild"
        }
    ]
}

如何按商品名称匹配 price.json 中的价格？让它看起来像这样：

{
    "name": "Lion Quiver of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxtraRVhmahdbiauwIhFlwb2aImoS7oWwzIPYwqetYeKExm9SsMAg3b7AoNz32QDkqUNtMD2lJdPGbEZgNjYx8IO6",
   "price":5300
  }

我试图这样做，但结果是删除了重复的项目并且没有价格：

<?php

$jsonProducts = '[
  {
    "name": "Fluted Guard of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxMfcRlFwIBYYpbaaOA9vxv_MdC8M7tq0xoaOzvb2Z7iJxD8GsJIi0--Up9Sh0A2yr0pvZ22iJdXGdVQ5NUaQpAZGHIGG2g"
  },
  {
    "name": "Lion Quiver of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxtraRVhmahdbiauwIhFlwb2aImoS7oWwzIPYwqetYeKExm9SsMAg3b7AoNz32QDkqUNtMD2lJdPGbEZgNjYx8IO6"
  },
  {
    "name": "Lion Quiver of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxtraRVhmahdbiauwIhFlwb2aImoS7oWwzIPYwqetYeKExm9SsMAg3b7AoNz32QDkqUNtMD2lJdPGbEZgNjYx8IO6"
  }
  ]';

$jsonData = '{
    "data": [
        {
          "updated_at": 1576048969000,
          "prices": {
            "last": 5300
          },
          "name": "Lion Quiver of the Moon Rider"
        },
        {
          "updated_at": 1576048969000,
          "prices": {
            "last": 2000.12
          },
          "name": "T-shirts"
        }
    ]
}';

$data = json_decode($jsonData, true)['data'];

$products = array_column(json_decode($jsonProducts, true), null, 'name');

$result = array_map(function($item) use ($products) {
    $product              = new \stdClass();
    $product->market_name = $products[$item['name']]['name'];
    $product->size        = $products[$item['name']]['size'];
    $product->price       = $item['prices']['last'] ?? null;
    return $product;
}, $data);

$resultJson = json_encode($result);

var_dump($resultJson);
php

2 个回答

  1. Best Answer

    如果我理解正确，你可以这样做：

    $price = json_decode($jsonData, 1)['data'];
$json = json_decode($jsonProducts, 1);

foreach($price as $key => $value)
{
    foreach($json as $k => $value2) {
        if ($value['name'] === $value2['name']) {
            $json[$k]['price'] = $value['prices']['last'];
        }
    }
}

print_r($json);

    https://3v4l.org/mWaIS

    如果您只想对price找到的第一个匹配项（如果我们考虑重复）执行此操作，则可以执行以下操作：

    $bool = false;
foreach($price as $key => $value)
{
    foreach($json as $k => $value2) {
        if ($value['name'] === $value2['name']) {
            if ($bool !== true) {
                $json[$k]['price'] = $value['prices']['last'];
                $bool = true;
            }
        }
    }
}

    https://3v4l.org/X7FoM

    • 3 
  2. <?php
$main='{"data1":[
  {
    "name": "Fluted Guard of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxMfcRlFwIBYYpbaaOA9vxv_MdC8M7tq0xoaOzvb2Z7iJxD8GsJIi0--Up9Sh0A2yr0pvZ22iJdXGdVQ5NUaQpAZGHIGG2g"
  },
  {
    "name": "Lion Quiver of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiSxtraRVhmahdbiauwIhFlwb2aImoS7oWwzIPYwqetYeKExm9SsMAg3b7AoNz32QDkqUNtMD2lJdPGbEZgNjYx8IO6"
  },
  {
    "name": "Bow of the Moon Rider",
    "icon": "-9a81dlWLwJ2UUGcVs_nsVtzdOEdtWwKGZZLQHTxDZ7I56KW1Zwwo4NUX4oFJZEHLbXK9QlSPcU_oAlcQk2fVOiS1cDEHE54GgZYofT2e1cwgKWRc2pB74SyzNbYwfamZL6BwjgF65wn3eyRp96sjVbg_xFofSmtc2nZXSY6"
  }
]
}';

 $go='{
    "data": [
        {
          "updated_at": 1576048969000,
          "prices": {
            "last": 5300
          },
          "name": "Lion Quiver of the Moon Rider"
        },
        {
          "updated_at": 1576048969000,
          "prices": {
            "last": 2000.12
          },
          "name": "Dragon Sheild"
        }
    ]
}';

$result=json_decode($main,true);
//print_r($result);
$result1=json_decode($go,true);
foreach ($result as $key => $value) {
foreach ($value as $key1 => $value1) {

    foreach ($result1 as $key0 => $value0) {
foreach ($value0 as $key10 => $value10) {

if($value1['name']==$value10['name']){

    $arr['price']=$value10['prices']['last'];
    $arr['icon']=$value1['icon'];
    $arr['name']=$value1['name'];
}

}
}

}
}

print_r($arr);
    • 1

相关问题