doutu6616 2016-01-27 01:06
浏览 17

在数组php中插入地理数据类型的数据

I have problem inserting geographic data into sqlserver database. This is my array:

this is my controller

UPDATED

  function add()
  {
    $Code = $this->input->post('Code');
    $Description = $this->input->post('Description');
    $Data= $this->input->post('Data');
    $Data2= $this->input->post('Data2');
    $Data3= $this->input->post('Data3');
    $Latitude = $this->input->post('Latitude');
    $Longitude = $this->input->post('Longitude');       
    $Highway_Type = $this->input->post('Highway_Type');

    $data = array(
    'Code' => $Code, 
    'Description' => $Description,
    'Data' => $Data,
    'Data2' => $Data2,
    'Data3' => $Data3,
    'Latitude' => $Latitude,
    'Longitude' => $Longitude,
    'Highway_Type' => $Highway_Type,
    'GeoLocation' => 'geography::Point('.$Latitude.', '.$Longitude.', 4326)',               
    );

    $parent_id = create_data('Table', $data, $user_id);
  }

The geolocation is the problem because it's geography datatype. I can't insert because I got this:

this is screenshot of error

How can I get rid of that thing ' ' for geography type shouldn't have that thing ' '?

this is function for create data

function create_data($model_name, $data, $user_id)
{
    $ci =& get_instance();
    $ci->load->database();

    $ci->db->insert($model_name, $data);

    return $ci->db->insert_id();
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 AT89C51控制8位八段数码管显示时钟。
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口