OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
3-31-025chanakya
/
education-podcasts
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
03/31/2025 06:36:42 AM
rwxr-xr-x
📄
database.sql
592 bytes
03/31/2025 06:36:42 AM
rw-r--r--
📄
fetchRSS.php
950 bytes
03/31/2025 06:36:42 AM
rw-r--r--
📁
includes
-
03/31/2025 06:36:42 AM
rwxr-xr-x
📄
index.php
1.09 KB
03/31/2025 06:36:42 AM
rw-r--r--
📄
podcast.php
2.05 KB
03/31/2025 06:36:42 AM
rw-r--r--
📄
style.css
0 bytes
03/31/2025 06:36:42 AM
rw-r--r--
📄
upload.php
683 bytes
03/31/2025 06:36:42 AM
rw-r--r--
📁
uploads
-
03/31/2025 06:36:42 AM
rwxr-xr-x
Editing: podcast.php
Close
<?php include "includes/db.php"; if (!isset($_GET['id']) || !is_numeric($_GET['id'])) { die("Invalid podcast ID."); } $podcast_id = $_GET['id']; // Fetch podcast details $sql = "SELECT title FROM rss_feeds WHERE id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $podcast_id); $stmt->execute(); $result = $stmt->get_result(); $podcast = $result->fetch_assoc(); if (!$podcast) { die("Podcast not found."); } // Fetch episodes $sql = "SELECT * FROM episodes WHERE feed_id = ? ORDER BY published_at DESC"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $podcast_id); $stmt->execute(); $result = $stmt->get_result(); $episodes = $result->fetch_all(MYSQLI_ASSOC); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title><?= htmlspecialchars($podcast['title']) ?> - Episodes</title> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> </head> <body class="container"> <h2 class="mt-4"><?= htmlspecialchars($podcast['title']) ?> - Episodes</h2> <a href="index.php" class="btn btn-secondary">Back to Podcasts</a> <div class="row mt-4"> <?php foreach ($episodes as $episode): ?> <div class="col-md-12"> <div class="card mb-3"> <div class="card-body"> <h5><a href="<?= $episode['link'] ?>" target="_blank"><?= htmlspecialchars($episode['title']) ?></a></h5> <p><?= htmlspecialchars($episode['description']) ?></p> <?php if (!empty($episode['audio_url'])): ?> <audio controls> <source src="<?= $episode['audio_url'] ?>" type="audio/mpeg"> </audio> <?php endif; ?> <small class="text-muted">Published: <?= $episode['published_at'] ?></small> </div> </div> </div> <?php endforeach; ?> </div> </body> </html>