删除json输出的双引号:[{"id":"1","nom":"Magasin Jardins 2","ville":"Paris","latlng":["36.85715,10.127245"]}
latlng值:[36.85715,10.127245]
代码:
$qry = "SELECT *FROM magasin";
$result = mysql_query($qry);
// $promotions = array();
$response = array();
while($row = mysql_fetch_assoc($result)) {
// $promotions[]= $row;
$magasin = array();
$magasin["id"] = $row["id"];
$magasin["nom"] = $row["nom"];
$magasin["ville"] = $row["ville"];
$lat = $row[latitude];
$long = $row[longitude];
$magasin["latlng"][] =floatval($lat).",".floatval($long);;
// push single product into final response array
array_push($response, $magasin);
}
mysql_close($con);
echo json_encode($response);