How to achieve likes on multiple articles in php

php method to achieve likes for multiple articles is: 1. Create a database table "articles" to store article information and the number of likes; 2. Display articles and like buttons on the article page, and put It is associated with the article records in the database; 3. After the user clicks the "Like" button, we need to store their like records in the database.

Operating system for this tutorial: Windows 10 system, php8.1.3 version, Dell G3 computer.

The following is a code example for using PHP to like multiple articles.

1. Database architecture

First, you need to set up a database table to store article information and the number of likes. You can create a table named `articles` like this:

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
);

In this table, we will list the ID, title, content and number of likes of the article.

2. Display the article and like button

Next, we need to display the article and like button on the article page and associate it with the article record in the database.

// 链接到数据库
$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[&#39;title&#39;] . "</h1>";
echo "<p>" . $article[&#39;content&#39;] . "</p>";
echo "<p>Likes: " . $likes . "</p>";
// 显示点赞按钮
echo "<form action=&#39;like.php?id=" . $id . "&#39; method=&#39;post&#39;>";
echo "<button type=&#39;submit&#39; name=&#39;like&#39;>Like</button>";
echo "</form>";

3. Processing like operations

After the user clicks the "Like" button, we need to store their like records in the database.

The above is the detailed content of How to achieve likes on multiple articles in php. For more information, please follow other related articles on the PHP Chinese website!