如何在没有双引号的情况下回显json数据值

Question

I am created a web service and it returns json data as follows. [{"lat":"6.8658","lng":"79.8744"}]

But I actually need like following. [{"lat":6.8658,"lng":79.8744}]

My php code is as follows

$location_data= $this->db->query("SELECT lat,lng FROM jobs WHERE job_code='JO34656'")->result_array();

echo json_encode($location_data);

Answer 1

Just cast all elements into floatval:

$location_data = $this->db->query("SELECT lat,lng FROM jobs WHERE job_code='JO34656'")->result_array();
$data = json_encode(array_map(function($e){
    return array_map('floatval', $e);
}, $location_data));

Or just pick whichever column you want casted:

$location_data = json_encode(array_map(function($e){
    foreach($e as $key => &$loc) {
        if(in_array($key, array('lat', 'lng'))) {
            $loc = floatval($loc);
        }
    }
    return $e;
}, $location_data));