JSON Array Created in PHP/MySQL incorrectly decoded using JQuery
Posted
by
Zak
on Stack Overflow
See other posts from Stack Overflow
or by Zak
Published on 2012-07-06T20:08:20Z
Indexed on
2012/07/06
21:16 UTC
Read the original article
Hit count: 198
I am attempting to make an AJAX call to a very small PHP script that should return me an array that could be echo'd and decoded using JQuery. Here is what I have:
My PHP page called to by AJAX:
$web_q=mysql_query("select * from sec_u_g where uid='$id' ");
$rs = array();
while($rs[] = mysql_fetch_assoc($web_q)) {
}
print_r(json_encode($rs));
This outputs:
[{"id":"3","uid":"39","gid":"16"},{"id":"4","uid":"39","gid":"4"},{"id":"5","uid":"39","gid":"5"},{"id":"6","uid":"39","gid":"6"},{"id":"7","uid":"39","gid":"7"},{"id":"8","uid":"39","gid":"8"},{"id":"9","uid":"39","gid":"9"},false]
I don't understand the "false" at the end for one .. But then I send to to JQuery and use:
$.each(json.result, function(i, object) {
$.each(object, function(property, value) {
alert(property + "=" + value);
});
});
This just fails. I try to alert "result" by itself which is set by:
$.post("get_ug.php",{id:txt},function(result){
});
My output alerts are as follows:
1) The key is '0' and the value is '['
2) The key is '1' and the value is 'f'
3) The key is '2' and the value is 'a'
4) The key is '3' and the value is 'l'
5) The key is '4' and the value is 's'
6) The key is '5' and the value is 'e'
7) The key is '6' and the value is ']'
8) The key is '7' and the value is '
' (<-- Yes the line break is there in the alert)
I am exhausted from trying different ideas and scripts. Other than setting a delimiter myself and concatenating my own array and decoding it with a custom script, does anyone have any ideas?? Thank you!!
© Stack Overflow or respective owner