//
// RSS fetch
//
try {
$reader = new Reader();
$resource = $reader->download($source_url);
$parser = $reader->getParser($resource->getUrl(), $resource->getContent(), $resource->getEncoding());
$feed = $parser->execute();
} catch (Exception $e) {
echo "RSS Fetch Error: " . $e->getMessage();
exit;
}
//
// New RSS feeds goes to our database
//
$n_articles = (int) $db->fetchColumn("\n SELECT \n count(id)\n FROM\n jobarticles \n WHERE \n source_id = :source_id\n ", array('source_id' => $source_id));
if (!$n_articles) {
// No articles from this resoure
// add every article to our database
echo sprintf("No articles from there resource in our DB. Adding %d articles<br>", count($feed->items));
// Latest date is very early date
$latest_date = '2001-00-00';
} else {
// get the latest added article date
$latest_date = $db->fetchColumn("\n SELECT\n date\n FROM\n jobarticles\n WHERE \n source_id = :source_id\n ORDER BY date DESC\n LIMIT 1\n ", array('source_id' => $source_id));
echo sprintf("We have some articles already in our DB. \n Adding articles younger than %s<br>", $latest_date);
}
//
// Loop through new articles
//
$fetched = 0;
