Extracting values from JSON data

Question

I have the JSON data given below. The 'crop' array contains multiple array of crop price, I want to get average crop price of all districts(using 'district_id').

    <i>{
    "status": "ok",
    "count": 7,
    "crop": [
        {
            "id": "133",
            "crop_id": "81",
            "price": "45.00",
            "description": null,
            "user_id": "27",
            "block_id": "1",
            "longitude": "87.8661808",
            "latitude": "23.2340073",
            "date": "2014-02-03",
            "time": "12:44:43",
            "district_id": "1"
        },
        {
            "id": "135",
            "crop_id": "81",
            "price": "10.50",
            "description": null,
            "user_id": "27",
            "block_id": "1",
            "longitude": "87.8662402",
            "latitude": "23.2339822",
            "date": "2014-02-03",
            "time": "12:44:54",
            "district_id": "1"
        },
        {
            "id": "143",
            "crop_id": "81",
            "price": "35",
            "description": null,
            "user_id": "27",
            "block_id": "1",
            "longitude": "0.0",
            "latitude": "0.0",
            "date": "2014-02-03",
            "time": "13:12:50",
            "district_id": "1"
        },
        {
            "id": "146",
            "crop_id": "81",
            "price": "85",
            "description": null,
            "user_id": "27",
            "block_id": "1",
            "longitude": "0.0",
            "latitude": "0.0",
            "date": "2014-02-03",
            "time": "14:29:07",
            "district_id": "1"
        },
        {
            "id": "148",
            "crop_id": "81",
            "price": "25",
            "description": null,
            "user_id": "27",
            "block_id": "1",
            "longitude": "0.0",
            "latitude": "0.0",
            "date": "2014-02-03",
            "time": "14:58:01",
            "district_id": "1"
        },
        {
            "id": "132",
            "crop_id": "81",
            "price": "10",
            "description": null,
            "user_id": "119",
            "block_id": "34",
            "longitude": "0.0",
            "latitude": "0.0",
            "date": "2014-02-03",
            "time": "12:41:49",
            "district_id": "4"
        },
        {
            "id": "134",
            "crop_id": "81",
            "price": "12",
            "description": null,
            "user_id": "119",
            "block_id": "34",
            "longitude": "0.0",
            "latitude": "0.0",
            "date": "2014-02-03",
            "time": "12:43:50",
            "district_id": "4"
        }
    ]
}</i>

How about decode your json first using json_decode func.?

Rikesh
– Rikesh

2014-02-04 05:55:26 +00:00
Commented Feb 4, 2014 at 5:55 — Rikesh
– Rikesh, Commented Feb 4, 2014 at 5:55

Community · Accepted Answer · 2023-11-17 19:52:31Z

2

Use json_decode method to convert it to an std_class or use the 2nd parameter of this method to convert it to an associated array.

Take a look at https://www.php.net/json_decode

Once you decode it, you can easily access the variables like accessing properties of a class or as an array object if you are converting to an associated array

edited Nov 17, 2023 at 19:52

CommunityBot

11 silver badge

answered Feb 4, 2014 at 5:55

Abishek

11.8k19 gold badges75 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3907642 · Accepted Answer · 2014-08-04 18:21:41Z

0

First you have too decode the JSON using json_decode function, then access using variables.

answered Aug 4, 2014 at 18:21

user3907642

Comments

Shankar Narayana Damodaran · Accepted Answer · 2014-02-04 06:09:34Z

0

Do like this..

//Assign your JSON data to this $json variable as shown in the demo.
$arr = json_decode($json,1);
foreach($arr['crop'] as $arr1)
{
    foreach($arr1 as $k=>$v)
    {
        if($arr1['district_id']==1)
        {
            $avgpr[] = $arr1['price'];
        }
    }
}

echo $avgprice = array_sum($avgpr)/count($avgpr);

OUTPUT :

40.1

Demo

edited Feb 4, 2014 at 6:09

answered Feb 4, 2014 at 5:59

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

Collectives™ on Stack Overflow

Extracting values from JSON data

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related