query("SELECT COUNT(*) FROM teledramas");
$total_items = $total_stmt->fetchColumn();
$stmt = $conn->prepare("SELECT * FROM teledramas 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();
$teledramas = $stmt->fetchAll(PDO::FETCH_ASSOC);
} elseif ($conn instanceof mysqli) {
$result = $conn->query("SELECT COUNT(*) as total FROM teledramas");
$row = $result->fetch_assoc();
$total_items = $row['total'] ?? 0;
$stmt = $conn->prepare("SELECT * FROM teledramas LIMIT ? OFFSET ?");
$stmt->bind_param("ii", $items_per_page, $offset);
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$teledramas[] = $row;
}
}
$total_pages = ceil($total_items / $items_per_page);
// Function to get YouTube thumbnail
?>
Teledramas | Swarnawahini