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
query("SELECT COUNT(*) FROM programmes");
$total_items = $total_stmt->fetchColumn();
$stmt = $conn->prepare("SELECT * FROM programmes ORDER BY sort_order ASC LIMIT :limit OFFSET :offset");
$stmt->bindValue(':limit', $items_per_page, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$programmes = $stmt->fetchAll(PDO::FETCH_ASSOC);
} elseif (isset($conn) && $conn instanceof mysqli) {
$result = $conn->query("SELECT COUNT(*) as total FROM programmes");
$row = $result->fetch_assoc();
$total_items = $row['total'] ?? 0;
$stmt = $conn->prepare("SELECT * FROM programmes ORDER BY sort_order ASC LIMIT ? OFFSET ?");
$stmt->bind_param("ii", $items_per_page, $offset);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$programmes[] = $row;
}
}
$total_pages = ceil($total_items / $items_per_page);
// 2. EPISODE COUNTS
$counts = [];
$ids = array_column($programmes, 'id');
if (!empty($ids)) {
if (isset($conn) && $conn instanceof PDO) {
$placeholders = implode(',', array_fill(0, count($ids), '?'));
$stmt = $conn->prepare("SELECT programmes_id, COUNT(*) AS cnt FROM programmes_videos WHERE programmes_id IN ($placeholders) GROUP BY programmes_id");
$stmt->execute($ids);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $r) $counts[$r['programmes_id']] = (int)$r['cnt'];
} elseif (isset($conn) && $conn instanceof mysqli) {
$safeIds = array_map('intval', $ids);
$in = implode(',', $safeIds);
$res = $conn->query("SELECT programmes_id, COUNT(*) AS cnt FROM programmes_videos WHERE programmes_id IN ($in) GROUP BY programmes_id");
if ($res) {
while ($r = $res->fetch_assoc()) $counts[$r['programmes_id']] = (int)$r['cnt'];
}
}
}
?>
Programmes | Swarnawahini