使用php+mysql写一个简单的评论系统并给出代码示例
时间: 2023-08-06 12:02:31 浏览: 47
好的,以下是一个简单的评论系统的PHP和MySQL代码示例:
1. 创建数据库表
在MySQL中创建一个名为"comments"的表,包含以下字段:
```
CREATE TABLE comments (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
email VARCHAR(50) NOT NULL,
comment TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
```
2. 创建评论表单
使用HTML和CSS创建一个评论表单,其中包含以下字段:
```
<form method="POST" action="submit_comment.php">
<label for="name">Name:</label>
<input type="text" id="name" name="name" required>
<br>
<label for="email">Email:</label>
<input type="email" id="email" name="email" required>
<br>
<label for="comment">Comment:</label>
<textarea id="comment" name="comment" required></textarea>
<br>
<button type="submit">Submit</button>
</form>
```
3. 处理表单提交
在PHP中编写一个脚本来处理表单提交。该脚本应该执行以下步骤:
```
<?php
// 获取表单数据
$name = $_POST['name'];
$email = $_POST['email'];
$comment = $_POST['comment'];
// 连接到数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "comments";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 插入评论到数据库中
$sql = "INSERT INTO comments (name, email, comment) VALUES ('$name', '$email', '$comment')";
$result = mysqli_query($conn, $sql);
// 重定向用户到评论页面
header("Location: comments.php");
exit;
?>
```
4. 显示评论
在PHP中编写一个脚本来显示所有评论。该脚本应该执行以下步骤:
```
<?php
// 连接到数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "comments";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// 获取所有评论
$sql = "SELECT * FROM comments ORDER BY created_at DESC";
$result = mysqli_query($conn, $sql);
// 显示评论
while ($row = mysqli_fetch_assoc($result)) {
echo "<div>";
echo "<h3>" . $row['name'] . "</h3>";
echo "<p>" . $row['comment'] . "</p>";
echo "<p>" . $row['created_at'] . "</p>";
echo "</div>";
}
?>
```
这是一个简单的评论系统的基本实现。当然,还可以添加更多功能,例如分页、验证、防止垃圾邮件等等。