php查询字段中的内容

Question

现在有表abc中有两个字段
一个字段是名称是id，另外一个字段是xz。xz这个字段是类型mediumtext

xz里面的内容如下：

{"erp_store_stock":[

{"title":"维生素D滴剂(H)","bus_no":"1143","ware_id":"207950","batch_no":"ACC22051288012","id_no":"8","stall_no":"1143","stock":"1","price":29.47,"price_original":29.47,"price_unit":"29.80"},

{"title":"[扶娃]葡萄糖酸钙锌口服溶液","bus_no":"1143","ware_id":"015938","batch_no":"ACC22051988019","id_no":"1","stall_no":"1143","stock":"2","price":58.93,"price_original":58.93,"price_unit":"29.80"}]

}

用php如何才能根据id=5和xz字段中ware_id=207950 和 batch_no=ACC22051288012
出对应的price=29.47的结果并输出

Answer 1

id是唯一值吧，先用查询出结果，然后把xz这个字段的内容线转成josn格式，然后josn转成数组array，然后循环数组判断ware_id=207950 和 batch_no=ACC22051288012就输出结果即可了