PHP MySQL JSON custom output

Question

i retrieve and print data from MySQL database in json method:

$ret = array();

$fileName = Access::FetchDB("SELECT name FROM tags");
    $ret[]= $fileName;
echo json_encode($ret);

Now output is:

[[{"name":"test1"},{"name":"test2"},{"name":"test3"}]]

But i need to This output:

["test1","test2","test3"]

How do i print this?

Just loop over $fileName and put the values into $ret.

gen_Eric
– gen_Eric

2014-01-24 19:19:42 +00:00
Commented Jan 24, 2014 at 19:19 — gen_Eric
– gen_Eric, Commented Jan 24, 2014 at 19:19

Justin Iurman · Accepted Answer · 2014-01-24 19:44:12Z

5

[[{"name":"test1"},{"name":"test2"},{"name":"test3"}]]

is like having this

array(array(array('name' => 'test1'), array('name' => 'test2'), array('name' => 'test3')));

First, do not do this:

$ret[]= $fileName;

And keep only $fileName which should be something like this:

array(array('name' => 'test1'), array('name' => 'test2'), array('name' => 'test3'));

The better would even be to have array('test1', 'test2', 'test3') and encode it without array_values(). You could do it in php side:

$ret = array();
$fileName = Access::FetchDB("SELECT name FROM tags");

foreach($fileName as $key => $value)
   $ret[] = $value['name'];

echo json_encode($ret);

edited Jan 24, 2014 at 19:44

answered Jan 24, 2014 at 19:21

Justin Iurman

19k3 gold badges39 silver badges58 bronze badges

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

1 Comment

Pink Code Over a year ago

i tested but not worked for me! i see [[{"name":"test1"},{"name":"test2"},{"name":"test3"}]] output.

bvarga · Accepted Answer · 2014-01-24 19:22:51Z

1

Try this solution:

$ret = array();

$fileNames = Access::FetchDB("SELECT name FROM tags");
$ret = array_values($fileNames);
echo json_encode($ret);

answered Jan 24, 2014 at 19:22

bvarga

7237 silver badges12 bronze badges

2 Comments

Justin Iurman Over a year ago

Unfortunately, this won't work. I answered something similar at first, see my answer to understand why

bvarga Over a year ago

I didn't notice the array in array, only the key value pairs. Sorry my fault.

Collectives™ on Stack Overflow

PHP MySQL JSON custom output

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related