dourao1896 2016-01-16 16: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 16: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);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
  • ¥15 win10,这种情况怎么办
  • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
  • ¥100 在连接内网VPN时,如何同时保持互联网连接
  • ¥15 MATLAB中使用parfor,矩阵Removal的有效索引在parfor循环中受限制
  • ¥20 Win 10 LTSC 1809版本如何无损提升到20H1版本
  • ¥50 win10 LTSC 虚拟键盘不弹出
  • ¥30 微信小程序请求失败,网页能正常带锁访问
  • ¥50 CrossLink-LIF-MD6000 型 FPGA 的 CMOS 转 MIPI D-PHY IP 核功能使用异常
  • ¥15 proteus控制16x16LED点阵显示屏的设计