I'm on PHP and I need to edit a JSON output to return only objects >=0 and divided by one hundred
Eg.
$json = {"data":[0,55,78,-32,-46,37]}
Needed
$json = {"data":[0,0.55,0.78,0.37]}
How this can be done?
2 Answers
Well, I know this is not the best practice, but if it's as simple as this, you can do the following.
$json = '{"data":[0,55,78,-32,-46,37]}';
// decoding the string to objects & arrays
$x = json_decode($json);
// applying a function on each value of the array
$x->data = array_map(
function($a)
{
if( $a >= 0 ) return $a/100;
else return null;
},
$x->data
);
// Removing empty values of the array
$x->data = array_filter($x->data);
// making a JSON array
$jsonData = json_encode(array_values($x->data));
// inserting a JSON array in a JSON Object
$json = '{"data":' . $jsonData . '}';
// here is your {"data":[0,0.55,0.78,0.37]}
echo $json;
Hope it helps !
Btw, I had to trick the json encode with array_values to prevent the creation of an object rather than an array for the data content. But I guess there is a better method that I just don't know ...
EDIT :
Find out the way :D
Once empty values removed from the array, just do :
$x->data = array_values($x->data);
$json = json_encode($x);
This will do the trick and it will not create issues with the rest of the object.
5 Comments
Bobot
@Alessandro check out the EDIT :p
Bobot
Then you did not used array_values on it, I tried it and I have exactly this :
{"test":{"a": "b"}, "data":[0,0.55,0.78,0.37]} ... can you give a link to your current code ?Alessandro:
Here's my approach, feel free to try. json_decode and a simple foreach can help you...
Code:
$json = array();
$result = array();
$json = '{"data":[0,55,78,-32,-46,37]}';
$decoded_json=json_decode($json, TRUE);
foreach ($decoded_json['data'] as &$value) {
if ($value >= 0){
$value = $value / 100;
$result[]=$value;
}
}
echo json_encode($result);
?>
Result:
[0,
0.55,
0.78,
0.37
]
$json_array = json_decode($json,true); $json_data = $json_array["data"];Could you please help me a bit on the next step? Can I use the JSON as a simple PHP array? Sorry but it's not that clear to meprint_r($json_array);you actually see how the array structure looks like. And before you filter your array you want to either use a simple foreach loop orarray_map()to divide each number of your subArray by 100.data. For this you want to look at the second linked Q&A from my above comment. And in pseudo code this is what you want to do next:$json_array["data"] = filter($json_array["data"]);(The filter function is of course just pseudo code, but it is important that you just want to filter your subArray). After that at the end you just want to encode the array again.