prepare("SELECT * FROM teledramas WHERE id = :id"); $stmt->bindParam(':id', $id); $stmt->execute(); $teledrama = $stmt->fetch(PDO::FETCH_ASSOC); if (!$teledrama) { die("Teledrama not found."); } // 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; $episodes_stmt = $conn->prepare("SELECT * FROM teledrama_videos WHERE teledrama_id = :id ORDER BY published_at DESC LIMIT :offset, :limit"); $episodes_stmt->bindParam(':id', $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 teledrama_videos WHERE teledrama_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); // Set page title $page_title = $teledrama['title'] . " | TV Channel"; require 'components/header.php'; ?>

Episodes

<?php echo htmlspecialchars($episode['title']); ?>

No episodes found for this teledrama.

1): ?>