Php – Using Google Maps API to find routes & distance between two locations and present it in a table

google mapsgoogle-maps-api-3MySQLPHP

I want to use Google maps to find out available routes between two cities. Some information about these routes like distance and travel time etc.

I do not want this data to be presented in a Map. I need this to be presented to end user in textual format.

User will give me two cities and I will present him with various routes and information in a table.

Can this be done using PHP, MySQL and Google Maps? Any pointers would be very helpful.

Best Answer

If you want multiple routes between two points, use the directions service (http://code.google.com/apis/maps/documentation/directions) and specify alternatives=true in the request. This will return alternate routes, if they're available. Then, parse the response for the desired information:

there will be one legs array for each route
within that legs array, there is a distance and a duration field, each containing a raw value and a textual value.

If you don't need multiple choices for the route, the Google Maps Distance Matrix service (http://code.google.com/apis/maps/documentation/distancematrix/) provides travel distance and time between multiple origins and destinations, without all of the directions information.

A sample table is in the blog post: http://googlegeodevelopers.blogspot.com/2011/05/what-is-distance-matrix.html

Related Solutions

Javascript – Calculate distance between two points in google maps V3

If you want to calculate it yourself, then you can use the Haversine formula:

var rad = function(x) {
  return x * Math.PI / 180;
};

var getDistance = function(p1, p2) {
  var R = 6378137; // Earth’s mean radius in meter
  var dLat = rad(p2.lat() - p1.lat());
  var dLong = rad(p2.lng() - p1.lng());
  var a = Math.sin(dLat / 2) * Math.sin(dLat / 2) +
    Math.cos(rad(p1.lat())) * Math.cos(rad(p2.lat())) *
    Math.sin(dLong / 2) * Math.sin(dLong / 2);
  var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1 - a));
  var d = R * c;
  return d; // returns the distance in meter
};

Javascript – Google Maps API v3: How to remove all markers

Simply do the following:

I. Declare a global variable:

var markersArray = [];

II. Define a function:

function clearOverlays() {
  for (var i = 0; i < markersArray.length; i++ ) {
    markersArray[i].setMap(null);
  }
  markersArray.length = 0;
}

google.maps.Map.prototype.clearOverlays = function() {
  for (var i = 0; i < markersArray.length; i++ ) {
    markersArray[i].setMap(null);
  }
  markersArray.length = 0;
}

III. Push markers in the 'markerArray' before calling the following:

markersArray.push(marker);
google.maps.event.addListener(marker,"click",function(){});

IV. Call the clearOverlays(); or map.clearOverlays(); function wherever required.

That's it!!

Best Answer

Related Solutions

Javascript – Calculate distance between two points in google maps V3

Javascript – Google Maps API v3: How to remove all markers

Related Topic