<?php
include('admin/inc/config.php');

$rssTitle = "Google Publisher RSS";
$rssDescription = "Google Publisher için oluşturulan RSS beslemesi";
$rssFeed = '<?xml version="1.0" encoding="UTF-8"?>' . PHP_EOL;
$rssFeed .= '<rss version="2.0">' . PHP_EOL;
$rssFeed .= '<channel>' . PHP_EOL;
$rssFeed .= '<title>' . $rssTitle . '</title>' . PHP_EOL;
$rssFeed .= '<description>' . $rssDescription . '</description>' . PHP_EOL;
$query = "SELECT * FROM blog WHERE tur = 'blog' ORDER BY olusturmazamani DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$articles = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($articles as $article) {
$title = $article['baslik'];
$link = 'https://' . $_SERVER['HTTP_HOST'] . '/' . $article['seolink'];
$description = $article['icerik'];
$pubDate = date("r", strtotime($article['olusturmazamani']));
$image = 'https://' . $_SERVER['HTTP_HOST'] . '/' . preg_replace('/..//', '', $article['resim']);

$rssFeed .= '<item>' . PHP_EOL;
$rssFeed .= '<title>' . $title . '</title>' . PHP_EOL;
$rssFeed .= '<link>' . $link . '</link>' . PHP_EOL;
$rssFeed .= '<description>' . htmlspecialchars($description, ENT_XML1 | ENT_COMPAT, 'UTF-8') . '</description>' . PHP_EOL;
$rssFeed .= '<pubDate>' . $pubDate . '</pubDate>' . PHP_EOL;
$rssFeed .= '<image>' . $image . '</image>' . PHP_EOL;
$rssFeed .= '</item>' . PHP_EOL;
}
$rssFeed .= '</channel>' . PHP_EOL;
$rssFeed .= '</rss>' . PHP_EOL;
header('Content-Type: application/xml; charset=utf-8');
echo $rssFeed;
?>