modify json data in php laravel

Question

I've a sample json data

{
   "cities": {
          "total": 100,
          "count":5000,
          "cities_list" : [{
                 "name": "city1",
                 "count": 1000
          },
           {
                 "name": "city2",
                 "count": 2000
           }
          ]
   }


}

How can I append the cities_list array directly to cities which would look like

{
     "cities": [{
           "name": "city1",
           "count": 1000
      },
      {
           "name": "city2",
           "count": 2000 
      }
     ]
}

Can you share PHP code? Like how are you getting the data and what variables do you store them in? — apokryfos
– apokryfos, Commented Aug 13, 2021 at 17:56
Unfortunately, this is a piece where I got stuck on. As I dont have much knowledge on Json, I posted here. basically, this is a response coming from repository function with mysql db. — Digital404
– Digital404, Commented Aug 13, 2021 at 18:03

Szymon Pawlus · Accepted Answer · 2021-08-13 18:20:12Z

1

Not sure, about all the stuff, but i assume your "json" or just associative array is in variable (for example foo)

Now you should set:

$foo["cities"] = $foo["citites"]["citites_list"];

answered Aug 13, 2021 at 18:20

Szymon Pawlus

663 bronze badges

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

Comments

JON · Accepted Answer · 2021-08-14 08:11:17Z

0

Let's say that your JSON result is stored in a variable called $results

$results = json_decode($results,true); //convert json to array
    
$modifiedArray= [];

$modifiedArray= $results['cities']['cities_list']->map(function ($item, $key) {
    return ['cities'][][
        'name' => $item->name,
        'count' => $item->count
    ];
});

This is more of a laravel approach since you also tagged laravel. Your modified array is an array type if you want to be a JSON again you have to encode it into a JSON.

edited Aug 14, 2021 at 8:11

JON

1,0232 gold badges12 silver badges28 bronze badges

answered Aug 13, 2021 at 18:35

pr1nc3

8,3763 gold badges27 silver badges40 bronze badges

Comments

Karl · Accepted Answer · 2021-08-14 10:01:14Z

0

You can use the Unset function

$data= json_decode($your_json);
$json_arr = json_decode($your_json, true);   

unset($data->total);
unset($json_arr['total']);

answered Aug 14, 2021 at 10:01

Karl

154 bronze badges

Collectives™ on Stack Overflow

modify json data in php laravel

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