Here I am giving you the very basic sample code for creating the XML file through PHP and MYsql
<?php
// We'll be outputting a PDF
header('Content-type: text/xml');
echo "”
$db_name = “testDB”;
$connection = mysql_connect(“example.com”, “username”, “password”) or die(“Could not connect.”);
$table_name = ‘user’;
$query = “select * from ” . $table_name;
$result = mysql_query($query, $connection) or die(“Could not complete database query”);
$num = mysql_num_rows($result);
while ($row = mysql_fetch_assoc($result)) {
echo “”. $row['firstname'].”";
echo “”. $row['lastname'].”";
echo “
“;
echo “”. $row['age'].”";
}
?>
thanks this is very usefull.