FROM post LEFT JOIN category ON category_id = post_category_id WHERE post_valid=1 LIMIT 10'); while ($row = mysql_fetch_object($request)) { // Creating a new feed item $rssItem = new Item(); $rssItem->setTitle($row->post_title); $rssItem->setDescription($row->post_description); $rssItem->setLink('http://www.mywebsite.com/blog/post.php?id=' . $row->post_id); $rssItem->setGuid('http://www.mywebsite.com/blog/post.php?id=' . $row->post_id, true); $rssItem->setComments('http://www.mywebsite.com/blog/post.php?id=' . $row->post_id . '#comments'); $rssItem->setAuthor($row->post_author_email, $row->post_author_name); $rssItem->setPubDate($row->post_date); $rssItem->setSource($row->post_source_uri, $row->post_source_name); $rssItem->setEnclosure('http://www.mywebsite.com/blog/images/nopicture.jpg', 2800, 'image/jpg'); $rssItem->setCategory('http://www.mywebsite.com/blog/category.php.idCat=' . $row->category_id, $row->category_name); // Add the item to the feed $rssFeed->appendItem($rssItem); } // Save the feed $rssFeed->save(); // SQL connection closing mysql_close(); // Send headers to the browser header('Content-Type: text/xml; charset=utf-8'); // Display the feed $rssFeed->display(); } catch (RSSFeedException $e) { echo $e->getErrorMessage(); }
$oRssItem->setTitle('Le cahier de textes est vide'); $oRssItem->setDescription('Rien à afficher -> Il faut toujours revoir les leçons du jour.'); $oRssItem->setLink($ServerProtocole . $_SERVER["SERVER_NAME"] . $gepiPath . '/login.php'); $oRssItem->setGuid($ServerProtocole . $_SERVER["SERVER_NAME"] . $gepiPath . '/login.php', true); if (!empty($sEmail)) { $oRssItem->setAuthor($sEmail, 'ADMIN'); } $oRssItem->setPubDate(date("Y-m-d h:i:s")); $oRssFeed->appendItem($oRssItem); $oRssItem = null; } else { // Récupération de l'email //$sEmail = getSettingValue("gepiSchoolEmail"); $sEmail = $rss_email_defaut; $oRssItem = new RSSFeedItem(); $oRssItem->setTitle('ERREUR sur le CDT'); $oRssItem->setDescription('Rien à afficher -> Il faut toujours apprendre les leçons du jour.'); $oRssItem->setLink($ServerProtocole . $_SERVER["SERVER_NAME"] . $gepiPath . '/login.php'); $oRssItem->setGuid($ServerProtocole . $_SERVER["SERVER_NAME"] . $gepiPath . '/login.php', true); if (!empty($sEmail)) { $oRssItem->setAuthor($sEmail, 'ADMIN'); } $oRssItem->setPubDate(date("Y-m-d h:i:s")); $oRssFeed->appendItem($oRssItem); $oRssItem = null; } // Sauvegarde du flux RSS $oRssFeed->save('../temp/rss-news.xml'); // Affichage sur la sortie standard header('Content-Type: text/xml; charset=UTF-8'); $oRssFeed->display();