Home > Article > Backend Development > 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
3. Write PHP code
<?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); ?>
<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>
<?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); ?>
<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>
<?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!