How to parse following json in jquery ajax success function

Sagar Yadav

The following JSON data retrieved from php script and now i want to parse this JSON data. Please someone help me to parse this JSON data.

[{
    "0": "1.0000",
    "AVG(Q1)": "1.0000",
    "1": "1.8000",
    "AVG(Q2)": "1.8000",
    "2": "2.0000",
    "AVG(Q3)": "2.0000",
    "3": "2.4000",
    "AVG(Q4)": "2.4000",
    "4": "1.6000",
    "AVG(Q5)": "1.6000",
    "5": "1.2000",
    "AVG(Q6)": "1.2000",
    "6": "2.0000",
    "AVG(Q7)": "2.0000",
    "7": "2.4000",
    "AVG(Q8)": "2.4000",
    "8": "0.8000",
    "AVG(Q9)": "0.8000",
    "9": "2.8000",
    "AVG(Q10)": "2.8000",
    "10": "1.8000",
    "AVG(Q11)": "1.8000"
}, {
    "0": null,
    "AVG(Q1)": null,
    "1": null,
    "AVG(Q2)": null,
    "2": null,
    "AVG(Q3)": null,
    "3": null,
    "AVG(Q4)": null,
    "4": null,
    "AVG(Q5)": null,
    "5": null,
    "AVG(Q6)": null,
    "6": null,
    "AVG(Q7)": null,
    "7": null,
    "AVG(Q8)": null,
    "8": null,
    "AVG(Q9)": null,
    "9": null,
    "AVG(Q10)": null,
    "10": null,
    "AVG(Q11)": null
}]

I tried different ways to parse this JSON but all methods failed. Please help me to parse this JSON.

I tried this but no value is displayed in the table element:

var obj = jQuery.parseJSON(data);
$.each(obj, function(key, value){          
    $('table').append('<tr><td>'+value.avg(q1)+'</td></tr>');
});
Parth Trivedi

Please check snippet. No need to parse json.

var jsobObj = [{
    "0": "1.0000",
    "AVG(Q1)": "1.0000",
    "1": "1.8000",
    "AVG(Q2)": "1.8000",
    "2": "2.0000",
    "AVG(Q3)": "2.0000",
    "3": "2.4000",
    "AVG(Q4)": "2.4000",
    "4": "1.6000",
    "AVG(Q5)": "1.6000",
    "5": "1.2000",
    "AVG(Q6)": "1.2000",
    "6": "2.0000",
    "AVG(Q7)": "2.0000",
    "7": "2.4000",
    "AVG(Q8)": "2.4000",
    "8": "0.8000",
    "AVG(Q9)": "0.8000",
    "9": "2.8000",
    "AVG(Q10)": "2.8000",
    "10": "1.8000",
    "AVG(Q11)": "1.8000"
}, {
    "0": null,
    "AVG(Q1)": null,
    "1": null,
    "AVG(Q2)": null,
    "2": null,
    "AVG(Q3)": null,
    "3": null,
    "AVG(Q4)": null,
    "4": null,
    "AVG(Q5)": null,
    "5": null,
    "AVG(Q6)": null,
    "6": null,
    "AVG(Q7)": null,
    "7": null,
    "AVG(Q8)": null,
    "8": null,
    "AVG(Q9)": null,
    "9": null,
    "AVG(Q10)": null,
    "10": null,
    "AVG(Q11)": null
}];


$.each(jsobObj, function(key, value){          
    $('table').append('<tr><td>'+(value["AVG(Q1)"]==null?"":value["AVG(Q1)"])+'</td></tr>');
});
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<table>
  </table>

本文收集自互联网,转载请注明来源。

如有侵权,请联系[email protected] 删除。

编辑于
0

我来说两句

0条评论
登录后参与评论

相关文章

来自分类Dev

jQuery-Ajax:SyntaxError:JSON.parse:意外字符

来自分类Dev

Uncaught SyntaxError: Unexpected token < in JSON at position 0 at Function.parse [as parseJSON] (<anonymous>) at Object.success (script.js:14)

来自分类Dev

语法错误 JSON.parse ajax.responsetext (Spring,jquery,ajax,gson)

来自分类Dev

How to do a synchronous json ajax call with jquery

来自分类Dev

AJAX call to Spring MVC works, but doesn't hit success function

来自分类Dev

如何在AJAX中用.done()替换success:function()

来自分类Dev

如何在jQuery Ajax Success返回的数组中进行LOOP?

来自分类Dev

How to parse this JSON with GSON?

来自分类Dev

jQuery遍历Ajax JSON响应

来自分类Dev

使用jQuery ajax json响应?

来自分类Dev

handle json response in jquery ajax

来自分类Dev

Foreach Ajax Json-Jquery

来自分类Dev

jQuery $ .ajax json与getjson格式

来自分类Dev

jQuery Ajax无法检索json

来自分类Dev

AJAX使用Jquery遍历JSON

来自分类Dev

Ajax错误“ SyntaxError:JSON.parse:意外字符”

来自分类Dev

从ajax调用中获取JSON.parse中的数据

来自分类Dev

为什么在ajax成功之后使用JSON.Parse(data)?

来自分类Dev

Jquery - Multiple function calls to one AJAX call

来自分类Dev

在jquery ajax中处理json响应

来自分类Dev

jQuery Ajax JSON对象的值为NULL

来自分类Dev

JQuery Ajax Json响应不起作用

来自分类Dev

无法解析JQuery ajax调用返回的JSON

来自分类Dev

无法从jQuery ajax调用获取json数据

来自分类Dev

jQuery ajax之后的JSON格式错误

来自分类Dev

PHP未收到jQuery AJAX发送的JSON

来自分类Dev

jQuery AJAX json-未调用

来自分类Dev

jQuery AJAX访问REST API JSON数据

来自分类Dev

请求的JSON解析在jquery ajax中失败

Related 相关文章

热门标签

归档