php multidimensional array into jQuery

Question

I have a php multidimensional array populated from a table using the following code:

<?php starts

$array = array();
$i = 0;

while($row = mysql_fetch_array($result))
{

$array[$i] = array("handle" => $row['handle'],"firstname" => $row['first_name'],"lastname" => $row['last_name']);
$i++;
}

echo json_encode(json_encode($array));

?> php ends

this is called by .post from jQuery and when I alert() the data returned I get the following output:

[
{"handle":"admin","firstname":"admin","lastname":"admin"},
{"handle":"ms","firstname":"ms","lastname":"ms"},
{"handle":"op","firstname":"op","lastname":"op"},
{"handle":"ui","firstname":"ui","lastname":"ui"}
]

the Jquery code I use to extract the php array is:

$.post("test1.php","",
            function(data){

                var obj = $.parseJSON(data);
                alert(obj);
                var obj2 = $.parseJSON(obj);
                alert(obj2);
                alert(obj2[1]);
                var result = eval(data);
                alert(result[0][0]);


    },"html");

alert(obj) gives me the output specified. alert(obj2) gives me:

[object Object],[object Object],[object Object],[object Object]

alert(obj2[1]) gives me:

[object Object]

How do I get at the data in this???

http://stackoverflow.com/questions/4933217/print-json-parsed-object — run, Sep 12 '11 at 06:30

score 7 · Accepted Answer · answered Sep 12 '11 at 06:16

7

Your first

var obj = $.parseJSON(data);

Should be all you need. You can then access your objects like:

obj[0]['handle']
// or
obj[0].handle

answered Sep 12 '11 at 06:16

Seventoes

4,810
3
19
19

score 4 · Answer 2 · answered Sep 12 '11 at 06:14

4

'[object Object]' is the toString() of an Object, which is implicitly called when using alert() (which alerts strings only).

You need to use dot notation to access it, or console.log() to view the object (provided your browser has a competent console).

answered Sep 12 '11 at 06:14

alex

479,566
201
878
984

score 1 · Answer 3 · answered Sep 12 '11 at 06:21

To view any object details in IE9 use - console.dir(obj)

Where as in Firefox, you can use - console.log(obj)

Remember, the details will be written in the console (present in Developer Tools in IE and Firebug in Firefox)

Using console statments you can view your object structure and then you can access any property of object using '.' dot operator.

Hope this helps.

php multidimensional array into jQuery

3 Answers3

Linked