作者:血影修罗 | 来源:互联网 | 2018-04-25 05:03
删除json输出的双引号:`[{"id":"1","nom":"MagasinJardins2","ville":"Paris","latlng":["36.85715,10.127245"]}`latlng值:"[36.85715,10.127245]"代码:$qry"SELECT*FROMmag
phpjsonandroid
删除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);