Advanced Search

Return to Snippet

Revision: 69827
at September 16, 2015 01:37 by COBOLdinosaur
Initial Code 
// your DB connection goes here
define('LINKBASE','http://yoursite.com/');
$sql=$yourDB->query("SELECT pageTitle,pageLink,pageDesc,pageDate FROM pageTab ORDER BY pageDate DESC LIMIT 10");
$cnt=$sql->rowCount();  
// NOW WE NEED TO DO THE HEADING FOR THE FEED
$feedMainLink=LINKBASE.'feedname.xml';
$mainDate=date("D, d M Y H:i:s O"); // format the date to the rss 2.0 standard
$rssfeed='<?xml version="1.0" encoding="UTF-8"?>';
// WE'LL USE HEREDOC TO BUILD THE HEADING LINES
$rssfeed.=<<<HEAD
    <rss version="2.0">
    <channel>
        <title>TITLE of the FEED</title>
        <link>$feedMainLink</link>
        <description>A selection of the latest articles, editorials and script snippets</description>
        <pubDate>$mainDate</pubDate>
HEAD;
// NOW WE CAN LOOP OUT THE ITEMS
    $rowBlock=$sql->fetch(PDO::FETCH_ASSOC);    
    for ($i=0;$i<$cnt;$i++);
        {
            $row=$rowBlock[$i];
            $PgLink=LINKBASE.$row['pageLink'];
            $pubDate=date("D, d M Y H:i:s O", strtotime($row['pageDate']));
    $rssfeed.=<<<ITEM
        <item>
            <title>{$row['pageTitle']}</title>
            <description>{$row['pageDesc']}...</description>
            <link>$pageLink</link>
            <pubDate>$pubDate</pubDate>
        </item>
ITEM;
        }
    }
$rssfeed .= '</channel>';
$rssfeed .= '</rss>';
file_put_contents('feedname.xml', $rssfeed);
Initial URL 
http://coboldinosaur.com/pages/creating-rss-feeds-for-your-site.html
Initial Description 
If you syndicate your content with an RSS feed it can help to drive additional traffic to the content pages.
Initial Title 
Creating an RSS Feed From Your Site
Initial Tags 
php, xml
Initial Language 
PHP