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(); }
if ($loop == 0) { $oRssItem->setEnclosure($url_doc_courant, filesize($items["cdt_dev"][$a]["doc_joint"][$loop]['emplacement']), $mimeType); } else { $tab_autres_docs_joints[] = array($url_doc_courant, filesize($items["cdt_dev"][$a]["doc_joint"][$loop]['emplacement']), $mimeType); } } } } $oRssItem->setDescription($contenu_courant); $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", $items["cdt_dev"][$a]["date_ct"])); $oRssFeed->appendItem($oRssItem); $oRssItem = null; if (count($tab_autres_docs_joints) > 0) { for ($loop = 0; $loop < count($tab_autres_docs_joints); $loop++) { $oRssItem = new RSSFeedItem(); $oRssItem->setTitle($donnees["description"] . ' - Pour le ' . date("d-m-Y", $items["cdt_dev"][$a]["date_ct"])); $contenu_courant = '-> Travail donné par ' . $prof . ' : ' . $items["cdt_dev"][$a]["contenu"]; $contenu_courant = '-> Document joint'; $oRssItem->setEnclosure($tab_autres_docs_joints[$loop][0], $tab_autres_docs_joints[$loop][1], $tab_autres_docs_joints[$loop][2]); $oRssItem->setDescription($contenu_courant); $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", $items["cdt_dev"][$a]["date_ct"]));