Php Rss Oluşturma (PDO)

Örnek olarak kullandığım bir RSS beslemesini sizlere faydalı olması açısından buraya paylaşayım.

::baslangic::?php
header(Content-Type: text/html; charset=utf-8);

$db_host = "";
$db_name = "";
$db_username = "";
$db_password = "";
	
$connect = new PDO("mysql:host=$db_host;dbname=$db_name", $db_username, $db_password);
$connect-::bitis::exec("SET NAMES utf8; SET CHARSET utf8");

$baslik_url = $_GET["url"];

$statement = $connect-::bitis::prepare("SELECT * FROM forum_basliklar WHERE url = :url");
$statement-::bitis::execute(array( ":url" =::bitis:: $baslik_url ));
$baslik_detay = $statement-::bitis::fetch(PDO::FETCH_ASSOC);
if($statement-::bitis::rowCount()) {
	
header(Content-type: application/xml);
	
echo "::baslangic::rss version=2.0 xmlns:atom=http://www.w3.org/2005/Atom::bitis::
";
echo "::baslangic::channel::bitis::
";

echo "::baslangic::title::bitis::" . $baslik_detay["baslik"] . " - " . $site_name . "::baslangic::/title::bitis::
";
echo "::baslangic::description::bitis::" . $baslik_detay["aciklama"] . "::baslangic::/description::bitis::
";
echo "::baslangic::link::bitis::" . $site_protocol . "://" . $_SERVER[HTTP_HOST] . "/" . $baslik_detay["url"] . "/::baslangic::/link::bitis::
";

$statement_topics = $connect-::bitis::query("
SELECT baslik, tarih, cevap_sayisi, okunma_sayisi, kullanici, forum_konular.url as konu_url, forum_konular.code as konu_code, uyeler.url as uye_url, forum_konular.id as konu_id 
FROM forum_konular JOIN uyeler 
ON forum_konular.olusturan=uyeler.id 
WHERE ust= " . $baslik_detay["id"] . " 
ORDER BY konu_id DESC
");
$statement_topics-::bitis::execute();
$result_topics = $statement_topics-::bitis::fetchAll();

if ($result_topics && $statement_topics-::bitis::rowCount() ::bitis:: 0) {			
foreach($result_topics as $row_topics)
	{
	$konu_full_url = $site_protocol . "://" . $_SERVER[HTTP_HOST] . "/" . $baslik_url . "/" . $row_topics["konu_code"] . "-" . $row_topics["konu_url"] . ".html";
	$konu_basligi = $row_topics["baslik"];

	echo "::baslangic::item::bitis::
";
     echo "::baslangic::title::bitis::" . $konu_basligi . "::baslangic::/title::bitis::
";
     echo "::baslangic::description::bitis::" . $row_topics["kullanici"] . "::baslangic::/description::bitis::
";
     echo "::baslangic::pubDate::bitis::" . date_format(date_create($row_topics["tarih"]), "d.m.Y h:i:s") . "::baslangic::/pubDate::bitis::
";
     echo "::baslangic::link::bitis::" . $konu_full_url . "::baslangic::/link::bitis::
";
     echo "::baslangic::guid::bitis::" . $konu_full_url . "::baslangic::/guid::bitis::
";
     echo "::baslangic::atom:link href=" . $konu_full_url . " rel=self type=application/rss+xml/::bitis::
";
 	echo "::baslangic::/item::bitis::
";
 
	}
};
  
echo "::baslangic::/channel::bitis::
";
echo "::baslangic::/rss::bitis::
";
              
};

$connect=null;
?::bitis::