PHP 向JSON格式的数据内添加一条新记录，求解

Question

数据库字段中有个JSON格式的数据，存储的内容如下：
[{"ratemsg":"申请提交","recordtime":"1621214777","postuid":"7"}]

如何把一条新的记录加入进去，使其变成
[{"ratemsg":"申请提交","recordtime":"1621214777","postuid":"7"},{"ratemsg":"申请提交2","recordtime":"1621214778","postuid":"5"}]

Answer 1

先查出来，然后通过php数组的向里面插入，再转json更新

<?php
$data = '[{"ratemsg":"申请提交","recordtime":"1621214777","postuid":"7"}]';
$data = json_decode($data,true);
print_r($data);
$insert = [
    'ratemsg'=>'申请提交2',
    'recordtime'=>'1621214778',
    'postuid'=>'5'
];
array_push($data,$insert);
print_r($data);
?>