87,991
社区成员
发帖
与我相关
我的任务
分享
var LatLng = new array();
var name = new array();
$server="localhost";
$username="root";
$password="";
$con=mysql_connect($server,$username);
if(!$con)
{
echo"Cannot connect to Database";
}
else
{
mysql_select_db("db_distillery",$con);
$sql="SELECT * FROM tb_distillery_info";
$result=mysql_query($sql);
}
$count=0;
echo"<script>";
while($row=mysql_fetch_array($result))
{
$name=$row["distillery_name"];
$LatLng=$row["distillery_latitude"].",".$row["distillery_longitude"];
echo "name(".$count.")=".$name.";";
echo "LatLng(".$count.")=".$LatLng.";";
}
echo "</script>";
function initialize() {
var myLatlng = new google.maps.LatLng(56,7);
var mapOptions = {
zoom: 8,
center: myLatlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions);
var counter = name.length;
for(var i=0;i<counter;i++)
{
var LL=new google.maps.LatLng(LatLng[i]);
var marker =new google.maps.Marker({
position:LL,
map:map,
title:name[i]
});
}
}
google.maps.event.addDomListener(window, 'load', initialize);