<?php define('DBHOST','localhost');
define('DBUSER','user');
define('DBNAME','rss');
define('DBPWD','password');
$connect = new MySQLi(DBHOST,DBUSER,DBPWD,DBNAME)or die(mysqli_error());
header("Content-Type: text/xml;charset=iso-8859-1");  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?> <urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">"; {
$query = $connect->query("select * from rss");
while($row=$query->fetch_array(MYSQL_ASSOC)) {   $url = $row["link"];  $time = $row["when"];  $lastmod = $time;   $datetime = new DateTime($lastmod);  $timeresult = $datetime->format('Y-m-d\TH:i:sP');   echo "<url>      <loc>$url</loc>      <lastmod>$timeresult</lastmod>      <changefreq>hourly</changefreq>      <priority>0.8</priority>  </url> ";}}
?>
</urlset>