JSON array not printing keys

Question

Grabbing an JSON array from a query. It's not printing the keyss with in the data.

What I expect:

["0":"3675E5010E2738","1":"4114009","2":"2012-11-05","3":"Active","4":"2012-12-11"]

What I get...

["3675E5010E2738","4114009","2012-11-05","Active","2012-12-11"]

JSON is produced from PHP/JSON encode:

$array = $model->ListData();
echo json_encode($array);

I've tried loading both loadRowList(); and loadAssocList(); and neither produce the keys.

What you expect is not JSON, also what does var_dump($array); give you? — Musa
– Musa, Commented Dec 18, 2012 at 21:03
Weird as most examples I've seen as JSON have the keys associated with the data. Oh well. Guess I'll just have to use numbers. — Plummer
– Plummer, Commented Dec 18, 2012 at 21:06

Dancrumb · Accepted Answer · 2012-12-18 21:06:05Z

2

Because that's not how JSON represents arrays

["0":"3675E5010E2738","1":"4114009","2":"2012-11-05","3":"Active","4":"2012-12-11"] is not valid JSON.

{"0":"3675E5010E2738","1":"4114009","2":"2012-11-05","3":"Active","4":"2012-12-11"} is, but that's the representation of an object, not an array.

If $model->ListData(); returns an array, as your code suggests that it does, then the representation that you're getting is correct.

Anyway, since json[0] would work the same way, regardless of whether it was an array or an object with numerical keys, what does it matter?

answered Dec 18, 2012 at 21:06

Dancrumb

27.7k10 gold badges79 silver badges139 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Plummer Over a year ago

First time using JSON. Did not know that. Used numerical keys in PHP, got confusing after a while. I was hoping to use assoc arrays with JSON.

Plummer Over a year ago

so, getting the data from JSON/AJAX would go like:

$.ajax({         url: url,         datatype: JSON,         success: function(data){             $('#test').html(data.0);         } });

DiverseAndRemote.com · Accepted Answer · 2012-12-18 21:05:33Z

1

You have numerical keys which are in order starting from 0. You don't need to have the keys present for it to be interpreted correctly.

answered Dec 18, 2012 at 21:05

DiverseAndRemote.com

20k10 gold badges65 silver badges75 bronze badges

Comments

tugla · Accepted Answer · 2012-12-18 21:25:31Z

0

Remember that JSON is javascript object notation, this means that it uses javascript syntax.

var myObject = { 0: 'zero', 1: 'one', 2: 'two' }; var myArray = [ 'zero', 'one', 'two' ];

Arrays and Objects are used for different purposes. Objects supports keys, arrays do not.

answered Dec 18, 2012 at 21:25

tugla

11 bronze badge

Collectives™ on Stack Overflow

JSON array not printing keys

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related