OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	10/10/2024 10:20:39 AM	rwxr-xr-x
📁 assets	-	08/29/2024 12:13:46 PM	rwxr-xr-x
📁 css	-	08/29/2024 12:13:39 PM	rwxr-xr-x
📄 fetch_articles.html	317 bytes	08/29/2024 12:13:34 PM	rw-r--r--
📁 fonts	-	08/29/2024 12:13:35 PM	rwxr-xr-x
📁 images	-	08/29/2024 12:13:36 PM	rwxr-xr-x
📄 index.php	6.04 KB	08/29/2024 12:13:34 PM	rw-r--r--
📁 js	-	08/29/2024 12:13:38 PM	rwxr-xr-x
📄 l2.html	14.08 KB	08/29/2024 12:13:34 PM	rw-r--r--
📄 rss_feed_articles.php	3.19 KB	08/29/2024 12:13:34 PM	rw-r--r--
📄 rss_feed_store.php	3.77 KB	08/29/2024 12:13:34 PM	rw-r--r--
📁 scss	-	08/29/2024 12:13:40 PM	rwxr-xr-x

Editing: index.php

<?php
// Include the SimplePie library
require_once('../inc/simplepie/autoloader.php');

$servername = "139.59.38.164";
$dbname = "reader";
$username = "root";
$password = "newstart";

// Create a MySQLi connection
$mysqli = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($mysqli->connect_error) {
    die('Connection failed: ' . $mysqli->connect_error);
}

// Check if the RSS URL is submitted
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['rss_url']) && !empty($_POST['rss_url'])) {
    $rss_url = $_POST['rss_url'];

// Create a new SimplePie object
    $feed = new SimplePie\SimplePie();
    $feed->set_feed_url($rss_url);
    $feed->init();

// Check for errors
    if ($feed->error()) {
        echo 'Error: ' . $feed->error();
        exit;
    }

// Prepare SQL statement for inserting or updating data
    $stmt = $mysqli->prepare('REPLACE INTO rss_feeds_url (rss_url, rss_title, rss_description, rss_publisher, rss_image, rss_language) VALUES ( ?, ?, ?, ?, ?, ?)');

// Fetch feed details
    $rss_title = $feed->get_title();
    $rss_description = $feed->get_description();
    $rss_publisher = $feed->get_title(); // Assuming publisher is the feed title
    $rss_image = $feed->get_image_url();
    $rss_language = $feed->get_language();

// Bind parameters and execute
    $stmt->bind_param('ssssss', $rss_url, $rss_title, $rss_description, $rss_publisher, $rss_image, $rss_language);
    $stmt->execute();

echo 'Feed metadata has been processed and stored in the database.';
}

// Fetch all RSS feeds from the database
$result = $mysqli->query('SELECT * FROM rss_feeds_url');

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <title>RSS Feed Processor</title>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <style>
        #loading {
            display: none;
            /* Hide the loading icon initially */
        }
    </style>
</head>

<body>
    <h1>RSS Feed Processor</h1>

<form action="" method="post">
        <label for="rss_url">Enter RSS Feed URL:</label>
        <input type="text" id="rss_url" name="rss_url" required>
        <input type="submit" value="Process Feed">
    </form>

<h2>Stored RSS Feeds</h2>
    <?php if ($result->num_rows > 0): ?>

<div style="overflow: auto; height: 50vh;">
            <table border="1">
                <thead>
                    <tr>
                        <th>RSS URL</th>
                        <th>Title</th>
                        <th>Description</th>
                        <th>Publisher</th>
                        <th>Image</th>
                        <th>Category</th>
                        <th>Language</th>
                    </tr>
                </thead>
                <tbody>
                    <?php while ($row = $result->fetch_assoc()): ?>
                        <tr>
                            <td><?php echo htmlspecialchars($row['rss_url']); ?></td>
                            <td><?php echo htmlspecialchars($row['rss_title']); ?></td>
                            <td><?php echo htmlspecialchars($row['rss_description']); ?></td>
                            <td><?php echo htmlspecialchars($row['rss_publisher']); ?></td>
                            <td><?php if (!empty($row['rss_image'])): ?><img src="<?php echo htmlspecialchars($row['rss_image']); ?>" alt="Feed Image" style="max-width:100px;"><?php endif; ?></td>
                            <td><?php echo htmlspecialchars($row['rss_category']); ?></td>
                            <td><?php echo htmlspecialchars($row['rss_language']); ?></td>
                        </tr>
                    <?php endwhile; ?>
                </tbody>
            </table>
        </div><br><br>
        <div id="updateRSSFeed">

</div>
        <button onclick="updateRSS()">Update</button>
        <div id="loading">Loadingggg...</div>

<?php else: ?>
        <p>No RSS feeds found in the database.</p>
    <?php endif; ?>

<?php
    // Free the result set
    $result->free();

// Close the MySQLi connection
    $mysqli->close();
    ?>
</body>

$.ajax({
            url: 'rss_feed_articles.php',
            type: 'GET', // Use GET or POST depending on your needs
            success: function(response) {
                // Hide the loading icon
                $('#loading').hide();

// Display the plain text response
                $('#updateRSSFeed').text(response);
            },
            error: function(xhr, status, error) {
                // Hide the loading icon
                $('#loading').hide();

// Handle errors
                $('#updateRSSFeed').text('AJAX request failed: ' + error);
            }
        });
    }

$(document).ready(function() {
        $('#submit-button').click(function() {
            // Get the value from the input field
            var name = $('#name-input').val();

// Perform AJAX request
            $.ajax({
                url: 'process.php',
                type: 'POST',
                data: {
                    name: name
                },
                dataType: 'json',
                success: function(response) {
                    // Handle successful response
                    if (response.status === 'success') {
                        $('#response').text(response.message);
                    } else {
                        $('#response').text('Error: ' + response.message);
                    }
                },
                error: function(xhr, status, error) {
                    // Handle errors
                    $('#response').text('AJAX request failed: ' + error);
                }
            });
        });
    });
</script>

</html>