PHP help needed.. please check my code below ,Map does load but my poly line does not load help.
<?php require("connect.db.php"); //header('Content-Type: application/json;charset=utf-8'); $query = "SELECT * FROM `table`"; $run = mysql_query($query); $lat = array(); $long = array(); while($row = mysql_fetch_assoc($run)){ $lat[] = $row['mLatitude']; $long[] = $row['mLongitude']; /*$php_var = implode($lat); $php_var2 = implode($long);*/ } $php_var =json_encode($lat); $php_var2 =json_encode($long); ?> <!DOCTYPE html> <html> <head> <meta name="viewport" content="initial-scale=1.0, user-scalable=no"> <meta charset="utf-8"> <title>Simple Polylines</title> <style> html, body, #map-canvas { height: 100%; margin: 0px; padding: 0px } </style> <script src=" https://maps.googleapis.com/maps/api/js?v=3.exp "></script> var lat = <?php echo $php_var; ?>; var lon = <?php echo $php_var2; ?>; document.write(lat[1]); //var loc[lat[0],lon[0]]; function initialize() { var mapOptions = { zoom: 20, center: new google.maps.LatLng(-33.879306,18.634443), mapTypeId: google.maps.MapTypeId.TERRAIN }; var map = new google.maps.Map(document.getElementById('map-canvas'), mapOptions); for (var i =0;i<lat.length;i++ ){ var flightPlanCoordinates = [ new google.maps.LatLng(lat[i],lon[i]) // new google.maps.LatLng(21.291982, -157.821856), //new google.maps.LatLng(-18.142599, 178.431), //new google.maps.LatLng(-27.46758, 153.027892) ]; var flightPath = new google.maps.Polyline({ path: flightPlanCoordinates, geodesic: true, strokeColor: '#FF0000', strokeOpacity: 1.0, strokeWeight: 2 }); flightPath.setMap(map); } } google.maps.event.addDomListener(window, 'load', initialize); </script> </head> <body> <div id="map-canvas"></div> </body> </html>
Join our real-time social learning platform and learn together with your friends!