query("SELECT COUNT(*) FROM discoveries");
$total = $totalStmt->fetchColumn();
$totalPages = ceil($total / $limit);
// Fetch current page
$stmt = $pdo->prepare("SELECT title, date, excerpt, image, category, tags FROM discoveries ORDER BY date DESC LIMIT :limit OFFSET :offset");
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->bindValue(':offset', $offset, PDO::PARAM_INT);
$stmt->execute();
$discoveries = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
Recent Discoveries ( total)
Showing – on page of