This code implements an RSS aggregator website using PHP. It requires the use of a database to hold information about RSS feeds.
The code uses SimplePie to collect RSS feeds that are then tucked into the database.
This code is currently used by the site http://aggregation.co
CREATE TABLE feeds (
id int(11) NOT NULL,
displayColumn int(11) NOT NULL,
link varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE items (
id int(11) NOT NULL,
feedTitle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
feedLink varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
itemTitle varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
itemPubDate varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
itemLink varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
itemDesc mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8