query('SELECT COUNT(*) FROM articles');
$total = (int)$totalStmt->fetchColumn();
$pages = max(1, ceil($total / $perPage));
$stmt = $pdo->prepare('SELECT id, titre, contenu, date_creation FROM articles ORDER BY date_creation DESC LIMIT :lim OFFSET :off');
$stmt->bindValue(':lim', $perPage, PDO::PARAM_INT);
$stmt->bindValue(':off', $offset, PDO::PARAM_INT);
$stmt->execute();
$articles = $stmt->fetchAll();
?>
CMS Simplifié - Accueil
Articles
Aucun article publié.
...
Publié le