Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
- <style type="text/css">
- #map {
- height: 400px;
- width: 100%;}
- </style>
- <script type="text/javascript"
- src="https://maps.googleapis.com/maps/api/js?key=replace_API_KEY&sensor=false">
- </script>
- <script type="text/javascript">
- function initialize() {
- var position_australia = {lat: -25.363, lng: 131.044};
- var position_angola = {lat: -14.458, lng: 16.709};
- var mapOptions = {
- center: position_australia,
- zoom: 4
- };
- var map = new google.maps.Map(document.getElementById("map"), mapOptions);
- }
- function addMarker(lat, lng, info) {
- var location= new google.maps.LatLng(lat, lng);
- bounds.extend(location);
- var marker = new google.maps.Marker({
- map: map,
- position: location
- });
- map.fitBounds(bounds);
- bindInfoWindow(marker, map, infoWindow, info);
- }
- // Displays information on markers that are clicked
- function bindInfoWindow(marker, map, infoWindow, info) {
- google.maps.event.addListener(marker, 'click', function() {
- infoWindow.setContent(info);
- infoWindow.open(map, marker);
- });
- }
- </script>`
- </head>
- <body onload="initialize()" style="margin:0px; border:0px; padding:0px;">
- <div id="map"></div>
- <?php
- $host="localhost";
- $user="user";
- $pass="pw;
- $db="db";
- $connection=mysqli_connect($host, $user, $pass) or die (mysqli_error());
- mysqli_select_db($connection, $db) or die (mysqli_error());
- mysqli_set_charset($connection, "utf8");
- $query_3=mysqli_query($connection, "SELECT * FROM countries2 WHERE short LIKE '$value_short_nocomma'") or die("MySQL error: " . mysqli_error($dbc) . "<hr>nQuery: $query");;
- while ($row=mysqli_fetch_array($query_3))
- {
- $lat = $row["lat"];
- $lng = $row["lng"];
- $content = $row["content"]
- }
- echo "<script> addMarker($lat, $lng, $content); </script>";
- }
- ?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment