dongyi6543 2016-02-26 18:50
浏览 282
已采纳

从json字符串中提取数据元素

I am using the following script to my php script on my server;

$.ajax({
            type: 'POST',
            url: 'http://xx.php',
            data: { anyNumber: val1 },
            success: function(data) {
                alert(data);
            }
});

the php script correct queries sqlsrv database and returns row of data that I encode with echo json_encode($rows); I then correctly receive the json string into data (as above example) When I display the data with alert(data); as above, I get the following:

"({\"id\":1,\"Username\":null,\"Category\":null,\"VIN\":null,\"Make\":null,\"Model\":null,\"Colour\":null,\"Registration\":\"12345     \",\"RegisterNumber\":null,\"EngineNo\":null,\"Branding\":null,\"Remarks\":null,\"Photo1\":null})"

I have tried various methods but cannot assign the various elements to variables. Please help

  • 写回答

1条回答 默认 最新

  • dqd54099 2016-02-26 18:55
    关注

    just set the dataType of your $.ajax call to json:

    $.ajax({
            type: 'POST',
            url: 'http://xx.php',
            dataType: 'json',
            data: { anyNumber: val1 },
            success: function(data) {
                alert(data);
            }
    });
    

    explanation: when delivering data with GET or POST a lot of characters are getting masked. I think your $.ajax call just doesn't expect JSON as an answer but text or html. that's why it's not reading the JSON string correctly and keeping the masking of the characters.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 NeRF的代码复现以及人工智能入门
  • ¥15 centos如何做一个可以让ikuai连接的openvpn
  • ¥15 Protege 中的Entities下面的界面删除了如何复原
  • ¥15 scrapy爬虫求帮
  • ¥15 imageEnView绘图问题
  • ¥15 关于#python#的问题:您好可以加您一下联系方式吗,在复现的时候确实有点问题难以解决
  • ¥15 联想电脑重装系统时无法发现硬盘
  • ¥15 MATLAB与UR10e实体机械臂建立通讯
  • ¥15 c++题需要快一点不用opencv
  • ¥15 关于#java#的问题:想要咨询Flowable流程引擎框架的问题