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

Filed under:
|
|
|

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

Related posts about php

Related posts about jQuery