Vfrdtyky

Im a Amateur in PHP but i have to build a Website with Google Maps API.

I build it with the informations from here: developers.google

The Data with the coordinates is saved in a Table in my Mysql DB.
At this moment i have to run manually a PHP file, which generates / echo a XML on the browser, which i have to save in my htdocs directory.
In a JS script i run a function, which loads the data from the XML for showing the addresses on the map.

The goal is, that i dont have to run manually this PHP file which generates a XML, which i also have to save it manually to the htdocs directory.

This is where im echo'ing de XML Data to the browser:

// Start XML file, echo parent node

echo "<?xml version='1.0' ?>";

echo '<markers>';

$ind=0;

// Iterate through the rows, printing XML nodes for each

while ($row = @mysqli_fetch_assoc($result)){

  // Add to XML document node

  echo '<marker ';

  echo 'id="' . $row['id'] . '" ';

  echo 'name="' . parseToXML($row['name']) . '" ';

  echo 'address="' . parseToXML($row['address']) . '" ';

  echo 'lat="' . $row['lat'] . '" ';

  echo 'lng="' . $row['lng'] . '" ';

  echo 'type="' . $row['type'] . '" ';

  echo '/>';

  $ind = $ind + 1;

}

// End XML file

echo '</markers>';

How can i do this process outomatically? It should be possible but i found nothing on Google.. I searched for "php fetch from mysql to xml" etc. and found alot about how to fetch data from XML to Mysql.

I hope you are able to understand my bad english.

Greetings

To create the XML file you requested, you would need to write/create the file each time on request.

// This creates the userinfo.xml file and 'w' writes to it.

$xmlfile = fopen("userinfo.xml", "w"); 

$userData = "USER INFORMATION GOES HERE";

fwrite($xmlfile,$userData);

fclose($xmlfile);

This function will override the file named "userinfo.xml" if it exists and override it with the information passed with $userData, so be cautious before handling writing files.