OXIESEC PANEL
- Current Dir:
/
/
var
/
www
/
3-31-025chanakya
/
education-podcasts
/
includes
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
03/31/2025 06:36:42 AM
rwxr-xr-x
📄
db.php
326 bytes
03/31/2025 06:36:42 AM
rw-r--r--
📄
fetchPodcasts.php
412 bytes
03/31/2025 06:36:42 AM
rw-r--r--
📄
opmlParser.php
508 bytes
03/31/2025 06:36:42 AM
rw-r--r--
Editing: fetchPodcasts.php
Close
<?php include "db.php"; $sql = "SELECT rss_feeds.id, rss_feeds.title, COUNT(episodes.id) AS total_episodes FROM rss_feeds LEFT JOIN episodes ON rss_feeds.id = episodes.feed_id GROUP BY rss_feeds.id, rss_feeds.title ORDER BY rss_feeds.title ASC"; $result = $conn->query($sql); $podcasts = []; while ($row = $result->fetch_assoc()) { $podcasts[] = $row; } ?>