我这里有一个用户填写的小表单,但是表单将所有数据保存在数据库的单个单元格中。那么,如果每个字段都是这样的话,我该如何提取数据呢?
下面是一个单元格数据示例(它包含完整表单的所有数据):-
{
"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、 我不能使它不存储在单一单元格中的所有数据,因为我不能编辑原始代码。我必须从单元格中分离每个文本字段的数据。但是怎么做呢?
暂无答案!
目前还没有任何答案,快来回答吧!