Javascript + Codeigniter - 仅显示输出

Question

我正在尝试获取查询结果，而我想要的是准确的数据(纬度和经度)。查询似乎有效，因为我得到了输出，但它是这种形式的:

[{"latitude":"8.50661","longitude":"124.635"}]

我想要的是这种格式:

[8.50661,124.635]

顺便说一句，这是我的代码:

Controller :

public function retAddress()
{
    $cid = $this->input->post('input_cesid');
    $convAddress = $this->agent_model->getAddress($cid);
    echo json_encode($convAddress);

}

型号:

public function getAddress($data)
{
    $condition = "(SELECT work_address FROM test_workers WHERE work_cesid='". $data . "')";
    $query = $this->db->query("SELECT latitude, longitude FROM geocoding WHERE address=". $condition);
    return $query->result();
}

Ajax :

$('#searchMark').submit(function (event) {
    dataString = $("#input_cesid").serialize();
    $.ajax({
        type:"POST",
        url:"<?php echo base_url(); ?>Functions/retAddress",
        data:dataString,
        success:function (data) {
            $('#testingOutput').html(data);
        }
    });
    event.preventDefault();
});

任何帮助将不胜感激!

Answer 1

你可以在后端构建结果

echo '['.$query->result()['latitude'].','.$query->result()['longitude'].']';