<?
include "baglanti.php"; // mysql bağlantı bilgilerinin bulundugu ayar dosyası
echo "<?xml version=\"1.0\" encoding=\"iso-8859-9\"?>
<rss version=\"2.0\"
	xmlns:content=\"http://purl.org/rss/1.0/modules/content/\"
	xmlns:wfw=\"http://wellformedweb.org/CommentAPI/\"
	xmlns:dc=\"http://purl.org/dc/elements/1.1/\"
	xmlns:atom=\"http://www.w3.org/2005/Atom\"
	xmlns:sy=\"http://purl.org/rss/1.0/modules/syndication/\"
	xmlns:slash=\"http://purl.org/rss/1.0/modules/slash/\"
	>

<channel>
<title>Title</title>
<description>Desc</description>
<link>http://www.siten.com</link>
<language>tr</language>";
$yazilar = mysql_query("SELECT * FROM sayfa");
while($yazi = mysql_fetch_assoc($yazilar)){

$baslik = str_replace(' ','-',$yazi['url']);
$baslik = str_replace('ö','o',$baslik);
$baslik = str_replace('ü','u',$baslik);
$baslik = str_replace('ç','c',$baslik);
$baslik = str_replace('ı','i',$baslik);
$baslik = str_replace('ğ','g',$baslik);
$baslik = str_replace('ş','s',$baslik);
$baslik = str_replace('Ö','O',$baslik);
$baslik = str_replace('Ş','S',$baslik);
$baslik = str_replace('Ç','C',$baslik);
$baslik = str_replace('Ğ','G',$baslik);
$baslik = str_replace('İ','I',$baslik);
$baslik = str_replace('  ','-',$baslik);
$baslik = str_replace('.','-',$baslik);
$baslik = str_replace(',','-',$baslik);
$baslik = preg_replace("/^[a-zA-Z]$/","",$baslik); 

$link = "http://www.siten.com/$baslik-$yazi[id].html";
echo"
<item>
<title>".$yazi[baslik]."</title>
<description>".$yazi[icerik_ozet]."</description>
<link>".$link."</link>
</item>";
}
$yazilar1 = mysql_query("SELECT * FROM icerik");
while($yazi1 = mysql_fetch_assoc($yazilar1)){
$link1 = "http://www.siten.com/icerik.php?id=".$yazi1[id];
echo"
<item>
<title>".$yazi1[baslik]."</title>
<description>".$yazi1[icerik]."</description>
<link>".$link1."</link>
</item>";
}

echo "
</channel>
</rss>";
?>