Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): Failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /home/monara/public_html/test.athavaneng.com/themes.php on line 99
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 226
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 227
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 228
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 229
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 230
Warning: Cannot modify header information - headers already sent by (output started at /home/monara/public_html/test.athavaneng.com/themes.php:1) in /home/monara/public_html/test.athavaneng.com/themes.php on line 231
prepare("SELECT * FROM programmes WHERE slug = :slug");
$stmt->bindParam(':slug', $slug);
$stmt->execute();
$programme = $stmt->fetch(PDO::FETCH_ASSOC);
} elseif ($id > 0) {
$stmt = $conn->prepare("SELECT * FROM programmes WHERE id = :id");
$stmt->bindParam(':id', $id);
$stmt->execute();
$programme = $stmt->fetch(PDO::FETCH_ASSOC);
}
if (!$programme) {
die("Programme not found.");
}
// Get the real ID
$programme_real_id = $programme['id'];
// 3. FETCH EPISODES FROM DATABASE
$items_per_page = 21;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
if ($page < 1) $page = 1;
$offset = ($page - 1) * $items_per_page;
// --- CRITICAL FIX: Using 'programmes_id' based on your schema ---
$episodes_stmt = $conn->prepare("SELECT * FROM programmes_videos WHERE programmes_id = :id ORDER BY published_at DESC LIMIT :offset, :limit");
$episodes_stmt->bindParam(':id', $programme_real_id, PDO::PARAM_INT);
$episodes_stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
$episodes_stmt->bindParam(':limit', $items_per_page, PDO::PARAM_INT);
$episodes_stmt->execute();
$episodes = $episodes_stmt->fetchAll(PDO::FETCH_ASSOC);
// Count total episodes for pagination
$count_stmt = $conn->prepare("SELECT COUNT(*) FROM programmes_videos WHERE programmes_id = :id");
$count_stmt->bindParam(':id', $programme_real_id, PDO::PARAM_INT);
$count_stmt->execute();
$total_items = $count_stmt->fetchColumn();
$total_pages = ceil($total_items / $items_per_page);
// 4. PAGINATION URL BASE
if (!empty($slug)) {
$paginationBase = "programmes/" . htmlspecialchars($slug) . "?";
} else {
$paginationBase = "programme_detail.php?id=" . $programme_real_id . "&";
}
$page_title = $programme['title'] . " | Swarnawahini";
require 'components/header.php';
?>
Episodes
No episodes found in the database for this programme.
; ?>)