<?php
declare(strict_types=1);
function searchArticles(PDO $pdo,string $query,int $limit=20): array {
    $query=trim($query); if (mb_strlen($query)<3) return [];
    $limit=min(50,max(1,$limit));
    $s=$pdo->prepare('SELECT id,title,slug,excerpt FROM articles WHERE status=:status AND (title LIKE :q OR excerpt LIKE :q) ORDER BY published_at DESC LIMIT :lim');
    $s->bindValue(':status','published'); $s->bindValue(':q','%'.$query.'%'); $s->bindValue(':lim',$limit,PDO::PARAM_INT);
    $s->execute(); return $s->fetchAll(PDO::FETCH_ASSOC);
}
