How do I edit a JSON within my database?

Question

I have a JSON saved in my database. I would like to know how to edit this json using PHP and saving it again in the database.

The json that would like to change the value is this

{"3":{"tipo":"Premium","valor":"100","quantidade":"200","vendas":"0","status":"1"},"1":{"tipo":"Arena","valor":"50","quantidade":"200","vendas":"0","status":"1"}}

I’d like to change the values Sales for 10 and Status for

Answer 1

You can do direct by SQL through the functions for the type JSON:

UPDATE
    myTable
SET
    myColumn = JSON_SET(
        myColumn,
        '$.3.vendas', 10,
        '$.1.vendas', 10,
        '$.3.status', 0,
        '$.1.status', 0
    );

Remember that the JSON type and its functions are only available from version 5.7.8.

Answer 2

You can use the array_map to browse the array created with json_decode and apply the change wherever you want:

    $string = '{"3":{"tipo":"Premium","valor":"100","quantidade":"200","vendas":"0","status":"1"},"1":{"tipo":"Arena","valor":"50","quantidade":"200","vendas":"0","status":"1"}}';

    // transforma em array
    $jsonArray = json_decode($string, true);

    $jsonArray = array_map(function($e){
         $e['vendas'] = 10; // altera a venda para 10
         $e['status'] = 2; // altera o status para 2
         return $e;
    }, $jsonArray);

    // transforma em json novamente
    echo json_encode($jsonArray);

Check it out at Ideone

Another option is to use the array_walk:

    array_walk($jsonArray, function(&$e, $k){
         $e['vendas'] = 10; // altera a venda para 10
         $e['status'] = 2; // altera o status para 2
    });

If you are going to change the values manually:

    $jsonArray = json_decode($string, true); // transforma em array
    $jsonArray[3]['vendas'] = 20; // altera determinado valor
    echo json_encode($jsonArray); // transforma em json