convert json format to other array type json format

Question

I have a json format and want to convert this to my customized format. Please help me for this conversion using PHP. Please help me out, how can i construct the above mentioned JSON array format. Here is my format:

{
"success": true,
"code": 601,
"u_id": "9",
"h_id": "5",
"data": [{
    "mp_cat": "Conveyance",
    "mp_id": "5",
    "mp_rating": "4",
    "mp_price": "630.00"
}, {
    "mp_cat": "Food & Drinks",
    "mp_id": "3",
    "mp_rating": "4",
    "mp_price": "104.55"
}, {
    "mp_cat": "Food & Drinks",
    "mp_id": "4",
    "mp_rating": "3",
    "mp_price": "450.00"
}]
}

And want this kind of format:

 {
"success": true,
"code": 601,
"u_id": "9",
"h_id": "5",
"category": [{
    "Name": "Food & Drinks",
    "data": [{
        "mp_cat": "Food & Drinks",
        "mp_id": "3",
        "mp_rating": "4",
        "mp_price": "104.55"
    }, {
        "mp_cat": "Food & Drinks",
        "mp_id": "4",
        "mp_rating": "3",
        "mp_price": "450.00"
    }]
}, {
    "Name": "Conveyance",
    "data": [{
        "mp_cat": "Conveyance",
        "mp_id": "5",
        "mp_rating": "4",
        "mp_price": "630.00"
    }]
}]
}

From where you are getting this json?

AnkiiG
– AnkiiG

2016-01-20 07:08:35 +00:00
Commented Jan 20, 2016 at 7:08 — AnkiiG
– AnkiiG, Commented Jan 20, 2016 at 7:08
getting form a mysql query

deepak bhardwaj
– deepak bhardwaj

2016-01-20 07:13:55 +00:00
Commented Jan 20, 2016 at 7:13 — deepak bhardwaj
– deepak bhardwaj, Commented Jan 20, 2016 at 7:13
Will you share that code @deepakbhardwaj

AnkiiG
– AnkiiG

2016-01-20 07:14:22 +00:00
Commented Jan 20, 2016 at 7:14 — AnkiiG
– AnkiiG, Commented Jan 20, 2016 at 7:14

Chetan Ameta · Accepted Answer · 2016-01-20 07:29:39Z

1

you can use simple foreach loop to construct your data, or reformat json. Halve a look on below solution:

$json = '{
"success": true,
"code": 601,
"u_id": "9",
"h_id": "5",
"data": [{
    "mp_cat": "Conveyance",
    "mp_id": "5",
    "mp_rating": "4",
    "mp_price": "630.00"
}, {
    "mp_cat": "Food & Drinks",
    "mp_id": "3",
    "mp_rating": "4",
    "mp_price": "104.55"
}, {
    "mp_cat": "Food & Drinks",
    "mp_id": "4",
    "mp_rating": "3",
    "mp_price": "450.00"
}]
}';

$json_array = json_decode($json, true);
$new_array = array();
$category_array = array();
foreach($json_array as $key => $array){
    if($key == 'data'){
        foreach($array as $a){
            $category_array[$a['mp_cat']]['name']= $a['mp_cat'];
            $category_array[$a['mp_cat']]['data'][]= $a;
        }
    } else{
        $new_array[$key] = $array;
    }
}

$new_array['category'] = array_values($category_array);
echo json_encode($new_array);

Output:

{
    "success": true,
    "code": 601,
    "u_id": "9",
    "h_id": "5",
    "category": [{
        "name": "Conveyance",
        "data": [{
            "mp_cat": "Conveyance",
            "mp_id": "5",
            "mp_rating": "4",
            "mp_price": "630.00"
        }]
    }, {
        "name": "Food & Drinks",
        "data": [{
            "mp_cat": "Food & Drinks",
            "mp_id": "3",
            "mp_rating": "4",
            "mp_price": "104.55"
        }, {
            "mp_cat": "Food & Drinks",
            "mp_id": "4",
            "mp_rating": "3",
            "mp_price": "450.00"
        }]
    }]
}

answered Jan 20, 2016 at 7:29

Chetan Ameta

7,8943 gold badges34 silver badges46 bronze badges

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

3 Comments

deepak bhardwaj Over a year ago

How to convert this JSON [{"label":"Food & Drinks","data":"2"},{"label":"Lifestyle","data":"1"}] to [["Food & Drinks", 2],["Lifestyle", 1]] using php

Chetan Ameta Over a year ago

please post a new question on SO

deepak bhardwaj Over a year ago

stackoverflow.com/questions/35269178/…

Collectives™ on Stack Overflow

convert json format to other array type json format

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related