how do I replace the content of a key in my json and save back on shopware 6.5 using php

I am working on a shopware project that requires me setup a json of all orders that is processed.

the json is stored in a directory which I have gotten out and passed to a variable $fil.

$filer =  $order1->getOrderNumber() . '_' . $country2->getIso() . '.json';
$fil = __DIR__ . '/' . $filer;

$file_contents = file_get_contents($fil);

The gotten json stored in variable $fil is then passed to variable $jsonData

$jsonData = $fil;

I am trying to replace the value of a key as below by decoding the JSON into an associative array

$data = json_decode($jsonData, true);

The key to be replaced is as below (trying to replace ID)

$data['entity']['payments'][0]['state']['id'] = $logMessageId;

I then try to save it back in variable modifiedJsonData and replace back to directory

$modifiedJsonData = json_encode($data, JSON_PRETTY_PRINT);

file_put_contents($fil, $modifiedJsonData);

it seemed to work partially but not fully, instead of replacing the (ID) alone

as here : $data['entity']['payments'][0]['state']['id']

its replaces all the content of the json as below, the json content is supposed to be more than the below:

{
    "entity": {
        "payments": [
            {
                "state": {
                    "id": #####
                }
            }
        ]
    }
}

Please help, what could I be doing wrong

Have the correct JSON Text in $jsonData and use two flags when you decode your JSON with json_decode(), the first always, the second more specifically in your current scenario:

1. JSON_THROW_ON_ERROR
2. JSON_BIGINT_AS_STRING

Example:

$data = json_decode($jsonData, true, flags: JSON_THROW_ON_ERROR | JSON_BIGINT_AS_STRING);

(since PHP 8.0)

$data = json_decode($jsonData, true, 512, JSON_THROW_ON_ERROR | JSON_BIGINT_AS_STRING);

(since PHP 7.3)

JSON_THROW_ON_ERROR

The reason why you only see the JSON for $data['entity']['payments'][0]['state']['id'] is, because the $data = json_decode(...) operation returned null because the parsing failed. Using the JSON_THROW_ON_ERROR will turn any error into an exception, making this more visible because it stops the script on error.

This prevents you to search the error in later output.

> Throws JsonException if an error occurs instead of setting the global error state that is retrieved with json_last_error() and json_last_error_msg(). JSON_PARTIAL_OUTPUT_ON_ERROR takes precedence over JSON_THROW_ON_ERROR. Available as of PHP 7.3.0. (PHP Manual)

JSON_BIGINT_AS_STRING

> Decodes large integers as their original string value. (PHP Manual)

BIGINT is referring to BigInt (ECMA 262), a Javascript number value type for very large (negative and positive) integer numbers, json_decode() can easily loose precision with (3v4l.org demo):

var_dump(json_decode('4599999999999999999999999999999999'));
var_dump(json_decode('4599999999999999999999999999999999', true, 512, JSON_BIGINT_AS_STRING));

float(4.6E+33)
string(34) "4599999999999999999999999999999999"

• Cf. Q&A "Is there a BigInteger class in PHP?"
• https://www.php.net/manual/en/function.json-decode.php
• https://www.php.net/manual/en/class.jsonexception.php

I was also able to find away around it by:

<?php
	$data = json_decode($jsonData, true, 512, JSON_BIGINT_AS_STRING);
	$data['entity']['payments'][0]['state']['id'] = $logMessageId;
    $modifiedJsonData = json_encode($data, JSON_PRETTY_PRINT);
	$existingData = json_decode(file_get_contents($fil), true);
	$existingData['entity']['payments'][0]['state']['id'] = $data['entity']['payments'][0]['state']['id'];
	$updatedJsonData = json_encode($existingData, JSON_PRETTY_PRINT);
	file_put_contents($fil, $updatedJsonData);