prepare("SELECT id, title, date, excerpt, image, category, tags FROM discoveries ORDER BY date DESC"); $stmt->execute(); $allDiscoveries = $stmt->fetchAll(PDO::FETCH_ASSOC); // Randomly select 3 for Featured $featuredDiscoveries = []; if (count($allDiscoveries) >= 3) { $randomKeys = array_rand($allDiscoveries, 3); foreach ((array) $randomKeys as $key) { $featuredDiscoveries[] = $allDiscoveries[$key]; unset($allDiscoveries[$key]); } } // Slice the remaining discoveries for pagination $recentDiscoveries = array_slice(array_values($allDiscoveries), $offset, $limit); $total = count($allDiscoveries); $totalPages = ceil($total / $limit); // Fetch dynamic menu categories $menuStmt = $pdo->query("SELECT name, slug FROM categories ORDER BY name ASC"); $categories = $menuStmt->fetchAll(PDO::FETCH_ASSOC); ?> Pattern Field Theory Discoveries

Featured Discoveries

Dive into recent breakthroughs and insights.

Recent Posts

' . htmlspecialchars($discovery['category']) . ''; } if (!empty($discovery['tags'])) { $tags = explode(',', $discovery['tags']); foreach ($tags as $tag) { echo '' . htmlspecialchars(trim($tag)) . ''; } } ?>

Spotlight

Special Focus

Insightful highlights from our community.

This section can be populated dynamically later as needed, such as special features or editor’s picks.