EnclosedMail EnclosedMail - 1 month ago 5x
PHP Question

Create a proper path for navigation

I have to create a navigation path for ships. All the ships come to a center point and halt there for a while.
The coordinates of the ships and the center point (MotherShip) come from the database.

The code to select the data. The center point is static.

$sqlqry = "SELECT * FROM ship WHERE id=" . $id . " AND start_date BETWEEN '" . $s_date . "' AND '" . $e_date . "'";
$result = mysqli_query($bd, $sqlqry);
$locations = array();
while($row = mysqli_fetch_array($result)) {
array_push($locations, $row);
$nrows = mysqli_num_rows($result);

The problem is that there are some ships that start from the center point in water. They should start and end at land.

Like here you can see one ship at the start of red line(land) and one at the start of green line (in water where center point is).

Here is my google maps JavaScript part for initialization part.

var nrows = <?php echo json_encode($nrows,JSON_NUMERIC_CHECK);?>;
var locMatrix = <?php echo json_encode($locations,JSON_NUMERIC_CHECK);?>;
var m_ship_rows = <?php echo json_encode($m_ship_rows,JSON_NUMERIC_CHECK);?>;
var m_ship = <?php echo json_encode($m_ship,JSON_NUMERIC_CHECK);?>;

var line;
var line1;
var lineArray = [];
var lineArray1 = [];
var DrivePath = [];
// This example adds an animated symbol to a polyline.

function initMap() {

var intervalForAnimation;
var count = 0;
var n = 2;
for(var i=0;i<=nrows-1;i++)
DrivePath.push(new google.maps.LatLng(locMatrix[i][1], locMatrix[i][2]),
new google.maps.LatLng(17.8674, 66.543),
new google.maps.LatLng(locMatrix[i][3], locMatrix[i][4]));
var Colors = [

The entire code is at JSFiddle.

Also you can visit my github repo for the entire code.



Well I found a different solution which partly helped me.

// Create the polyline and add the symbol to it via the 'icons' property.
        for(var i=0; i <=nrows; i++)
          var line = new google.maps.Polyline({
            path: [{lat: locMatrix[i][1], lng: locMatrix[i][2]},
            {lat: 17.8674, lng: 66.543},
            {lat: locMatrix[i][3], lng: locMatrix[i][4]}],
            icons: [{
              icon: lineSymbol,
              offset: '100%'
          strokeColor: '#000000',
          strokeOpacity: 1.0,
          map: map

animateCircle() Function:

function animateCircle(line) {
          var count = 0;
          window.setInterval(function() {
            count = (count+0.5) % 200;
            var icons = line.get('icons');
            icons[0].offset = (count / 2) + '%';
            line.set('icons', icons);
        }, 20);