<?php
declare(strict_types=1);
function paginate(PDO $pdo,int $page,int $perPage=20): array {
    $perPage=min(100,max(1,$perPage)); $total=(int)$pdo->query('SELECT COUNT(*) FROM articles')->fetchColumn();
    $pages=max(1,(int)ceil($total/$perPage)); $page=min(max(1,$page),$pages); $offset=($page-1)*$perPage;
    $s=$pdo->prepare('SELECT id,title,slug FROM articles ORDER BY id DESC LIMIT :lim OFFSET :off');
    $s->bindValue(':lim',$perPage,PDO::PARAM_INT); $s->bindValue(':off',$offset,PDO::PARAM_INT); $s->execute();
    return ['items'=>$s->fetchAll(PDO::FETCH_ASSOC),'page'=>$page,'pages'=>$pages,'total'=>$total];
}
