从数据库中的单个单元格中提取多个文本字段数据?

5fjcxozz  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(218)

我这里有一个用户填写的小表单,但是表单将所有数据保存在数据库的单个单元格中。那么,如果每个字段都是这样的话,我该如何提取数据呢?
下面是一个单元格数据示例(它包含完整表单的所有数据):-

{
    "18":{"name":"W\u00e4hle dein Wunschpaket","value":"BASIC \"Bis zu 10\u20ac\"","value_raw":"BASIC \"Bis zu 10\u20ac\"","id":18,"type":"select"},
    "11":{"name":"Geschlecht","value":"Weiblich","value_raw":"Weiblich","id":11,"type":"select"},
    "15":{"name":"Hauttyp","value":"Hell","value_raw":"Hell","id":15,"type":"select"},
    "14":{"name":"Kleidergr\u00f6\u00dfe","value":"XS","value_raw":"XS","id":14,"type":"select"},
    "20":{"name":"Geburtsdatum","value":"24.05.1991","id":20,"type":"text"},
    "16":{"name":"Schuhgr\u00f6\u00dfe","value":"35","value_raw":"35","id":16,"type":"select"},
    "13":{"name":"Interessen","value":"","value_raw":"","id":13,"type":"checkbox"},
    "17":{"name":"Lieblingsfarbe","value":"","id":17,"type":"text"},
    "21":{"name":"Wunsch-Tauschpartner","value":"","value_raw":"","id":21,"type":"checkbox"},
    "8":{"name":"\u00dcber dich & Besondere Anmerkungen","value":"","id":8,"type":"textarea"},
    "0":{"name":"Name","value":"laksh khamesra","id":0,"type":"name","first":"laksh","middle":"","last":"khamesra"},
    "1":{"name":"E-Mail-Adresse","value":"abc@xyz.com","id":1,"type":"email"},
    "4":{"name":"Stra\u00dfe & Hausnummer","value":"1","id":4,"type":"text"},
    "19":{"name":"Telefonnummer","value":"","id":19,"type":"text"},
    "6":{"name":"PLZ","value":"313001","id":6,"type":"text"},
    "7":{"name":"Stadt","value":"udaipur","id":7,"type":"text"},
    "10":{"name":"Land","value":"India","id":10,"type":"text"},
    "22":{"name":"Wie hast du von uns erfahren?","value":"Instagram","value_raw":"Instagram","id":22,"type":"select"}
}

p、 我不能使它不存储在单一单元格中的所有数据,因为我不能编辑原始代码。我必须从单元格中分离每个文本字段的数据。但是怎么做呢?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题