当前位置：首页 > PHP

php实现分类功能实现

2026-02-15 02:45:11PHP

PHP实现分类功能的方法

使用PHP实现分类功能通常涉及数据库设计、数据操作和前端展示。以下是实现分类功能的几种常见方法。

数据库表设计

分类功能通常需要一个分类表来存储分类信息。常见的表结构如下：

CREATE TABLE categories (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    parent_id INT DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

id 是分类的唯一标识符。
name 是分类的名称。
parent_id 用于实现多级分类，指向父分类的ID。

添加分类

通过PHP将分类数据插入数据库：

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

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$name = "电子产品";
$parent_id = NULL; // 顶级分类

$sql = "INSERT INTO categories (name, parent_id) VALUES ('$name', $parent_id)";

if ($conn->query($sql) === TRUE) {
    echo "分类添加成功";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

查询分类

从数据库中查询分类数据并显示：

<?php
$conn = new mysqli("localhost", "username", "password", "database");

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM categories";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"]. " - 名称: " . $row["name"]. "<br>";
    }
} else {
    echo "暂无分类";
}

$conn->close();
?>

多级分类实现

使用递归函数实现多级分类的展示：

<?php
function displayCategories($parent_id = NULL, $level = 0) {
    $conn = new mysqli("localhost", "username", "password", "database");
    $sql = "SELECT * FROM categories WHERE parent_id " . ($parent_id === NULL ? "IS NULL" : "= $parent_id");
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            echo str_repeat("&nbsp;", $level * 4) . $row["name"] . "<br>";
            displayCategories($row["id"], $level + 1);
        }
    }
    $conn->close();
}

displayCategories();
?>

分类的编辑和删除

更新分类信息：

<?php
$conn = new mysqli("localhost", "username", "password", "database");

$id = 1;
$newName = "家用电器";

$sql = "UPDATE categories SET name='$newName' WHERE id=$id";

if ($conn->query($sql) === TRUE) {
    echo "分类更新成功";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

删除分类：

<?php
$conn = new mysqli("localhost", "username", "password", "database");

$id = 1;

$sql = "DELETE FROM categories WHERE id=$id";

if ($conn->query($sql) === TRUE) {
    echo "分类删除成功";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>