Editing and deleting posts

array { ... }. Inside, write $stmt = $pdo->prepare("SELECT id, title, content, author FROM posts WHERE id = :id");, run it with $stmt->execute([":id" => $id]); and return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];. Write function updatePost(PDO $pdo, int $id, string $title, string $content, string $author): int { ... }. Inside, call $pdo->prepare("UPDATE posts SET title = :title, content = :content, author = :author WHERE id = :id");, run it with execute([...]) and return $stmt->rowCount();. Write function deletePost(PDO $pdo, int $id): int { ... }. Inside, call $pdo->prepare("DELETE FROM posts WHERE id = :id");, run it with execute([":id" => $id]); and return $stmt->rowCount();.
Example solution:
<?php
// Blog project: BlogPost + setupDatabase + createPost + getAllPosts + getPost + updatePost + deletePost

class BlogPost {
    public string $title = "";
    public string $content = "";
    public string $author = "";
}

function setupDatabase(): PDO {
    $pdo = new PDO("sqlite::memory:");
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->exec("CREATE TABLE posts (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        title TEXT NOT NULL,
        content TEXT NOT NULL,
        author TEXT NOT NULL
    )");
    return $pdo;
}

function createPost(PDO $pdo, string $title, string $content, string $author): int {
    $stmt = $pdo->prepare("INSERT INTO posts (title, content, author) VALUES (:title, :content, :author)");
    $stmt->execute([":title" => $title, ":content" => $content, ":author" => $author]);
    return (int) $pdo->lastInsertId();
}

function getAllPosts(PDO $pdo): array {
    $stmt = $pdo->query("SELECT id, title, content, author FROM posts ORDER BY id");
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

function getPost(PDO $pdo, int $id): array {
    $stmt = $pdo->prepare("SELECT id, title, content, author FROM posts WHERE id = :id");
    $stmt->execute([":id" => $id]);
    return $stmt->fetch(PDO::FETCH_ASSOC) ?: [];
}

function updatePost(PDO $pdo, int $id, string $title, string $content, string $author): int {
    $stmt = $pdo->prepare("UPDATE posts SET title = :title, content = :content, author = :author WHERE id = :id");
    $stmt->execute([":title" => $title, ":content" => $content, ":author" => $author, ":id" => $id]);
    return $stmt->rowCount();
}

function deletePost(PDO $pdo, int $id): int {
    $stmt = $pdo->prepare("DELETE FROM posts WHERE id = :id");
    $stmt->execute([":id" => $id]);
    return $stmt->rowCount();
}

// Demo:
$pdo = setupDatabase();
createPost($pdo, "First post", "Hello", "Alex");
createPost($pdo, "Second post", "Hi", "Mary");

$post = getPost($pdo, 1);
echo $post['title'] . " - " . $post['author'] . "\n";

updatePost($pdo, 1, "Updated post", "New content", "Alex");
echo "Updated\n";

$deleted = deletePost($pdo, 2);
echo "Deleted: " . $deleted . "\n";

$posts = getAllPosts($pdo);
foreach ($posts as $p) {
    echo $p['title'] . " - " . $p['author'] . "\n";
}