Count of Distinct Values From Json via PHP

Asked Nov 06 '20 at 12:35

Active Nov 06 '20 at 13:47

Viewed 35 times

[
    {
        "Product_ID": "24222",
        "Product_SKU": "406",
    }, {
        "Product_ID": "24218",
        "Product_SKU": "464",
    }, {
        "Product_ID": "24211",
        "Product_SKU": "231",
    }, {
        "Product_ID": "24212",
        "Product_SKU": "231",
    }, {
        "Product_ID": "24213",
        "Product_SKU": "231",
    }, {
        "Product_ID": "24207",
        "Product_SKU": "076",
    }, {
        "Product_ID": "24208",
        "Product_SKU": "076",
    }, {
        "Product_ID": "24202",
        "Product_SKU": "075",

    }
]

Hello I added example json file.How can i get count of unique values of Product_SKU ?I try many thing and searched same issues in stackoverflow but i cant find solution.Someone can help me ?

SOLUTION : count(array_unique(array_column($yourArray, "Product_SKU")));

THANK YOU : Esteban MANSART

edited Nov 06 '20 at 13:47

asked Nov 06 '20 at 12:35

babax

3

`count(array_unique(array_column($yourArray, "Product_SKU")));` – Esteban MANSART Nov 06 '20 at 12:38
Your JSON structure is wrong. – Wais Kamal Nov 06 '20 at 12:39
2

please share with us your best attempt (code) and fix your json, it's invalid. please read [ask]! – jibsteroos Nov 06 '20 at 12:42
I guess this was just an exemple, he's working in PHP, so we don't car about the exact format of his json array – Esteban MANSART Nov 06 '20 at 12:43
@EstebanMANSART what does that mean: _he's working in PHP, so we don't car about the exact format of his json array_? – jibsteroos Nov 06 '20 at 12:50
In addition to the marked duplicate, you would just have to do json_decode(). – nice_dev Nov 06 '20 at 12:52
Hello, Sorry for late answer.@jibsteroos No, json code is that and format must be that.Its no have node name like data or products.Code is that.Actually Its because i cant find solution. – babax Nov 06 '20 at 13:30

Count of Distinct Values From Json via PHP

0 Answers0