PHPで開発したブログシステムのユーザーフィードバックと改善

<form action="feedback.php" method="post">
  <label for="name">姓名：</label>
  <input type="text" id="name" name="name"><br><br>
  
  <label for="email">邮箱：</label>
  <input type="email" id="email" name="email"><br><br>
  
  <label for="feedback">反馈内容：</label><br>
  <textarea id="feedback" name="feedback" rows="5" cols="30"></textarea><br><br>
  
  <input type="submit" value="提交反馈">
</form>

<form action="survey.php" method="post">
  <h3>请为我们的博客系统评分：</h3>
  <input type="radio" id="rating1" name="rating" value="1">
  <label for="rating1">1分</label><br>
  
  <input type="radio" id="rating2" name="rating" value="2">
  <label for="rating2">2分</label><br>
  
  <input type="radio" id="rating3" name="rating" value="3">
  <label for="rating3">3分</label><br>
  
  <input type="radio" id="rating4" name="rating" value="4">
  <label for="rating4">4分</label><br>
  
  <input type="radio" id="rating5" name="rating" value="5">
  <label for="rating5">5分</label><br>
  
  <input type="submit" value="提交评分">
</form>

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "feedbacks");

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建反馈表
$sql = "CREATE TABLE IF NOT EXISTS feedbacks (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30) NOT NULL,
    email VARCHAR(50) NOT NULL,
    feedback TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";

if ($conn->query($sql) === FALSE) {
    echo "创建表失败: " . $conn->error;
}

// 将用户反馈插入数据库
$name = $_POST["name"];
$email = $_POST["email"];
$feedback = $_POST["feedback"];

$sql = "INSERT INTO feedbacks (name, email, feedback)
    VALUES ('$name', '$email', '$feedback')";

if ($conn->query($sql) === FALSE) {
    echo "插入数据失败: " . $conn->error;
}

$conn->close();

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "feedbacks");

// 检查连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询各类反馈数量
$sql = "SELECT COUNT(*) as total_feedbacks FROM feedbacks";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "总反馈数量：" . $row["total_feedbacks"];
    }
} else {
    echo "没有反馈数据";
}

$conn->close();