Subversion Repositories f9daq

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
193 f9daq 1
<?php
2
ini_set('display_errors', 1);
3
ini_set('display_startup_errors', 1);
4
error_reporting(E_ALL);
5
 
6
require 'config.php';
7
require 'ip2coordinates.php';
8
 
9
mysql_connect(DB_HOST, DB_USER, DB_PASS);
10
mysql_select_db(DB_NAME);
11
 
12
$ip = $_SERVER['REMOTE_ADDR'];
13
$userinfo = IPtoCoordinates($ip);
14
 
15
$user = mysql_query('SELECT `location` FROM `visitor_map` WHERE `location` = \'' . $userinfo['location'] . '\'');
16
if(!mysql_fetch_row($user) && $userinfo)
17
        mysql_query('INSERT INTO `visitor_map` (`ip`, `location`, `longitude`, `latitude`) VALUES (\'' . mysql_real_escape_string($ip) . '\', \'' . $userinfo['location'] . '\', ' . $userinfo['longitude'] . ', ' . $userinfo['latitude'] . ')') or die(mysql_error());
18
 
19
?>
20
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
21
<html lang="en">
22
 
23
 <head>
24
  <title>Visitor Map Example</title>
25
   <script src="//maps.googleapis.com/maps/api/js?sensor=false"   type="text/javascript"></script>
26
    <style type="text/css">
27
      html, body, #map { height: 100%; margin: 0; }
28
    </style>
29
    <script type="text/javascript">
30
        //<![CDATA[
31
 
32
    function initialize() {
33
      var map = new google.maps.Map(
34
        document.getElementById('map'), {
35
          center: new google.maps.LatLng(35.69,139.69),
36
          zoom: 3,
37
          minZoom: 2,
38
          mapTypeId: google.maps.MapTypeId.ROADMAP
39
      });
40
     var marker;
41
<?php
42
     $query = mysql_query('SELECT `longitude`, `latitude` FROM `visitor_map`');
43
     while($row = mysql_fetch_array($query)){
44
         if (strlen($row['latitude'])>0){
45
?>
46
     marker = new google.maps.Marker({ position: new google.maps.LatLng(<?php echo $row['latitude']; ?>, <?php echo $row['longitude']; ?>), map: map });
47
<?php
48
//                                break;
49
         }
50
     }
51
?>
52
 
53
 
54
 
55
    }
56
    google.maps.event.addDomListener(window, 'load', initialize);
57
        //]]>
58
 
59
    </script>
60
 
61
 </head>
62
 
63
 <body>
64
<h3>Belle II Masterclass visitor map</h3>
65
  <div id="map" style="width: 90%; height: 90%"></div>
66
 </body>
67
 
68
</html>