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);
} catch (PDOException $e) {
error_log("Database error in programme_list.php: " . $e->getMessage());
$programmes = [];
$total_items = 0;
}
$total_pages = ceil($total_items / $items_per_page);
?>
Programmes | Swarnawahini