Advertisement
Guest User

wrogu

a guest
Dec 8th, 2012
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <link rel='stylesheet' media="screen" type='text/css' href='mapa_google.css' />
  2. <script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js'></script>
  3. <script src="http://code.jquery.com/jquery-1.4.4.js"></script>
  4.  
  5.     <script type="text/javascript">
  6.       function initialize() {
  7.         var mapOptions = {
  8.           center: new google.maps.LatLng(51.919438, 19.145136),
  9.           zoom: 6,
  10.           mapTypeId: google.maps.MapTypeId.ROADMAP
  11.         };
  12.         var map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
  13.          
  14.   <?php
  15.   $user = '######';
  16.   $password = '########';
  17.   $database = '###########';
  18.   $sql_server = '#########';
  19.  
  20.   mysql_connect('localhost', $user, $password);
  21.   @mysql_select_db($database) or die("Nie udało się wybrać bazy danych");
  22.  
  23.   $wybrana_data = '2012-11-05';
  24.  
  25.   $query="SELECT opis, lat, lng, id FROM lokalizacje WHERE data > '".$wybrana_data."'";
  26.   $result=mysql_query($query);
  27.   mysql_close();
  28.   ?>
  29.   <?php
  30.   while ($row = mysql_fetch_array($result)) {
  31.   $opis = $row['opis'];
  32.   $lat = $row['lat'];
  33.   $lng = $row['lng'];
  34.   $id = $row['id'];
  35.   ?>
  36.  
  37.   var myLatLng = new google.maps.LatLng(<?php echo $lat; ?>, <?php echo $lng; ?>);
  38.   var tytul = "<?php echo $opis; ?>";
  39.   var id = "<?php echo $id; ?>";
  40.   var marker_<?php echo $id; ?> = new google.maps.Marker({
  41.         position: myLatLng,
  42.         map: map,
  43.         title: tytul,
  44.         zIndex: id
  45.       });
  46.  
  47.    
  48.  <?php
  49.  }
  50.  ?>
  51.   }
  52.    
  53.   function loadScript() {
  54.   var script = document.createElement("script");
  55.   script.type = "text/javascript";
  56.   script.src = "http://maps.googleapis.com/maps/api/js?key##############&sensor=true&callback=initialize";
  57.   document.body.appendChild(script);
  58. }
  59.    window.onload = loadScript;
  60.    loadScript()
  61.    </script>
  62.    
  63.    
  64.       <div id="map_canvas">
  65.       </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement