<?php
declare(strict_types=1);
function findPost(PDO $pdo, int $id): ?array {
    $s=$pdo->prepare('SELECT id,title,body FROM posts WHERE id=:id LIMIT 1');
    $s->execute(['id'=>$id]); return $s->fetch(PDO::FETCH_ASSOC) ?: null;
}
function createPost(PDO $pdo,string $title,string $body): int {
    $s=$pdo->prepare('INSERT INTO posts(title,body,created_at) VALUES(:title,:body,NOW())');
    $s->execute(['title'=>$title,'body'=>$body]); return (int)$pdo->lastInsertId();
}
function updatePost(PDO $pdo,int $id,string $title,string $body): bool {
    $s=$pdo->prepare('UPDATE posts SET title=:title,body=:body WHERE id=:id');
    return $s->execute(['title'=>$title,'body'=>$body,'id'=>$id]);
}
function deletePost(PDO $pdo,int $id): bool {
    $s=$pdo->prepare('DELETE FROM posts WHERE id=:id'); return $s->execute(['id'=>$id]);
}
