該樓層疑似違規已被系統折疊?隱藏此樓查看此樓
大家好,剛使用百度地圖API,請教大家一個問題,謝啦!
我需要從我的數據庫中取出字段為"city"的所有數據,然后通過bdGEO()函數在地圖上標注這些城市,我是用PHP連接并查詢數據庫的。但是需要將取到的數據存在一個JS數組中,如:
var adds = ["武漢","長沙"];
請問大家怎么將用php取到的數組變成JS中的數組作為參數給JS中的函數呢?謝謝啦,代碼如下:
//php連接數據庫代碼
$con = mysql_connect("localhost","root","85208520");
$i = 0;
$k = 0;
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("test", $con);
mysql_query("set names GB2312");
$result = mysql_query("SELECT * FROM person");
while($row = mysql_fetch_array($result))
{
$cityarry[$i++] = $row['city']; //保存數據到數組$cityarry中
}
mysql_close($con);
?>
//JS代碼
var map = new BMap.Map("l-map");
map.centerAndZoom(new BMap.Point(103.269945,41.86713), 5);
var index = 0;
var myGeo = new BMap.Geocoder();
var adds = ["武漢","長沙"]; //此處不知如何轉換
//eval('(' + <?php json_encode($cityarry);?> + ')'); //試圖用JSON方式,失敗
function bdGEO(){
var add = adds[index];
geocodeSearch(add);
index++;
}
function geocodeSearch(add){
if(index < adds.length){
setTimeout(window.bdGEO,0);
}
myGeo.getPoint(add, function(point){
if (point) {
var point2 = new BMap.Point(point.lng, point.lat)
var marker = new BMap.Marker(point2);
map.addOverlay(marker);
map.addHotspot(hotSpot);
}
}, "江蘇省");
}
map.enableScrollWheelZoom();
//bdGEO();
感激不盡!!