如何使用SLUG php mysql从url检索数据

CREATE TABLE `posts` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR(255) NOT NULL,
  `content` TEXT NOT NULL,
  `slug` VARCHAR(255) UNIQUE NOT NULL
);

function generateSlug($title) {
    $slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $title)));
    return $slug;
}

$title = "My First Post";
$slug = generateSlug($title);

$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

$stmt = $pdo->prepare("INSERT INTO posts (title, content, slug) VALUES (:title, :content, :slug)");
$stmt->execute([
    ':title' => $title,
    ':content' => "This is the content of my first post.",
    ':slug' => $slug
]);

$requestedSlug = $_GET['slug'] ?? null; // 从URL中获取SLUG参数

if ($requestedSlug) {
    $stmt = $pdo->prepare("SELECT * FROM posts WHERE slug = :slug");
    $stmt->execute([':slug' => $requestedSlug]);
    $post = $stmt->fetch();

    if ($post) {
        echo "Title: " . $post['title'] . "<br>";
        echo "Content: " . $post['content'];
    } else {
        echo "Post not found.";
    }
} else {
    echo "Invalid request.";
}