How to understand/consume json output from PHP script

Question

Using PHP PDO I run this query

SELECT Name, Latitude, Longitude, Begin, End FROM VenueData

And fetch the data

$data = $sth->fetchAll();

Then output

header("Content-type: application/json");
print(json_encode(array('venues'=>$data)));

However the output is strange,

{"venues":[{"Name":"Flintstone1","0":"Flintstone1","Latitude":"57","1":"57","Longitude":"-124","2":"-124","Begin":"8","3":"8","End":"14","4":"14"}]}

It seems for every column in the select query there are 2 keys, one by name and one by index 0-n) in the json. I have not encountered this before, why is this happening?

score 7 · Accepted Answer · 2015-01-03 18:32:38Z

7

This is probably because of the fetch you are using.

Check: PHP Manual PDOStatement::fetchAll

By default this will use PDO::FETCH_BOTH which includes numerative and associate array of results.

(The fetch style options can be found here: PHP Manual PDOStatement::fetch)

Depending on what you want, you can either use:

$data = $sth->fetchAll(PDO::FETCH_ASSOC);

Or:

$data = $sth->fetchAll(PDO::FETCH_NUM);

edited Jan 3, 2015 at 18:32

answered Jan 3, 2015 at 18:27

user1237595

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

Comments

jeremyb · Accepted Answer · 2015-01-03 18:31:33Z

0

Change this:

$data = $sth->fetchAll();

By this

$data = $sth->fetchAll(PDO::FETCH_ASSOC);

answered Jan 3, 2015 at 18:31

jeremyb

4924 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to understand/consume json output from PHP script

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