mysql - 解析后的数据无法保存到mysql

Question

json数据是

"{\"n925D\":1,\"t925D\":23.5,\"h925D\":3276.8,...

我将符号替换为

var results = post
    .replace(/\{/g, '[[')
    .replace(/\"/g, '\'')
    .replace(/\,/g, '\'],[')
    .replace(/\:/g, ',\'')
    .replace(/\}/g, '\']]')
    .replace(/\\([^u])/g, '$1')
;

console.log(结果);显示

[['n925D','1'],['t925D','23.5'],['h925D','3276.8'],...

console.log(query.sql);显示

INSERT INTO table (did,val) SET '[[\'n925D\',\'1\'],[\'t925D\',\'23.5\'],[\'h925D\',\'3276.8\'],

实际上我怎样才能删除\...

Answer 1

您无法使用正则表达式可靠地解析 JSON(或 XML 或 HTML)。相反，parse it, change the data, and re-emit it .

var jsonData = '{\"n925D\":1,\"t925D\":23.5,\"h925D\":3276.8,...';

// Parse it into a hash
var jsonParsed = JSON.parse(jsonData); 

// Change the hash in jsonParsed to an array of arrays.

// Convert it back into JSON
jsonData = JSON.stringify(jsonObj);