How to change value of special key in json using php?

Question

I'm inserting value with implode and get this type json

[  
   {  
      "id":"1",
      "f_name":"Mitrajit",
      "l_name":"Samanta",
      "class":"XII",
      "section":"A,B,C",
      "roll":"1",
      "status":"1"
   }
]

but I want this type :-

[
  {
    "f_name" : "Mitrajit",
    "l_name" : "Samanta",
    "class"  : "XII",
    "section": ["A","B","C"],
    "roll"   : "1",
    "status" : "1"
  }
]

how can I get "A,B,C" to ["A","B","C"]?

can you clear specifically what is your main problem? you can just push A, B, C to section element of the array. Can you post your array from which you want to make this array of object? — A l w a y s S u n n y, Oct 06 '18 at 08:27
yes if I insert a,b,c as array in mysql database with php so who can I show data like ["a","b","c"] after json_encode() — Naveen Yadav, Oct 06 '18 at 08:30
then try [serialize] to store in mysql http://php.net/manual/en/function.serialize.php and [unserialize] to show data http://php.net/manual/en/function.unserialize.php — A l w a y s S u n n y, Oct 06 '18 at 08:34
this could give you more idea https://stackoverflow.com/questions/1978438/save-php-array-to-mysql — A l w a y s S u n n y, Oct 06 '18 at 08:38
@Mohammad so I just ask how to show and insert as array in json — Naveen Yadav, Oct 06 '18 at 09:04
You create first json or want to convert the first to second json? — Mohammad, Oct 06 '18 at 09:07

score 1 · Accepted Answer · answered Oct 06 '18 at 09:36

You need to use json_decode() to converting json to php array. Then select section value in json array and use explode() to converting it to array. At the end convert php array to json using json_encode()

$json = json_decode($jsonStr, true);
$json[0]["section"] = explode(",", $json[0]["section"]);
$jsonStr = json_encode($json);

Check result in demo

How to change value of special key in json using php?

1 Answers1