JSON data not in proper format : fetching from mysql

Question

<?php
    require 'dbinfo.php'; 
    try {
        $db = new PDO($dsn, $username, $password);
        $db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );  
        $sth = $db->query("SELECT * FROM user_tracks");
        $loc = $sth->fetchAll();    
        $locations = array_values($loc);
        echo json_encode( array("user"=>( $locations )));
    } catch (Exception $e) {
      echo $e->getMessage();
    }
?>

The code should return:

{"user":[{"id":"1","Latitude":"12.9555033333","Longitude":"80.2461883333","Time":"06:32:57","Date":"2012-03-13","Speed":"0","Course":"183.92"},{...},{....}]}

when it is returning:

{"user":[{"id":"1","0":"1","Latitude":"12.9555033333","1":"12.9555033333","Longitude":"80.2461883333","2":"80.2461883333","Time":"06:32:57","3":"06:32:57","Date":"2012-03-13","4":"2012-03-13","Speed":"0","5":"0","Course":"183.92","6":"183.92"},{...},{....}]}

I'm unsure of what happening... Where is the problem here?

Thanks in advance!

ZzzZZz · Accepted Answer · 2012-04-05 23:53:43Z

8

fetchAll() returns both (note the 'fetch_style' argument comments/notes) string and numerically keyed data from the query results by default. If you want the string version only, you have to do

$loc = $sth->fetchAll( PDO::FETCH_CLASS );

edited Apr 5, 2012 at 23:53

ZzzZZz

4372 silver badges14 bronze badges

answered Apr 3, 2012 at 3:26

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

ZzzZZz Over a year ago

It works! Its the other way.. fetchAll(PDO::FETCH_CLASS); Thanks for the help!

Collectives™ on Stack Overflow

JSON data not in proper format : fetching from mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related