<?php 
 require_once("db.php"); 
 $arr = $conn->getStreetsList(); 
?> 
<!DOCTYPE html> 
<html> 
<head> 
 <title>Delete a street</title> 
 <script src="js/jquery.min.js"></script> 
 <link rel="stylesheet" href="css/leaflet.css" /> 
 <script src="js/leaflet.js"></script> 
</head> 
<body> 
 <div id="map" style="width: 600px; height: 400px"></div><br /> 
 <form action="deletestreetdb.php" method="post"> 
  <h1>Delete a street</h1> 
  <table cellpadding="5" cellspacing="0" border="0"> 
   <tbody> 
    <tr align="left" valign="top"> 
     <td align="left" valign="top">Street name</td> 
     <td align="left" valign="top"><select id="street" name="street"><option value="0">Please choose a street</option><?php for($i=0;$i<count($arr);$i++) { print '<option value="'.$arr[$i]['id'].'">'.$arr[$i]['name'].'</option>'; } ?></select></td> 
    </tr> 
    <tr align="left" valign="top"> 
     <td align="left" valign="top"></td> 
     <td align="left" valign="top"><input type="submit" value="Delete"></td> 
    </tr> 
   </tbody> 
  </table> 
 </form> 
 <script> 
  var map = L.map( 'map' ).setView( [51.505, -0.09], 13); 
  var polyLine; 
  var draggableStreetMarkers = new Array(); 
 
  L.tileLayer( 'https://api.mapbox.com/styles/v1/mapbox/streets-v10/tiles/{z}/{x}/{y}?access_token=pk.eyJ1IjoibWVnYTYzODIiLCJhIjoiY2ozbXpsZHgxMDAzNjJxbndweDQ4am5mZyJ9.uHEjtQhnIuva7f6pAfrdTw', { 
   maxZoom: 18, 
   attribution: 'Map data © <a href="http://openstreetmap.org/"> OpenStreetMap </a> contributors, ' + 
    '<a href="http://creativecommons.org/"> CC-BY-SA</a>, ' + 
    'Imagery ? <a href="http://mapbox.com"> Mapbox </a>', 
   id: 'examples.map-i875mjb7' 
  }).addTo(map); 
   
  function resetStreet() { 
   if(polyLine != null) { 
    map.removeLayer( polyLine ); 
   } 
   for(i=0; i<draggableStreetMarkers.length; i++) { 
    map.removeLayer( draggableStreetMarkers[ i ]); 
   } 
   draggableStreetMarkers = new Array(); 
  } 
   
  function addMarkerStreetPoint( latLng ) { 
   var streetMarker = L.marker( [latLng.lat, latLng.lng], { draggable: true, zIndexOffset: 900 }).addTo(map); 
    
   streetMarker.arrayId = draggableStreetMarkers.length; 
 
   streetMarker.on('click', function() { 
    map.removeLayer( draggableStreetMarkers[ this.arrayId ]); 
    draggableStreetMarkers[ this.arrayId ] = ""; 
   }); 
 
   draggableStreetMarkers.push( streetMarker ); 
  } 
   
  function drawStreet() { 
   if(polyLine != null) { 
    map.removeLayer( polyLine ); 
   } 
 
   var latLngStreets = new Array(); 
 
   for(i=0; i < draggableStreetMarkers.length; i++) { 
    if(draggableStreetMarkers[ i ] != "") { 
     latLngStreets.push( L.latLng( draggableStreetMarkers[ i ].getLatLng().lat, draggableStreetMarkers[ i ].getLatLng().lng)); 
    } 
   } 
 
   if(latLngStreets.length > 1) { 
    // create a red polyline from an array of LatLng points 
    polyLine = L.polyline(latLngStreets, {color: 'red'}).addTo(map); 
   } 
 
   if(polyLine != null) { 
    // zoom the map to the polyline 
    map.fitBounds( polyLine.getBounds() ); 
   } 
  } 
   
  function getGeoPoints() { 
   var points = new Array(); 
   for(var i=0; i < draggableStreetMarkers.length; i++) { 
    if(draggableStreetMarkers[ i ] != "") { 
     points[i] =  draggableStreetMarkers[ i ].getLatLng().lng + "," + draggableStreetMarkers[ i ].getLatLng().lat; 
    } 
   } 
   $('#geo').val(points.join(',')); 
  } 
   
  $( document ).ready(function() {    
   $("#street").change(function() { 
    resetStreet(); 
    for(var i=0; i <arr.length; i++) { 
     if(arr[i]['id'] == $('#street').val()) { 
      arrangePoints( arr[ i ]['geolocations']); 
      drawStreet(); 
      break; 
     } 
    } 
   }); 
  }); 
   
  function arrangePoints(geo) { 
   var linesPin = geo.split(","); 
 
   var linesLat = new Array(); 
   var linesLng = new Array(); 
 
   for(i=0; i<linesPin.length;i++) { 
    if(i % 2) { 
     linesLat.push(linesPin[i]); 
    }else{ 
     linesLng.push(linesPin[i]); 
    } 
   } 
 
   var latLngLine = new Array(); 
 
   for(i=0; i<linesLng.length;i++) { 
    latLngLine.push( L.latLng( linesLat[i], linesLng[i])); 
   } 
 
   for(i=0; i < latLngLine.length; i++) { 
    addMarkerStreetPoint( latLngLine[i]); 
   } 
  } 
   
  var arr = JSON.parse( '<?php echo json_encode($arr) ?>' ); 
 </script> 
</body> 
</html>
 
 |