How to achieve likes on multiple articles in php

尊渡假赌尊渡假赌尊渡假赌
Release: 2023-06-19 09:58:24
Original
1783 people have browsed it

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.

How to achieve likes on multiple articles in php

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
);
Copy after login

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>";
Copy after login

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!

Related labels:
php
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template