prepare("SELECT COUNT(*) FROM articles WHERE $where"); $total->execute($params); $totalCount = (int)$total->fetchColumn(); $totalPages = (int)ceil($totalCount / BLOG_PER_PAGE); $stmt = $db->prepare("SELECT id, slug, title, excerpt, category, cover_image, reading_time, views, featured, published_at FROM articles WHERE $where ORDER BY featured DESC, published_at DESC LIMIT :limit OFFSET :offset"); $stmt->bindValue(':limit', BLOG_PER_PAGE, PDO::PARAM_INT); $stmt->bindValue(':offset', $offset, PDO::PARAM_INT); foreach ($params as $k => $v) $stmt->bindValue($k, $v); $stmt->execute(); $articles = $stmt->fetchAll(); // Categories with counts $cats = $db->query("SELECT category, COUNT(*) as cnt FROM articles WHERE status='published' GROUP BY category ORDER BY cnt DESC")->fetchAll(); ?> Blog — Lumière Blanche
Sagesse & Lumière

Le Blog

Articles spirituels, guidance et explorations de l'âme

Catégorie : ✕ Tout voir
✦

Aucun article dans cette catégorie pour le moment.

Voir tous les articles
1): ?>