Hello,

sorry for my bad english

i make a page in localhost with "Using PHP/MySQL with Google Maps"

http://code.google.com/intl/fr/apis/maps/articles/phpsqlajax_v3.html

it's work fine but when i have over 9000 locations it' not work on
explorer ( 7 or 8)  but it's work on firework

in explorer i have message
"a script on this page may slow the execution "

when i have only 300 locations  its work on explorer


the script

<script src="http://maps.google.com/maps/api/js?sensor=false";
            type="text/javascript"></script>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="http://gmaps-utility-
library.googlecode.com/svn/trunk/markermanager/release/src/
markermanager.js"></script>

<script type="text/javascript" >
    //<![CDATA[

    var customIcons = {
      "restaurants": {
        icon: 'http://localhost/totos_france/image/icon_map/
restaurant.png',
        shadow: 'http://labs.google.com/ridefinder/images/
mm_20_shadow.png'
      },
      bar: {
        icon: 'http://labs.google.com/ridefinder/images/
mm_20_red.png',
        shadow: 'http://labs.google.com/ridefinder/images/
mm_20_shadow.png'
      }
    };

    function load() {
      var map = new
google.maps.Map(document.getElementById("EmplacementDeMaCarte"), {
        center: new google.maps.LatLng(<?php echo $latit ; ?>, <?php
echo $longit ; ?>),
        zoom: <?php echo $zoom ; ?>,
        mapTypeId: 'roadmap'
      });
      var infoWindow = new google.maps.InfoWindow;

      // Change this depending on the name of your PHP file
      downloadUrl("phpsqlajax_genxml_toto.php", function(data) {
        var xml = data.responseXML;
        var markers =
xml.documentElement.getElementsByTagName("marker");
        for (var i = 0; i < markers.length; i++) {
                        var name = markers[i].getAttribute("name");
          var address = markers[i].getAttribute("address");
                        var addresstoto = 
markers[i].getAttribute("addresstoto");
                  var cptoto = markers[i].getAttribute("cptoto");
                   var teltoto = markers[i].getAttribute("teltoto");
            var type = markers[i].getAttribute("typeresto");
          var point = new google.maps.LatLng(
              parseFloat(markers[i].getAttribute("lat")),
              parseFloat(markers[i].getAttribute("lng")));
           var html = "<span class=\"textebullgras\">" + name + "</
span> <br/> <span class=\"textebullnormal\">" + address + " <br/> " +
addresstoto + " " + cptoto + "<br/>" + teltoto  ;
          var icon = customIcons[type] || {};
          var marker = new google.maps.Marker({
            map: map,
            position: point,
            icon: icon.icon,
            shadow: icon.shadow
          });
          bindInfoWindow(marker, map, infoWindow, html);

        }
      });
    }

    function bindInfoWindow(marker, map, infoWindow, html) {
      google.maps.event.addListener(marker, 'click', function() {
        infoWindow.setContent(html);
        infoWindow.open(map, marker);
      });
    }

    function downloadUrl(url, callback) {
      var request = window.ActiveXObject ?
          new ActiveXObject('Microsoft.XMLHTTP') :
          new XMLHttpRequest;

      request.onreadystatechange = function() {
        if (request.readyState == 4) {
          request.onreadystatechange = doNothing;
          callback(request, request.status);
        }
      };

      request.open('GET', url, true);
      request.send(null);
    }

    function doNothing() {}

    //]]>
</script>


and

<?php
require("phpsqlajax_dbinfo.php");

function parseToXML($htmlStr)
{
$xmlStr=str_replace('<','<',$htmlStr);
$xmlStr=str_replace('>','>',$xmlStr);
$xmlStr=str_replace('"','"',$xmlStr);
$xmlStr=str_replace("'",''',$xmlStr);
$xmlStr=str_replace("&",'&',$xmlStr);
$xmlStr=str_replace("é",'é',$xmlStr);
$xmlStr=str_replace("è",'è',$xmlStr);
return $xmlStr;
}

// Opens a connection to a MySQL server
$connection=mysql_connect ($host, $username, $password);
if (!$connection) {
  die('Not connected : ' . mysql_error());
}

// Set the active MySQL database
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}

// Select all the rows in the markers table
$query = "SELECT * FROM table_toto WHERE 1";
$result = mysql_query($query);

if (!$result) {
  die('Invalid query: ' . mysql_error());
}

header("Content-type: text/xml");

// Start XML file, echo parent node
echo '<markers>';

// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
  // ADD TO XML DOCUMENT NODE
  echo '<marker ';
  echo 'name="' . utf8_encode($row['nom_toto']) . '" ';
  echo 'address="' . utf8_encode($row['adresse_toto']) . '" ';
  echo 'addresstoto="' . utf8_encode($row['ville_toto']) . '" ';
  echo 'cptoto="' . $row['cp_resto'] . '" ';
  echo 'teltoto="' . $row['tel_resto'] . '" ';
  echo 'lat="' . $row['lat_resto'] . '" ';
  echo 'lng="' . $row['lng_resto'] . '" ';
  echo 'typeresto="' . utf8_encode($row['categorie_toto']) . '" ';
  echo '/>';
}

// End XML file
echo '</markers>';

?>

thank you for help

Serna from France


-- 
You received this message because you are subscribed to the Google Groups 
"Google Maps JavaScript API v3" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/google-maps-js-api-v3?hl=en.

Reply via email to