php+mysql数据更改问题。

Question

数据库是mysql数据库 类型是 mediumtext 字段名称是erpaa 表的名称是 erpbiao

现在的数据是

{"delivery_time":"","article_id":0,"inviter_id":"","is_prescription":false,"medication_id":0,"disease_name":"","chain_shop_settings":{"status":"1","coupon_type":"1","withdraw_type":[1,2,3],"settlement_fee_type":"1","settlement_fee_custom":"0.6","entry_type":"1"},"chain_shop_info":{"id":36,"shop_id":1,"name":"陈店","lng":"107.20278100","lat":"34.36376500","status":1,"logo":"image/1/2022/08/40f9dee03fe0970a9d67b16885dcda27.jpg","shop_number":"1028","contact_settings":{"telephone":"15564","province":"省","province_code":"600","city":"市","city_code":"610300","area":"区","area_code":"610303","detail":"店隔路店","lng":"107.281","lat":"34.3765"},"business_settings":{"time_type":"1","time_type_custom":{"start":"07:30","end":"22:00"},"proof":["image/1/2022/06/7d3cd0b77a8c85810ca90010e8d7e8ba.jpg","image/1/2022/06/981b4813d7c6cb21b2d22e1eedd29c72.jpg","image/1/2022/06/95b627973c26532f79abe50ff3bf57d8.jpg","image/1/2022/06/753c3efe4cbcb842d9b1ff6b6dcff1cb.jpg","image/1/2022/05/ff6c1c7a37e4661f1e01f518276dd4c7.jpg"],"proof_show":"1","remark":""}}}

现在想通过更改后想变成

{

"erp_store_stock":[

{"title":"[伊可新]维生素AD滴剂/伊可新(红)1岁以上","bus_no":"1069","ware_id":"003080","batch_no":"ACC22082688040","id_no":"1","stall_no":"1069","stock":2,"price":91.95,"price_original":91.95,"price_unit":"32.00"},

{"title":"[伊可新]维生素AD滴剂/伊可新(红)1岁以上","bus_no":"1069","ware_id":"003080","batch_no":"ACC22101288056","id_no":"21","stall_no":"1069","stock":1,"price":91.95,"price_original":91.95,"price_unit":"32.00"},

{"title":"[三精]复方葡萄糖酸钙口服溶液","bus_no":"1069","ware_id":"207315","batch_no":"ACC22100688003","id_no":"2","stall_no":"1069","stock":"1","price":21.55,"price_original":21.55,"price_unit":"22.50"}

],

"delivery_time":"","article_id":0,"inviter_id":"","is_prescription":false,"medication_id":0,"disease_name":"","chain_shop_settings":{"status":"1","coupon_type":"1","withdraw_type":[1,2,3],"settlement_fee_type":"1","settlement_fee_custom":"0.6","entry_type":"1"},"chain_shop_info":{"id":36,"shop_id":1,"name":"陈店","lng":"107.20278100","lat":"34.36376500","status":1,"logo":"image/1/2022/08/40f9dee03fe0970a9d67b16885dcda27.jpg","shop_number":"1028","contact_settings":{"telephone":"15564","province":"省","province_code":"600","city":"市","city_code":"610300","area":"区","area_code":"610303","detail":"店隔路店","lng":"107.281","lat":"34.3765"},"business_settings":{"time_type":"1","time_type_custom":{"start":"07:30","end":"22:00"},"proof":["image/1/2022/06/7d3cd0b77a8c85810ca90010e8d7e8ba.jpg","image/1/2022/06/981b4813d7c6cb21b2d22e1eedd29c72.jpg","image/1/2022/06/95b627973c26532f79abe50ff3bf57d8.jpg","image/1/2022/06/753c3efe4cbcb842d9b1ff6b6dcff1cb.jpg","image/1/2022/05/ff6c1c7a37e4661f1e01f518276dd4c7.jpg"],"proof_show":"1","remark":""}}}

Answer 1

先用json_decode得到对象，然后再动态加上erp_store_stock数据，在json_encode生成下面的内容格式。
而且erp_store_stock和erpaa中哪个数据进行关联的？需要通过erpaa中关联的数据读取数据库得到erp_store_stock的内容。
示例代码如下

<?php
function getRS($conn,$sql,$field=""){
  $q=mysqli_query($conn,$sql);
  if($field==""){
     return mysqli_fetch_all($q,MYSQLI_ASSOC);
  }
  else{  
    $rs=mysqli_fetch_assoc($q);
    return $rs[$field];
  }
  return $rs;
}

$conn=mysqli_connect("localhost","root","123456","test");
$erpaa=getRS($conn,"select erpaa from erpbiao where id=3","erpaa");

$obj=json_decode($erpaa);
$id= $obj->chain_shop_info->id;//如果是其他节点下的id值注意改这里
$rs=getRS($conn,"select * from erpbb where id=$id");//读取erbb中id值一样的记录

$obj->erp_store_stock=$rs;//增加erp_store_stock属性存储erbb中对应的集合


mysqli_close($conn);


$s=json_encode($obj);//得到json字符串

echo $s;
?>