How to while loop php object from database to Json?

Question

Trying to fetch the latlng from database and encode to Json but I got only 1 result.

 $geo= new stdClass();

 while( $rows = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) {
            $name=$rows['Name'];
            $lat=$rows['Latitude'];
          $lng=$rows['Longitude'];
            $intlat=(float)$lat;
            $intlng=(float)$lng;
            $latlng = $lat.",".$lng;
            $geo->lat=$intlat;
            $geo->lng=$intlng;

}


 $try1=json_encode(array("location"=>$geo));
 echo $try1;

Result {"location":{"lat":13.811,"lng":100.612}}

But what I want is {"location":{"lat":13.811,"lng":100.612},{"lat":v2,"lng":v2},{"lat":v3,"lng":v3},{"lat":v4,"lng":v4}}

In this loop you are overwriting your values... so at the end you have only 1 result — B001ᛦ
– B001ᛦ, Commented Apr 18, 2018 at 15:26
Note that your wanted JSON is invalid. I think you want something like: {"location":[{"lat":13.811,"lng":100.612},{"lat":13.811,"lng":100.612}]} — Syscall
– Syscall, Commented Apr 18, 2018 at 15:41

Don't Panic · Accepted Answer · 2018-04-18 15:39:13Z

2

If you want to add multiple locations, you should initialize an array to hold them, rather than a stdClass object. If you're concerned about the result ending up as an object rather than an array in the resulting JSON, it will be okay. If an array has string keys (like the inner arrays will) it will be encoded as an object in the JSON.

$geo = [];

Then as you fetch rows, append them to the array after doing whatever transformations you need to do.

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC) ) {
    $geo[] = ['lat' => (float) $row['Latitude'], 'lng' => (float) $row['Longitude']];
}

echo json_encode(["location" => $geo]);

answered Apr 18, 2018 at 15:39

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

Comments

AbraCadaver · Accepted Answer · 2018-04-18 15:43:37Z

2

You don't build an object or array in the loop. It is much simpler if in your query you just SELECT Latitude AS lat, Longitude as lng ...

while($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    $geo[] = array_map('floatval', $row);
}
echo json_encode(array('location' => $geo));

edited Apr 18, 2018 at 15:43

answered Apr 18, 2018 at 15:38

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to while loop php object from database to Json?

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