2013-10-28 15:40


  • php
  • mysql
  • javascript

I've following php page which get a single latitude and longitude from mysql db and it's editable by Mouse. I mean i can move the position by click on the marker.

Well, now, I've few lat and long in my db. I want to show all lat and long on the map. How can i do this.

Javascript code:

<script type="text/javascript" src="http://maps.googleapis.com/maps/api

<script type="text/javascript">

// Map Initialize function

function initialize() 
// Set static latitude, longitude value
var latlng = new google.mpaps.LatLng(<?php echo $lat_d; ?>, <?php echo $long_d; ?>);
// Set map options
var myOptions = {
    zoom: 16,
    center: latlng,
    panControl: true,
    zoomControl: true,
    scaleControl: true,
    mapTypeId: google.maps.MapTypeId.ROADMAP
// Create map object with options
map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);
// Create and set the marker
marker = new google.maps.Marker({
    map: map,
    position: latlng

// Register Custom "dragend" Event
google.maps.event.addListener(marker, 'dragend', function() {

    // Get the Current position, where the pointer was dropped
    var point = marker.getPosition();
    // Center the map at given point
    // Update the textbox
    document.getElementById('txt_latlng').value=point.lat()+", "+point.lng();


Html Code:

<div style="float:left; position:relative; width:550px; border:0px #000 solid;">
<div id="map_canvas" style="width:550px;height:400px;border:solid black 1px;"></div>

Php code:

$id = (int) $_GET['id'];
$sql = mysql_query("SELECT * FROM parkings WHERE LocId = '$id'");
$res =  mysql_fetch_array($sql);
$lat_d = $res['latitude'];
$long_d = $res['longitude'];

Any idea or how can i do this ?

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享