> > <?xml version="1.0"?> > <!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> > Untitled Document > </title> > </head> > <body> > <?php > require("mysql_connect.php"); > > // Get parameters from URL > $center_lat = $_GET["lat"]; > $center_lng = $_GET["lng"]; > $radius = $_GET["radius"]; > > // 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 > $conn = mysql_connect($dbhost, $dbusername,$dbpass,$dbname); > > mysql_select_db($dbname); > if (! $conn) > die(mysql_error()); > > // Set the active mySQL database > $db_selected = mysql_select_db($dbname, $conn); > if (!$db_selected) { > die ("Can\'t use db : " . mysql_error()); > } > // Search the rows in the markers table > $query = sprintf("SELECT address, name, lat, lng, ( 3959 * acos( cos( > radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - > radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS > distance FROM markers HAVING distance < '%s' ORDER BY distance LIMIT 0 , > 20", > 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()); > } > > // 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("name", $row['name']); > $newnode->setAttribute("address", $row['address']); > $newnode->setAttribute("lat", $row['lat']); > $newnode->setAttribute("lng", $row['lng']); > $newnode->setAttribute("distance", $row['distance']); > } > > echo $dom->saveXML(); > ?> > </body> > </html> > That is the file exactly:(
-- You received this message because you are subscribed to the Google Groups "Google Maps API V2" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-maps-api/-/KPEnb-NO-28J. 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-api?hl=en.
