get sql result as nested json object

Question

Using sql query with group_concat through a while loop, I achieved the result below:

$rows[] = array('name' =>$row['customer'] , 'atw' =>$row['atw_number'] ,
     'dr' =>array(array('drnumber'=>(($row['dr_number'])),)),);

{ "name": "MULTIBUILD CORP", "atw": "7146", "dr": [ { "drnumber": "1608,1610,1611" } ] },

instead, can i have something like:

{ "name": "MULTIBUILD CORP", "atw": "7146", "dr": [ { "drnumber": "1608" }, { "drnumber": "1610" }, { "drnumber": "1611" } ] },

You will have to create a php script like that. I mean you will have to do it manually using some loops. That wil do it — pritesh
– pritesh, Commented Feb 17, 2016 at 21:01
yeah thanks for the info pritesh.. You will have to create a php script like that. I mean you will have to do it manually using some loops. That wil do it – pritesh — Ponder Q
– Ponder Q, Commented Feb 17, 2016 at 21:13

Dave Chen · Accepted Answer · 2016-02-17 21:04:56Z

1

Within your while loop replace your current $rows[] = ... with:

$numbers = [];
foreach (explode(',', $row['dr_number']) as $number)
    $numbers[] = ['dr_number' => $number];

$rows[] = array(
    'name' => $row['customer'],
    'atw' => $row['atw_number'],
    'dr' => $numbers
);

answered Feb 17, 2016 at 21:04

Dave Chen

11k8 gold badges42 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

get sql result as nested json object

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related