<?php 
header('Content-type: Application/xml; charset="utf8"', true);
$sitelink = $_SERVER['SERVER_NAME']; 
$date = date("Y-m-d"); 
?>
 <?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
  <channel>
    <title>Siteadınız - RSS</title>
    <description>RSS Açıklamanız</description>
    <link><?php echo $sitelink ?></link>
    <language>tr</language>
    <atom:link href="<?php echo $sitelink ?>/rssadresiniz" rel="self" type="application/rss+xml" />
    <lastBuildDate><?php echo $date; ?></lastBuildDate>
    <pubDate><?php echo $date; ?></pubDate>
<?php
$MagazaGetir = $db->query("SELECT * FROM magazalar ORDER BY id DESC", PDO::FETCH_ASSOC);
foreach($MagazaGetir as $val) {   ?>
    <item>
      <title><?php echo $val["baslik"]; ?></title> //veritabanina göre kendiniz basarsiniz
      <link><?php echo $val["link"]; ?></link>
      <guid><?php echo $val["link"]; ?></guid>
      <description><?php echo $val["description"]; ?></description>
      <source url="<?php echo $sitelink ?>">Siteadınız</source>
      <pubDate><?php echo $date; ?></pubDate>
    </item>
<?php } ?>
 </channel>
</rss>