prepare("SELECT * FROM programmes WHERE id = :id"); $stmt->bindParam(':id', $id, PDO::PARAM_INT); $stmt->execute(); $programme = $stmt->fetch(PDO::FETCH_ASSOC); if (!$programme) { die("Programme not found."); } // Pagination setup $items_per_page = 21; $page = isset($_GET['page']) ? (int)$_GET['page'] : 1; if ($page < 1) { $page = 1; } $offset = ($page - 1) * $items_per_page; // Fetch programme episodes from database $episodes_stmt = $conn->prepare("SELECT * FROM programmes_videos WHERE programmes_id = :id ORDER BY published_at DESC LIMIT :offset, :limit"); $episodes_stmt->bindValue(':id', $id, PDO::PARAM_INT); $episodes_stmt->bindValue(':offset', $offset, PDO::PARAM_INT); $episodes_stmt->bindValue(':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', $id, PDO::PARAM_INT); $count_stmt->execute(); $total_items = $count_stmt->fetchColumn(); $total_pages = ceil($total_items / $items_per_page); // Page title $page_title = $programme['title'] . " | TV Channel"; require 'components/header.php'; ?>

Episodes

No episodes found for this programme.

1): ?>