dourao1896 2016-01-16 08:18
浏览 211
已采纳

将JavaScript数组存储在数据库中,并在需要时返回数组

I have a multidimensional associative JavaScript array with some metabox data and I need to store that array in the WordPress database (in a single column).

And I also want to get that stored array back in the metabox call back function and use the values in the array to populate the relevant fields.

This is what I've done so far...

    var data = [
        { key: 'cardK', val: 13 },
        { key: 'cardQ', val: 12 },
        { key: 'cardAJ', val: 11 },
    ];
    var serializedData= JSON.stringify( data );

This outputs a string look like this

[[1,2],[3,4],[5,6]]

Now I can store this in the DB in a single column. But how can I get this back as an array and use it to populate the fields ?

  • 写回答

1条回答 默认 最新

  • dongshan7060 2016-01-16 08:23
    关注

    Save the string as JSON, like this:

    var data = [[1,2],[3,4],[5,6]];
    var serializedData = JSON.stringify(data);
    

    Before you convert make sure you replace any data which has changed in the json to make it valid json before using json_decode().

    use this function:

    str_replace();
    

    To convert it into array on PHP side:

    json_decode(data, true); // returns array
    json_decode(data); // returns an object, not an array.
    

    When you get the JSON string back from MySQL, you can turn it back into an array with JSON.parse(), like this:

    var returnedArr = JSON.parse(returnedData);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
编辑
预览

报告相同问题?

悬赏问题

  • ¥35 西门子博图v16安装密钥提示CryptAcquireContext MS_DEF_PROV Error of containger opening
  • ¥15 mes系统扫码追溯功能
  • ¥40 selenium访问信用中国
  • ¥20 在搭建fabric网络过程中遇到“无法使用新的生命周期”的报错
  • ¥15 Python中关于代码运行报错的问题
  • ¥500 python 的API,有酬谢
  • ¥15 软件冲突问题,软件残留问题
  • ¥30 有没有人会写hLDA,有偿求写,我有一个文档,想通过hLDA得出这个文档的层次主题,有偿有偿!
  • ¥50 有没有人会写hLDA,有偿求写,我有一个文档,想通过hLDA得出这个文档的层次主题,有偿有偿!
  • ¥15 alpha101因子里哪些适合crypto?