OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	11/07/2024 07:55:42 AM	rwxr-xr-x
📁 assets	-	08/15/2024 03:38:36 AM	rwxr-xr-x
📄 bbrss_feed_articles.php	4.58 KB	11/04/2024 12:39:16 PM	rw-r--r--
📁 css	-	08/15/2024 03:38:35 AM	rwxr-xr-x
📄 db_connect.php	261 bytes	11/06/2024 10:21:02 AM	rw-r--r--
📄 eSamudaay_rss_feed_articles.php	4.37 KB	10/01/2024 06:24:41 AM	rw-r--r--
📄 fetch_articles.html	317 bytes	08/15/2024 03:38:31 AM	rw-r--r--
📁 fonts	-	08/15/2024 03:38:32 AM	rwxr-xr-x
📁 images	-	08/15/2024 03:38:33 AM	rwxr-xr-x
📄 index.php	6.04 KB	08/15/2024 03:47:03 AM	rw-r--r--
📁 js	-	09/26/2024 05:03:24 AM	rwxr-xr-x
📄 l2.html	14.08 KB	08/15/2024 03:38:31 AM	rw-r--r--
📄 rss_feed_articles.php	8.54 KB	11/06/2024 10:45:28 AM	rw-r--r--
📄 rss_feed_store.php	3.77 KB	08/15/2024 03:38:31 AM	rw-r--r--
📁 scss	-	08/15/2024 03:38:35 AM	rwxr-xr-x
📄 test4.php	7.03 KB	11/06/2024 11:07:16 AM	rw-r--r--
📄 test5.php	4.6 KB	11/06/2024 10:03:04 AM	rw-r--r--

Editing: test5.php

// require_once('../inc/simplepie/autoloader.php');
require_once('/var/www/reader/inc/simplepie/autoloader.php');

echo "<pre>";
print_r(new SimplePie);
echo "</pre>";
die();

function fetchAndInsertRssFeeds($conn)
{
    // Fetch RSS feed URLs from the database
    $sql = 'SELECT rss_id, rss_url FROM rss_feeds_url';
    $result = $conn->query($sql);

// Check if the query was successful
    if (!$result) {
        die('Query Error: ' . $conn->error);
    }

// Loop through each RSS feed URL
    while ($row = $result->fetch_assoc()) {
        $feedUrl = $row['rss_url'];
        $feedId = $row['rss_id'];

// Initialize SimplePie
        $rss = new SimplePie();
        $rss->set_feed_url($feedUrl);
        $rss->enable_cache(false);
        $rss->init();
        $rss->handle_content_type();

// Check for errors
        if ($rss->error()) {
            echo "Error fetching feed: " . $rss->error();
            continue;
        }

// Loop through each item in the RSS feed
        foreach ($rss->get_items() as $item) {
            $title = $conn->real_escape_string($item->get_title());
            $url = $conn->real_escape_string($item->get_permalink());
            $description = $conn->real_escape_string($item->get_description());
            $content = $conn->real_escape_string($item->get_content());
            $author = $conn->real_escape_string($item->get_author() ? $item->get_author()->get_name() : '');
            $image = $conn->real_escape_string($item->get_enclosure() ? $item->get_enclosure()->get_link() : '');
            $date = $conn->real_escape_string($item->get_date('Y-m-d H:i:s'));

// Process categories
            $categories = $item->get_categories();
            if ($categories && is_array($categories)) {
                $categoryNames = array_map(function ($cat) {
                    return htmlspecialchars($cat->get_label());
                }, $categories);
                $categoryString = implode(', ', $categoryNames);
            } else {
                $categoryString = ''; // Or you can set it to an empty string ''
            }

// Prepare SQL to insert article into the database
            $sql = 'INSERT IGNORE INTO rss_feeds_articles (feed_id, url, title, description, content, author, image, category, date) 
                    VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)';
            $stmt = $conn->prepare($sql);
            $stmt->bind_param('issssssis', $feedId, $url, $title, $description, $content, $author, $image, $categoryString, $date);

// Execute the query
            if (!$stmt->execute()) {
                echo "Error inserting article: " . $stmt->error;
            }

$stmt->close();
        }
    }
}

function display_rss_feed($url)
{
    // Initialize SimplePie
    $rss = new SimplePie();
    
    $rss->set_feed_url($url);
    $rss->enable_cache(false);
    $rss->init();
    $rss->handle_content_type();

// Check for errors
    if ($rss->error()) {
        echo "Error fetching feed: " . $rss->error();
        exit();
    }
    foreach ($rss->get_items() as $item) {
        $title = $item->get_title();
        $url = $item->get_permalink();
        $description = $item->get_description();
        $content = $item->get_content();
        $author = $item->get_author() ? $item->get_author()->get_name() : '';
        $image = $item->get_enclosure() ? $item->get_enclosure()->get_link() : '';
        $date = $item->get_date('Y-m-d H:i:s');

// Process categories
        $categories = $item->get_categories();
        if ($categories && is_array($categories)) {
            $categoryNames = array_map(function ($cat) {
                return htmlspecialchars($cat->get_label());
            }, $categories);
            $categoryString = implode(', ', $categoryNames);
        } else {
            $categoryString = ''; // Or you can set it to an empty string ''
        }

echo "</pre> ";
 echo "Title: " . $title . " ";
 echo "URL: " . $url . " ";
 echo "Description: " . $description . " ";
 echo "Content: " . $content . " ";
 echo "Author: " . $author . " ";
 echo "Image Link: " . $image . " ";
 echo "Date: " . $date . " Categories: <pre>";
 print_r($categories);
 echo "</pre> Category Names: <pre>";
 print_r($categoryNames);
 echo "</pre> Category String: ";
 echo $categoryString . " ";
 }
}

display_rss_feed("https://feeds.a.dj.com/rss/RSSWorldNews.xml");