Post ekleme ve listeleme

int { ... } yaz. İçinde $stmt = $pdo->prepare("INSERT INTO posts (title, content, author) VALUES (:title, :content, :author)"); yaz, $stmt->execute([":title" => $title, ":content" => $content, ":author" => $author]); ile çalıştır ve return (int) $pdo->lastInsertId(); döndür. function getAllPosts(PDO $pdo): array { ... } yaz. İçinde $stmt = $pdo->query("SELECT id, title, content, author FROM posts ORDER BY id"); yaz ve return $stmt->fetchAll(PDO::FETCH_ASSOC); döndür.
Örnek çözüm:
<?php
// Blog projesi: BlogPost + setupDatabase + createPost + getAllPosts

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);
}

// Demo:
$pdo = setupDatabase();
createPost($pdo, "İlk yazım", "Merhaba dünya", "Ayşe");
createPost($pdo, "İkinci yazım", "Selam", "Alex");
$posts = getAllPosts($pdo);
foreach ($posts as $p) {
    echo $p['title'] . " - " . $p['author'] . "\n";
}