PHPで開発した中古リサイクルサイトにユーザーからの苦情報告機能を提供

CREATE TABLE complaints (
   id INT AUTO_INCREMENT PRIMARY KEY,
   user_id INT NOT NULL,
   complaint TEXT NOT NULL,
   created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
   updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

<form action="submit_complaint.php" method="post">
   <textarea name="complaint" rows="5" cols="40" placeholder="请输入您的投诉内容"></textarea>
   <input type="submit" value="提交投诉">
</form>

<?php
   $servername = "localhost";
   $username = "username";
   $password = "password";
   $dbname = "database";

   $conn = new mysqli($servername, $username, $password, $dbname);
   if ($conn->connect_error) {
       die("连接失败: " . $conn->connect_error);
   }

   $complaint = $_POST['complaint'];

   $sql = "INSERT INTO complaints (user_id, complaint) VALUES (1, '$complaint')";
   if ($conn->query($sql) === TRUE) {
       echo "投诉提交成功";
   } else {
       echo "投诉提交失败: " . $conn->error;
   }

   $conn->close();
?>

<a href="complaints.php">查看投诉列表</a>

<?php
   $servername = "localhost";
   $username = "username";
   $password = "password";
   $dbname = "database";

   $conn = new mysqli($servername, $username, $password, $dbname);
   if ($conn->connect_error) {
       die("连接失败: " . $conn->connect_error);
   }

   $sql = "SELECT * FROM complaints";
   $result = $conn->query($sql);

   if ($result->num_rows > 0) {
       while($row = $result->fetch_assoc()) {
           echo "投诉ID: " . $row["id"]. " - 用户ID: " . $row["user_id"]. " - 投诉内容: " . $row["complaint"]. "<br>";
       }
   } else {
       echo "暂无投诉列表";
   }

   $conn->close();
?>