MySQL data to JSON via PHP

Question

Basically idea is to grab data from MySQL table and transform it to JSON.

This is how database table looks:

enter image description here

And this how should output be:

[
   {"group1":[
               {"val":"somevalue"},
               {"val":"somevalue"}
             ]
   },
   {"group2":[
               {"val":"somevalue"},
               {"val":"somevalue"}
             ]
   },
   {"group3":[
               {"val":"somevalue"}
             ]
   }
]

My PHP script looks like this, for now:

$arr = [];
$result = mysql_query("SELECT * FROM thetable WHERE section='sect1'");
while($row = mysql_fetch_array($result))
{
  // ???
}

echo json_encode($arr);

My main issue is how to output/sort data in "groups".

Thanks for your help!

Check out this SO post: stackoverflow.com/questions/383631/json-encode-mysql-results — Bjoern
– Bjoern, Commented Nov 23, 2011 at 7:19

k102 · Accepted Answer · 2011-11-23 07:14:27Z

3

try this

while($row = mysql_fetch_array($result))
{
   $arr[$row['group']][] = array('val' => $row['value']);
}

answered Nov 23, 2011 at 7:14

k102

8,1099 gold badges52 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

MySQL data to JSON via PHP

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related