Mappa del Sito
Trova facilmente quello che stai cercando nel nostro sito
Pagine Principali
Articoli del Blog
-
prepare("
SELECT title, slug, published_at
FROM blog_posts
WHERE status = 'published'
ORDER BY published_at DESC
LIMIT 20
");
$stmt->execute();
$articoli_recenti = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($articoli_recenti as $articolo) {
echo '
- '; echo ''; echo htmlspecialchars($articolo['title']); echo ''; echo ' (' . date('d/m/Y', strtotime($articolo['published_at'])) . ')'; echo ' '; } } catch (PDOException $e) { echo '
- Articoli temporaneamente non disponibili '; } ?>
Categorie Blog
-
prepare("
SELECT name, slug, COUNT(pc.post_id) as post_count
FROM blog_categories c
LEFT JOIN blog_post_categories pc ON c.id = pc.category_id
LEFT JOIN blog_posts p ON pc.post_id = p.id AND p.status = 'published'
GROUP BY c.id, c.name, c.slug
ORDER BY c.name
");
$stmt->execute();
$categorie = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($categorie as $categoria) {
echo '
- '; echo ''; echo htmlspecialchars($categoria['name']); echo ''; echo ' (' . $categoria['post_count'] . ' articoli)'; echo ' '; } } catch (PDOException $e) { echo '
- Categorie temporaneamente non disponibili '; } ?>
Tag Popolari
-
prepare("
SELECT t.name, t.slug, COUNT(pt.post_id) as post_count
FROM blog_tags t
LEFT JOIN blog_post_tags pt ON t.id = pt.tag_id
LEFT JOIN blog_posts p ON pt.post_id = p.id AND p.status = 'published'
GROUP BY t.id, t.name, t.slug
HAVING post_count > 0
ORDER BY post_count DESC, t.name
LIMIT 15
");
$stmt->execute();
$tags = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($tags as $tag) {
echo '
- '; echo ''; echo htmlspecialchars($tag['name']); echo ''; echo ' (' . $tag['post_count'] . ' articoli)'; echo ' '; } } catch (PDOException $e) { echo '
- Tag temporaneamente non disponibili '; } ?>