dpwjx32578146 2013-09-15 16:53
浏览 37
已采纳

如何从mysql表中获取许多纬度/经度值并将其作为Google Maps Markers放置?

I've got a mysql-table with user data inside. Among them there are latitude/longitude position values. (as two separate values) To create a marker out of them this should work:

function initialize() {
  var myLatlng = new google.maps.LatLng(**LATITUDE HERE**,**LONGITUDE HERE**);
  var mapOptions = {
    zoom: 4,
    center: somewhere,
    mapTypeId: google.maps.MapTypeId.ROADMAP
  }
  var map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions);

  var marker = new google.maps.Marker({
      position: myLatlng,
      map: map,
  });
}

google.maps.event.addDomListener(window, 'load', initialize);

I'd now like to place a single marker for every user on a map. How can I get the lat/lng values from the table for all users and finally place all those markers? So basically, how does this loop work?

Thanks a lot!

  • 写回答

1条回答 默认 最新

  • donglijuan8227 2013-09-15 17:04
    关注

    Loop will work as follows, considering I have an array of users location of following form

    locations[0] = new Array("latitude" => "lat", "longitude" => "lng");
    

    then loop will be as follows

    for (i = 0; i < locations.length; i++) {  
        marker = new google.maps.Marker({position: new google.maps.LatLng(locations[i]["latitude"], locations[i]["longitude"]), map: map});
     }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 iqoo11 如何下载安装工程模式
  • ¥15 flask项目,怎么使用AJAX传数据库数据到echarts图表的data里,实现异步加载数据。
  • ¥15 本题的答案是不是有问题
  • ¥15 关于#r语言#的问题:(svydesign)为什么在一个大的数据集中抽取了一个小数据集
  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 蓝桥杯单片机第十三届第一场,整点继电器吸合,5s后断开出现了问题