How to use PHP to develop article classification function

How to use PHP to develop article classification function

In website development, the classification function is one of the very important functions. Whether it is a news website, blog, forum or e-commerce website, various contents need to be classified and managed so that users can easily find the content they are interested in. This article will introduce how to use PHP to develop an article classification function and provide corresponding code examples to help readers quickly implement this function.

1. Create a database

First, we need to create a database to store information related to article classification. You can use MySQL or other relational databases to create a database and create a table to store article classification data.

Sample code:

CREATE DATABASE article_classification;
USE article_classification;

CREATE TABLE categories (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50) NOT NULL
);

The above code creates a database named article_classification, and creates a table named categories in the database to store article classification data. The table contains two fields: id is used to uniquely identify each category, and name is used to store the name of the category.

2. Implement the article classification function

Next, we use PHP to implement the article classification function. First, we need to connect to the database and query all article categories. Then, display it on the page for users to choose. Finally, according to the user's selection, articles of the corresponding category are displayed on the page.

Sample code:

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

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

// 查询所有的文章分类
$sql = "SELECT * FROM categories";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  // 输出数据
  while($row = $result->fetch_assoc()) {
    echo "<a href='category.php?id=".$row['id']."'>".$row['name']."</a><br>";
  }
} else {
  echo "暂无分类";
}

// 关闭数据库连接
$conn->close();
?>

The above code first connects to the database, and then executes a query statement to obtain all article categories from the categories table. If there are categories, output the name of each category on the page, add a link to each category, link to a page named category.php, and pass the category id as a parameter. Finally, close the database connection.

In the page named category.php, we can query all articles under this category based on the passed category id and display them on the page.

Sample code:

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

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

// 获取传递过来的分类id
$id = $_GET['id'];

// 查询该分类下的所有文章
$sql = "SELECT * FROM articles WHERE category_id = ".$id;
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  // 输出数据
  while($row = $result->fetch_assoc()) {
    echo "<h3 id="row-title">".$row['title']."</h3>";
    echo "<p>".$row['content']."</p>";
    echo "<hr>";
  }
} else {
  echo "暂无文章";
}

// 关闭数据库连接
$conn->close();
?>

The above code first connects to the database, and then obtains the passed classification id. Then, execute a query statement to query all articles under this category from the articles table. If there are articles, output the title and content of each article on the page, and add horizontal dividing lines as separation. Finally, close the database connection.

3. Summary

Through the above code example, we can implement a simple article classification function. Readers can make corresponding modifications and optimizations according to their actual needs and database structure. At the same time, during the development process, attention should be paid to checking the validity of user input to prevent security issues such as SQL injection.

In short, it is not complicated to use PHP to develop the article classification function. You only need to connect to the database, query the classification data and display it. I hope that the code examples provided in this article can help readers realize their own article classification function.

The above is the detailed content of How to use PHP to develop article classification function. For more information, please follow other related articles on the PHP Chinese website!