Este el codigo PHP
Código:
GRACIAS DE ANTEMANO! <?php
$ch = curl_init($argv[1]);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$rss = new SimpleXMLElement(curl_exec($ch));
// fill these next two rows in!
$dbLink = mysql_connect('localhost', 'USUARIO BD', 'PASS BD');
mysql_select_db('NOMBRE BD', $dbLink);
foreach($rss->channel->item as $blah) {
$title = mysql_real_escape_string($blah->title);
$desc = mysql_real_escape_string($blah->description);
$link = mysql_real_escape_string($blah->link);
$channel = mysql_real_escape_string($rss->channel->link);
$pubDate = date("Y-m-d H:i:s", strtotime($blah->pubDate));
$query = "REPLACE INTO feed (title,description,link,channel,pubDate)
VALUES ('{$title}', '{$desc}', '{$link}', '{$channel}', '{$pubDate}')";
if(!mysql_query($query, $dbLink)) {
echo "an error has occured - ".mysql_error()."n";
exit();
}
}
Usage: php filename.php http://example.org/path/to/rss.xml


