I am working with a JSON file and have encountered an issue when trying to delete an object. Whenever I create a new array and write it back to the original JSON file, the new data ends up overwriting the entire file.
I have tried using functions like array_merge, array_replace, array_merge_recursive, and array_replace_recursive, but they all result in the same outcome. I always end up with the first object deleted from my JSON structure:
{
"server": {
"SERVER-01": [
{
"svc": "SERVICE01",
"id": 1
},
{
"svc": "SERVICE02",
"id": 2
},
{
"svc": "SERVICE03",
"id": 3
},
{
"svc": "SERVICE04",
"id": 4
}
]
}
}
The original file contains data for multiple servers, as shown below:
{
"server": {
"SERVER-01": [
{
"svc": "SERVICE01",
"id": 1
},
{
"svc": "SERVICE02",
"id": 2
},
{
"svc": "SERVICE03",
"id": 3
},
{
"svc": "SERVICE04",
"id": 4
},
{
"svc": "SERVICE05",
"id": 5
}
],
"SERVER-02": [
{
"svc": "SERVICE01",
"id": 1
},
{
"svc": "SERVICE02",
"id": 2
},
{
"svc": "SERVICE03",
"id": 3
},
{
"svc": "SERVICE04",
"id": 4
},
{
"svc": "SERVICE05",
"id": 5
}
]
}
}
My question is, how can I update the data in a specific server array (e.g., SERVER-01) without removing or affecting the other arrays?
Here is the PHP code that I have been using:
// load file
$file = file_get_contents($filename_moni);
// decode copy of json to associative array
$data = json_decode($file, true);
// get ID to delete
$ID = $ID - 1;
unset($data['server'][$Server][$ID]);
$var=array();
foreach($data['server'][$Server] as $key => $item) {
$var['server'][$Server][] = $item;
}
foreach($var['server'][$Server] as $key => $item) {
if ( $key != $var['server'][$Server][$key]['id'] ) {
$var['server'][$Server][$key]['svc'] = $item['svc'];
$var['server'][$Server][$key]['id'] = $key + 1;
}
}
$data = array_replace($data,$var);
$jsondata = json_encode($data, JSON_PRETTY_PRINT|JSON_NUMERIC_CHECK);
file_put_contents($filename_moni, $jsondata);