我可以通过列中的lat＆lng一起从mySQL检索谷歌地图坐标吗？

Question

Normally people created 2 column in mySQL called latitude and longitude to store and retrieve the coordinates of the points. However, my app retrieves the whole latitude and longitude coordinates and insert them into only 1 column.

Example shown: (1.372442, 103.94954699999994)

Is it possible to insert my database column into the position like below ? or any way I could do it.

var marker = new google.maps.Marker({
position: new google.maps.LatLng(<?php echo $location['locationOne']),
map: map,
}); 

Can the google map acknowledge this and retrieve the points and plot out according to my example ? Thanks

Answer 1

You don't need to split - as long as your server side code produces valid javascript - the users browser will parse it. It so happens javascript uses commas to seperate variables in a function call.

From your example, it appears it already has brackets on the provided values, so you dont need the hardcoded ones.

position: new google.maps.LatLng<?php echo $location['locationOne']; ?>,

But you may want to do some validation, on the value inside locationOne - otherwise you liable to produce invalid javascript, which will at best give a cryptic error message to the user. Not good.