PHP - Moved: Google Ergonomics

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=307157.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=356052.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=328756.0

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=357315.0

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=306254.0

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=351914.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=356789.0

This topic has been Ctrl+X/Ctrl+V'd to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=347400.0

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=346255.0

Hi guys

Mods please move if this is the wrong place to ask.

I have a google maps api added to my web site but i want to be able to position "pins" on the map to show all the the registered clubs in an area... eg the user searches dublin and all teh clubs pop up...

My question is.. is there anyway to do this without needing the user to supply the long/lat.. ie can it be gotten automatically??

I really just want it to work off the addrees/area they supplied when they registered.


thanks

tt

Hi Guys!!

I am in need of creating a categories' listing similar to that of Google Directory, http://www.google.com/dirhp All the categories along with their respective sub categories, subcategories of the subcategories, and the subsub categories of the subsub categories ( as deep down as the category system goes ) should be displayed which is exactly similar to that of the Google Directory.

Could anyone suggest me how to do it as am pretty much new to PHP. The categories list is stored in a database and should be displayed using PHP and MySQL. This is exactly what i require. I have gone through some articles related to this, (both in this forum and elsewhere) but in all those tutorials, the depth of the categories is known (say, up to 4 or 5 levels). But, what i require is dynamic creation of these categories whose depth is unknown and also provide a way that any user can add a category from the front-end and also the admin can add a category from the back-end.

Am in urgent need of this. Can anyone guide me in this regard, pls? And an example of the same would be of great help.


Thanks in advance!!

Hi I have been working on this code for almost two weeks and can't get over the last hurdle.  If someone can put a fresh set of eys on it I would appreciate it.  I have 3 files -  a geocoder php script which I can't get to work, but it is exactly like the example given on Google except that I have my addresses broken down by street, city, state and zip.
- marker.php which is echoing the data correctly, and my map
- location.html which pulls up a map but no markers. 

my geocoder script is below:
Code: [Select]
<?php

define("MAPS_HOST", "maps.google.com");
define("KEY", "mykey");

// Opens a connection to a MySQL server
$connection = mysql_connect("server", "user","pwd");
if (!$connection) {
  die("Not connected : " . mysql_error());
}

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

// Select all the rows in the markers table
$query = "SELECT * FROM table WHERE 1";
$result = mysql_query($query);
if (!$result) {
  die("Invalid query: " . mysql_error());
}

// Initialize delay in geocode speed
$delay = 0;
$base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&key=" . KEY;

// Iterate through the rows, geocoding each address
while ($row = @mysql_fetch_assoc($result)) {
  $geocode_pending = true;

  while ($geocode_pending) {
    $street = $row["street"];
    $city = $row["city"];
    $state = $row["state"];
    $zip_code = $row["zip_code"];
    $id = $row["id"];
    $request_url = $base_url . "&q=" . urlencode($street + $city + $state + $zip_code);
    $xml = simplexml_load_file($request_url) or die("url not loading");

    $status = $xml->Response->Status->code;
    if (strcmp($status, "200") == 0) {
      // Successful geocode
      $geocode_pending = false;
      $coordinates = $xml->Response->Placemark->Point->coordinates;
      $coordinatesSplit = split(",", $coordinates);
      // Format: Longitude, Latitude, Altitude
      $lat = $coordinatesSplit[1];
      $lng = $coordinatesSplit[0];

      $query = sprintf("UPDATE table " .
             " SET lat = '%s', lng = '%s' " .
             " WHERE id = '%s' LIMIT 1;",
             mysql_real_escape_string($lat),
             mysql_real_escape_string($lng),
             mysql_real_escape_string($id));
      $update_result = mysql_query($query);
      if (!$update_result) {
        die("Invalid query: " . mysql_error());
      }
    } else if (strcmp($status, "620") == 0) {
      // sent geocodes too fast
      $delay += 100000;
    } else {
      // failure to geocode
      $geocode_pending = false;
      echo "Address " . $street . " failed to geocoded. ";
      echo "Received status " . $status . "
\n";
    }
    usleep($delay);
  }
}
?>
my html file looks like the following:
Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8"/>

    <title>location</title>

    <script src="http://maps.google.com/maps?file=api&v=2&key=mykey"

       type="text/javascript"></script>

    <script type="text/javascript">

   

    var iconFlag = new GIcon();

    iconFlag.image = 'images/redflag.png';

    iconFlag.iconSize = new GSize(12, 20);

    iconFlag.iconAnchor = new GPoint(6, 20);

    iconFlag.infoWindowAnchor = new GPoint(5, 1);

   

    var iconBlue = new GIcon();

    iconBlue.image = 'images/glossy-ball.png';

    iconBlue.iconSize = new GSize(12, 20);

    iconBlue.iconAnchor = new GPoint(6, 20);

    iconBlue.infoWindowAnchor = new GPoint(5, 1);



    var iconRed = new GIcon();

    iconRed.image = 'images/redbutton.png';

    iconRed.iconSize = new GSize(12, 20);

    iconRed.iconAnchor = new GPoint(6, 20);

    iconRed.infoWindowAnchor = new GPoint(5, 1);



    var customIcons = [];

    customIcons["Db1"] = iconFlag;

    customIcons["Db2"] = iconBlue;

    customIcons["Db3"] = iconRed;



    function load() {

      if (GBrowserIsCompatible()) {

        var map = new GMap2(document.getElementById("map"));

        map.addControl(new GSmallMapControl());

        map.addControl(new GMapTypeControl());

        map.setCenter(new GLatLng(39.0000, 72.0000), 11);



        // Change this depending on the name of your PHP file

        GDownloadUrl("marker.php", function(data) {

          var xml = GXml.parse(data);

          var markers = xml.documentElement.getElementsByTagName("markers");

          for (var i = 0; i < markers.length; i++) {

            var informant = markers[i].getAttribute("id");

            var firstname = markers[i].getAttribute("firstname");

               var lastname = markers[i].getAttribute("lastname");

            var phone = markers[i].getAttribute("phone");

            var zip_code = markers[i].getAttribute("zip_code");

            var type = markers[i].getAttribute("type");

            var point = new GLatLng(parseFloat(markers[i].getAttribute("lat")),

                                    parseFloat(markers[i].getAttribute("lng")));

            var marker = createMarker(point, id, firstname, lastname, street, city, state, zip_code, type);

            map.addOverlay(marker);

           }

        });

      }

    }



    function createMarker(point, id, firstname, lastname, street, city, state, zip_code, type) {

      var marker = new GMarker(point, customIcons[type]);

      var html = "<b>" + id + "</b> <br/>" + firstname + "<br/>" + lastname + "<br/>" + phone + "<br/>" + street + "<br/>" + city + "<br/>" + state + "<br/>" + zip_code +"<br/>" + type;

      GEvent.addListener(marker, 'click', function() {

        marker.openInfoWindowHtml(html);

      });

      return marker;

    }

    //]]>

  </script>

  </head>

<body background="images/bg2.jpg">

  <body onload="load()" onunload="GUnload()">

    <center><div id="map" style="width: 800px; height: 600px"></div></center>

  </body>

</html>
Thanks for any help

hey guys how do i get a zip codes in the range of 50KM from the current search that is performed!! the search based on zipcodes.
and also is ti possible to print text ON the marker. Dynamic text.

anyideas will be great
 

thanks

I'm having trouble loading this kind of KML with PHP
http://code.google.com/apis/maps/documentation/mapsdata/developers_guide_protocol.html#RetrievingFeatures
example
<atom:entry xmlns='http://www.opengis.net/kml/2.2'
    xmlns:atom='http://www.w3.org/2005/Atom'
    xmlns:batch='http://schemas.google.com/gdata/batch'
    xmlns:gd='http://schemas.google.com/g/2005'>
  <atom:id>
  http://maps.google.com/maps/feeds/features/userID/mapID/full/featureID</atom:id>
  <atom:published>2008-08-14T17:46:06.462Z</atom:published>
  <atom:updated>2008-08-14T18:12:31.589Z</atom:updated>
  <atom:category scheme='http://schemas.google.com/g/2005#kind' 
.....

it seems like the column in atom:entry, etc is causing this.

$response = simplexml_load_string($response);
print_r($response);

the above just gives an empty SimpleXMLElement Object()

Any ideas

Is there a Chrome tag like this IE one

<!--[if IE]>

<![endif]-->

<!--[if !IE]><!-->
       
 <!--<![endif]-->

I have use the above tag in my wordpress site, and the only browser it doesn't work in is Google Chrome.