How to use PHP Developer City to implement product classification and filtering functions

How to use PHP Developer City to implement product classification and filtering functions

With the development of e-commerce, more and more companies have begun to establish their own e-malls. In addition to high-quality products and a convenient shopping process, a good e-mall must also provide accurate and easy-to-use product classification and filtering functions to help users quickly find the products they need. This article will introduce how to use PHP Developer City to implement product classification and filtering functions.

1. Design product classification

First of all, the products need to be classified according to different categories. Generally, the classification of goods can be divided into two levels: first-level classification and second-level classification. More levels can also be customized according to needs. In the MySQL database, two tables can be created to manage product categories, namely category and subcategory.

category table structure example:

CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

subcategory table structure example:

CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
);

2. Page design and development

1. First, in the electronic mall Product categories are displayed on the home page. Query all first-level categories from the database through PHP code and display them on the page. Users can click on a first-level category to view all products under that category.
2. When the user clicks on the first-level category, all the second-level categories under the first-level category in the database are read through the PHP code and displayed on the page. Users can click on the secondary category to view all products under this category.
3. On the product list page, a filtering function needs to be provided. This can be achieved using query strings. For example, the user can select a first-level category and a second-level category at the same time and click the filter button. The PHP code can read the filter conditions in the query string, query the corresponding products from the database according to the conditions, and display them on the page.

3. Write PHP code

1. First, connect to the MySQL database and query all first-level categories.

<?php
// 连接MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 查询所有的一级分类
$query = "SELECT * FROM category";
$result = mysqli_query($connection, $query);

// 将查询结果存储为数组
$categories = array();
while ($row = mysqli_fetch_assoc($result)) {
  $categories[] = $row;
}

// 关闭数据库连接
mysqli_close($connection);
?>

2. Display the first-level classification on the page and provide links.

<ul>
  <?php foreach ($categories as $category): ?>
    <li><a href="category.php?id=<?php echo $category['id']; ?>"><?php echo $category['name']; ?></a></li>
  <?php endforeach; ?>
</ul>

3. In the category.php page, read the id parameter in the query string and query all second-level categories under this first-level category.

<?php
// 连接MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 读取查询字符串中的id参数
$category_id = $_GET['id'];

// 查询该一级分类下的所有二级分类
$query = "SELECT * FROM subcategory WHERE category_id = $category_id";
$result = mysqli_query($connection, $query);

// 将查询结果存储为数组
$subcategories = array();
while ($row = mysqli_fetch_assoc($result)) {
  $subcategories[] = $row;
}

// 关闭数据库连接
mysqli_close($connection);
?>

4. Display secondary categories on the page and provide links.

<ul>
  <?php foreach ($subcategories as $subcategory): ?>
    <li><a href="subcategory.php?id=<?php echo $subcategory['id']; ?>"><?php echo $subcategory['name']; ?></a></li>
  <?php endforeach; ?>
</ul>

5. In the product list page, query the corresponding products based on the filter conditions in the query string.

<?php
// 连接MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

// 读取查询字符串中的筛选条件
$category_id = $_GET['category_id'];
$subcategory_id = $_GET['subcategory_id'];

// 根据筛选条件查询相应的商品
$query = "SELECT * FROM products WHERE category_id = $category_id AND subcategory_id = $subcategory_id";
$result = mysqli_query($connection, $query);

// 将查询结果存储为数组
$products = array();
while ($row = mysqli_fetch_assoc($result)) {
  $products[] = $row;
}

// 关闭数据库连接
mysqli_close($connection);
?>

4. Summary

Through the above steps, we can use the PHP Developer City to realize the product classification filtering function. First, design the product classification table in the database, then display the product classification on the page and provide corresponding links. In the product list page, the corresponding products are queried from the database according to the filter conditions in the query string and displayed on the page. Through such design and development, users can easily find the products they need and improve their shopping experience. At the same time, for developers, this design is also easy to maintain and expand, and more filtering conditions and functions can be customized according to needs.

The above is the detailed content of How to use PHP Developer City to implement product classification and filtering functions. For more information, please follow other related articles on the PHP Chinese website!