Convert mysql query to json encode

Question

i've problem convert query to json encode

This is the code:

$list = $this->M_Bio->dataBio();
$data = array();
foreach ($list as $result) {
$row = array();
$row[] = ['name' => $result->fullname];
$row[] = ['position' => $result->position];
$row[] = ['office' => $result->office];
$row[] = ['extn' => $result->phone];
$data[] = $row;
}
$output = array(
"data" => $data,
);
echo json_encode($output);

Result json encode:

{"data": [
["name": "Tiger Nixon","position": "System Architect","office": "Edinburgh","extn": "5421"],["name": "Cedric Kelly","position": "Senior Javascript Developer", "office": "Edinburgh","extn": "6224"]
    ]
}

I want the results like this:

    {
    "data": [
    {
    "name": "Tiger Nixon",
    "position": "System Architect",
    "office": "Edinburgh",
    "extn": "5421"
    },
    {
    "name": "Cedric Kelly",
    "position": "Senior Javascript Developer",
    "office": "Edinburgh",
    "extn": "6224"
    }
    ]
    }

What should i do? please help me

You have shown invalid json Result json encode: . JSON can not have key:value pairs in []; — Ketan Yekale
– Ketan Yekale, Commented Sep 1, 2018 at 18:42

Nigel Ren · Accepted Answer · 2018-09-01 18:20:53Z

2

You need to change the way you add all of the data into the $output array...

$row = array();
$row['name'] = $result->fullname;
$row['position'] = $result->position;
$row['office'] = $result->office;
$row['extn'] =$result->phone;
$data[] = $row;

This will give you a cleaner result in the output array.

You could build them all in one go...

$data[] = array('name' => $result->fullname,
     'position' => $result->position,
...

which would be cleaner.

answered Sep 1, 2018 at 18:20

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Convert mysql query to json encode

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related