I want to parse an existing RSS feed from another website with php and then store certain parts of it in a mysql database.
I'm very competent with php and mysql but have never worked with rss feeds before, where should i start?
cheers!
Short Version: ( NEW )
demo: http://so.lucafilosofi.com/get-rss-feed-into-php-array-possible/
$feed = 'http://stackoverflow.com/opensearch.xml';
$feed_to_array = (array) simplexml_load_file($feed);
//OR $feed_to_array = (array) new SimpleXmlElement( file_get_contents($feed) );
print_r($feed_to_array);
//output
Array
(
[ShortName] => Stack Overflow
[Description] => Search Stack Overflow: Q&A for professional and enthusiast programmers
[InputEncoding] => UTF-8
[Image] => http://sstatic.net/stackoverflow/img/favicon.ico
[Url] => SimpleXMLElement Object
(
[@attributes] => Array
(
[type] => text/html
[method] => get
[template] => http://stackoverflow.com/search?q={searchTerms}
)
)
)
Long Version: ( OLD )
<?php
$rss_tags = array(
'title',
'link',
'guid',
'comments',
'description',
'pubDate',
'category',
);
$rss_item_tag = 'item';
$rss_url = 'http://www.webaddict.info/feeds/news.xml';
$rssfeed = rss_to_array($rss_item_tag, $rss_tags, $rss_url);
echo '<pre>';
print_r($rssfeed);
function rss_to_array($tag, $array, $url) {
$doc = new DOMdocument();
$doc->load($url);
$rss_array = array();
$items = array();
foreach($doc-> getElementsByTagName($tag) AS $node) {
foreach($array AS $key => $value) {
$items[$value] = $node->getElementsByTagName($value)->item(0)->nodeValue;
}
array_push($rss_array, $items);
}
return $rss_array;
}
?>
If others come past, an end-to-end very simple free code example of this is on;
The best Feed consumer library in PHP is RSSClient[1]
