php如何实现多篇文章点赞

CREATE TABLE articles (

id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

content TEXT NOT NULL,

likes INT(11) UNSIGNED DEFAULT 0

);

// 链接到数据库

$conn = mysqli_connect(host, username, password, database_name);

// 获取文章ID

$id = $_GET[id];

// 查询文章

$sql = “SELECT * FROM articles WHERE id = $id”;

$result = mysqli_query($conn, $sql);

// 如果查询失败，则输出错误消息并终止脚本

if (!$result) {

die(“Error: ” . mysqli_error());

}

// 如果找不到文章，则输出错误消息并退出

if (mysqli_num_rows($result) == 0) {

echo “Article not found”;

}

// 根据文章id从数据库中获取点赞数

$sql = “SELECT likes FROM articles WHERE id = $id”;

$result = mysqli_query($conn, $sql);

$row = mysqli_fetch_assoc($result);

$likes = $row[likes];

// 输出文章标题、正文和点赞数

echo “<h1>” . $article[title] . “</h1>”;

echo “<p>” . $article[content] . “</p>”;

echo “<p>Likes: ” . $likes . “</p>”;

// 显示点赞按钮

echo “<form action=like.php?id=” . $id . ” method=post>”;

echo “<button type=submit name=like>Like</button>”;

echo “</form>”;