Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <link rel='stylesheet' media="screen" type='text/css' href='mapa_google.css' />
- <script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js'></script>
- <script src="http://code.jquery.com/jquery-1.4.4.js"></script>
- <script type="text/javascript">
- function initialize() {
- var mapOptions = {
- center: new google.maps.LatLng(51.919438, 19.145136),
- zoom: 6,
- mapTypeId: google.maps.MapTypeId.ROADMAP
- };
- var map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
- <?php
- $user = '######';
- $password = '########';
- $database = '###########';
- $sql_server = '#########';
- mysql_connect('localhost', $user, $password);
- @mysql_select_db($database) or die("Nie udało się wybrać bazy danych");
- $wybrana_data = '2012-11-05';
- $query="SELECT opis, lat, lng, id FROM lokalizacje WHERE data > '".$wybrana_data."'";
- $result=mysql_query($query);
- mysql_close();
- ?>
- <?php
- while ($row = mysql_fetch_array($result)) {
- $opis = $row['opis'];
- $lat = $row['lat'];
- $lng = $row['lng'];
- $id = $row['id'];
- ?>
- var myLatLng = new google.maps.LatLng(<?php echo $lat; ?>, <?php echo $lng; ?>);
- var tytul = "<?php echo $opis; ?>";
- var id = "<?php echo $id; ?>";
- var marker_<?php echo $id; ?> = new google.maps.Marker({
- position: myLatLng,
- map: map,
- title: tytul,
- zIndex: id
- });
- <?php
- }
- ?>
- }
- function loadScript() {
- var script = document.createElement("script");
- script.type = "text/javascript";
- script.src = "http://maps.googleapis.com/maps/api/js?key##############&sensor=true&callback=initialize";
- document.body.appendChild(script);
- }
- window.onload = loadScript;
- loadScript()
- </script>
- <div id="map_canvas">
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement