[Google Maps API v2] using php for output xml markers and lines.

[guido Schmidt]

I did manage to make a website with markers. 
The lat/ lng is stored in the database extra data is also in the database.

A xml file is outputed: http://www.finnschmidt.nl/gen_xml2.php?regio=aare
It is read in the following map: 
http://www.finnschmidt.nl/reis/aare/map/index2.php

I want also use polyline between several markers. Markers with Type="X" 
should display a line beteween the markers. ( 
http://econym.org.uk/gmap/example_map7.htm /  
http://econym.org.uk/gmap/example4.xml )

The php file needs to do this, I have little programming scills, but so far 
it was working.

Could some point me in the right direction, or give me some hints.

If you need more info, please let me know.

Guido

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

// Get parameters from URL
$regio = $_GET["regio"];


// Start XML file, create parent node
$dom = new DOMDocument("1.0");
$node = $dom->createElement("markers");
$parnode = $dom->appendChild($node);

// Opens a connection to a mySQL server
$connection=mysql_connect (localhost, $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());
}

// Search the rows in the markers table
$query = sprintf("SELECT  id, naam, lat, lng, info, url, type FROM markers 
WHERE `regio` = '$regio'   ",
  mysql_real_escape_string($center_lat),
  mysql_real_escape_string($center_lng),
  mysql_real_escape_string($center_lat),
  mysql_real_escape_string($radius));
$result = mysql_query($query);

$result = mysql_query($query);
if (!$result) {
    die("Invalid query: " . mysql_error());
}

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

// Iterate through the rows, adding XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
    $node = $dom->createElement("marker");
    $newnode = $parnode->appendChild($node);
    $newnode->setAttribute("naam", $row['naam']);
    $newnode->setAttribute("id", $row['id']);
        $newnode->setAttribute("info", $row['info']);
        $newnode->setAttribute("url", $row['url']);
        $newnode->setAttribute("type", $row['type']);
    $newnode->setAttribute("lat", $row['lat']);
    $newnode->setAttribute("lng", $row['lng']);

}

echo $dom->saveXML();
?>


-- 
You received this message because you are subscribed to the Google Groups 
"Google Maps API V2" group.
To post to this group, send email to google-maps-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-maps-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-maps-api?hl=en.