Correct Formatting for Json from PHP

Question

I am trying to get my JSON output like this.

{"allterms":[{"group":{"Name":"Test 1"},{"group":{"Name":"Test2","Id":"298"}}]

My current code is

while($r = mysql_fetch_assoc($rs)) {
$rows['allterms']['group'][] = $r;   
}

Which gives me this

{"allterms":{"group":[{"Name":"Test1", "Id":"1740"},{"Name":"Test2","Id":"631"}}]

How can I adjust my code so that each item has a parent term group.

Try $rows['allterms'][]['group'], should give you an array of objects — kero
– kero, Commented May 18, 2014 at 16:40
Many thanks Kingkero, since it wasn't formed as answer I couldn't accept it as the right one so I accepted AD7six's below. But thanks! — Creative Links
– Creative Links, Commented May 18, 2014 at 22:11

AD7six · Accepted Answer · 2014-05-18 16:45:29Z

1

Change the loop like so:

while($r = mysql_fetch_assoc($rs)) {
    $rows['allterms'][]['group'] = $r;   
}

which will generate:

array(
    'allterms' => array(
        0 => array(
            'group' => array(...),
        ),
        1 => array(
            'group' => array(...),
        )
        ...
    )

which as json will be:

{
  "allterms": [
    {
      "group": {
        {
          "Name": "Test1",
          "Id": "1740"
        },
    {
      "group": {
        {
          "Name": "Test2",
          "Id": "631"
        }
     }
   ]
}

answered May 18, 2014 at 16:45

AD7six

67.3k14 gold badges123 silver badges169 bronze badges

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

Comments

kero · Accepted Answer · 2014-05-18 19:15:45Z

0

You could use the array_push() function from PHP.

while($r = mysql_fetch_assoc($rs)) {
    array_push($rows['allterms'], $r);   
}

edited May 18, 2014 at 19:15

kero

10.7k5 gold badges44 silver badges52 bronze badges

answered May 18, 2014 at 16:58

Ernesto Hegi

3333 silver badges4 bronze badges

Collectives™ on Stack Overflow

Correct Formatting for Json from PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related