// Example: database_info.php //
<?php
$hostname="boo*************";
$username="foo******";
$password="********";
$database="hoo******";
?>


// Example: phpsqlsearch_genxml.php ...An case of PHP Version 4 //
<?php
require("database_info.php");   // sql information file
$center_lat = $_GET["lat"];
$center_lng = $_GET["lng"];
$radius = $_GET["radius"];
$doc = domxml_new_doc("1.0");
$node = $doc->create_element("markers"); // table: "markers"
$parnode = $doc->append_child($node);
$connection=mysql_connect ($hostname, $username, $password);
if (!$connection) {
  die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}
$query = sprintf("SELECT address, lat, lng, name, ( 6371 * 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", // not MILE but KM
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);
if (!$result) {
  die('Invalid query: ' . mysql_error());
}
header("Content-type: text/xml");
while ($row = @mysql_fetch_assoc($result)){
  $node = $doc->create_element("marker");
  $newnode = $parnode->append_child($node);
  $newnode->set_attribute("address", $row['address']);   // field: "address"
  $newnode->set_attribute("lat", $row['lat']);   // field: "lat"
  $newnode->set_attribute("lng", $row['lng']);   // field: "lng"
  $newnode->set_attribute("name", $row['name']);   // field: "name"
  $newnode->set_attribute("distance", $row['distance']);
}
$xmlfile = $doc->dump_mem();
echo $xmlfile;
?>