지식질문답변 사이트에서 PHP를 사용하여 질문 수정 및 삭제 기능을 개발해 보세요.

$question_id = $_GET['id'];

$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$statement = $pdo->prepare('SELECT * FROM questions WHERE id = :id');
$statement->bindParam(':id', $question_id);
$statement->execute();
$question = $statement->fetch(PDO::FETCH_ASSOC);

<form action="update.php" method="POST">
  <input type="hidden" name="id" value="<?php echo $question['id']; ?>">
  <label for="title">标题:</label>
  <input type="text" name="title" value="<?php echo $question['title']; ?>"><br>
  <label for="content">内容:</label>
  <textarea name="content"><?php echo $question['content']; ?></textarea><br>
  <input type="submit" value="保存">
</form>

$question_id = $_POST['id'];
$title = $_POST['title'];
$content = $_POST['content'];

$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$statement = $pdo->prepare('UPDATE questions SET title = :title, content = :content WHERE id = :id');
$statement->bindParam(':id', $question_id);
$statement->bindParam(':title', $title);
$statement->bindParam(':content', $content);
$statement->execute();

$question_id = $_GET['id'];

$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$statement = $pdo->prepare('DELETE FROM questions WHERE id = :id');
$statement->bindParam(':id', $question_id);
$statement->execute();