如何从PHP中的JSON数组中获取公共值？

Question

实际上，我试图通过php从JSON获取公共值

我们有两个数组

$array1 = 
[
    {
        "flower_id": "1",
        "flower_price": "1",
        "flower_name": "Nelumbo"
    },
    {
        "flower_id": "2",
        "flower_price": "2",
        "flower_name": "Water"
    },
    {
        "flower_id": "3",
        "flower_price": "2",
        "flower_name": "Ladys"
    },
    {
        "flower_id": "4",
        "flower_price": "2",
        "flower_name": "Foxtail"
    },
    {
        "flower_id": "5",
        "flower_price": "2",
        "flower_name": "White"
    },
    {
        "flower_id": "6",
        "flower_price": "2",
        "flower_name": "Marigold"
    },
    {
        "flower_id": "7",
        "flower_price": "2",
        "flower_name": "Lotus"
    },
    {
        "flower_id": "8",
        "flower_price": "2",
        "flower_name": "Rhododendron"
    },
    {
        "flower_id": "9",
        "flower_price": "2",
        "flower_name": "Common"
    }]

下面是数组调用$array1，与此数组比较的另一个数组是

$array2 =
[
    {
        "flower_id": "1",
        "flower_name": "Nelumbo"
    },
    {
        "flower_id": "3",
        "flower_name": "Ladys Slipper"
    },
    {
        "flower_id": "5",
        "flower_name": "White Orchid-tree"
    },
    {
        "flower_id": "9",
        "flower_name": "Common Rhododendron"
    }
]

但是我们需要与这两个数组交互，我希望得到这样的结果

[
{
    "flower_id": "1",
    "flower_name": "Nelumbo",
    "flower_price": "1"
},
{
    "flower_id": "3",
    "flower_name": "Ladys Slipper",
    "flower_price": "2"
},
{
    "flower_id": "5",
    "flower_name": "White Orchid-tree",
    "flower_price": "2"
},
{
    "flower_id": "9",
    "flower_name": "Common Rhododendron",
    "flower_price": "2"
}

]

如何从这两个数组获得这个结果？我尝试过这样做，但它只显示了公共值，但我需要flower_price来

        $new_array = array_diff_key($array1,$array2);
        echo json_encode($supplierArray);

Answer 1

如果您想要找到公共项，一种快速的方法是通过flower_id (使用array_column())索引两个数组，然后执行一个array_intersect_key()来保存公共项，因为$array1是第一个数组，它将保留该数组中的所有细节。因为这会给您留下一个带键的数组，所以使用array_values()只提取内容.

$a1 = array_column($array1,null,"flower_id");
$a2 = array_column($array2,null,"flower_id");
echo json_encode(array_values(array_intersect_key($a1, $a2)));

用你的测试数据它会给出..。

[
    {
        "flower_id": "1",
        "flower_price": "1",
        "flower_name": "Nelumbo"
    },
    {
        "flower_id": "3",
        "flower_price": "2",
        "flower_name": "Ladys"
    },
    {
        "flower_id": "5",
        "flower_price": "2",
        "flower_name": "White"
    },
    {
        "flower_id": "9",
        "flower_price": "2",
        "flower_name": "Common"
    }
]