JSON format : which array structure is better or correct?

Question

I want to ask about the JSON format. The results of Sql is

Year SumOfYear
2011 0.30
2012 0.19

update

this is the part of php code.

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

  $results[] = array(
     '"Year"' => $row['Year'],
     '"SumOfYear"' => $row['SumOfYear'],
     );

 }

echo json_encode($results);

The results is

[

{
Year: "2011",
SumOfYear: "0.30"
},

{
Year: "2012",
SumOfYear: "0.19"
}

]

if i want to have like below, is it still good format?

{
 2011,
 2012
},
{
 0.30,
 0.19
}

Community · Accepted Answer · 2023-11-17 19:32:19Z

2

if the JSON code is the original, you have to put Year and SumOfYear between code signs:

[
   {
      "Year":"2011",
      "SumOfYear":"0.30"
   },
   {
      "Year":"2012",
      "SumOfYear":"0.19"
   }
]

If you want to verify your JSON, you can use this tool.

As you seem to use php, i recommend to structure your data in an array and let php encode it into json:

echo json_encode(my_data_array);

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Mar 16, 2014 at 20:09

lootsch

1,86513 silver badges21 bronze badges

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

3 Comments

Karl Over a year ago

thanks! that link is useful! what about second structure? is it wrong?

lootsch Over a year ago

the second has the same syntax error: "Year" and "SumOfYear", and the syntax error, as you miss a comma between the object. But has an additional error: You can't have two objects with the same Key on the same layer. So there can only be one object with key year and the same for the key SumOfYear on the other layer. This will cause either an parsing error, or a loss of information.

Karl Over a year ago

Thanks. I updated it. can you tell second structure is good or bad? @lootsch

Collectives™ on Stack Overflow

JSON format : which array structure is better or correct?

update

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

update

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest