studioAura
12/14/2015 - 10:24 AM

Импорт RSS, XML в БД через MODx API

Импорт RSS, XML в БД через MODx API

<?php
    $RSSS = array();
    $RSSS[] = 'http://www.site.ru/news/rss/';
    $RSSS[] = 'http://www.site.ru/xml/';
foreach($RSSS AS $RSS) {    
    $rss = simplexml_load_file($RSS);
     
        foreach($rss->channel->item as $item) {
             
            echo $item->title;
            $result = mysql_fetch_object($modx->db->query("SELECT count(*) as CNT FROM modx_rmod_news WHERE title = '".$item->title."'"));
            if(!$result->CNT) {
                $fields = array (
                                'title' => $item->title,
                                'news_body' => $item->description,
                                'news_date' => $item->pubDate,
                                'autor' => $item->author,
                                'full_link' => 1,
                                'publish' => 1,
                                'catid' => 1,
                    );
                $modx->db->insert($fields, $modx->getFullTableName(rmod_news));
            } else {
                //$modx->db->query("UPDATE ".$modx->getFullTableName(rmod_news)." SET ".$fields." WHERE title = '".$item->title."'";
            }           
        }
}
?>