How to use the PHP Developer City function: Build a product search and filtering system
In today's era of rapid development of e-commerce, more and more people are moving their shopping online. Therefore, it is particularly important to build a powerful shopping mall system. This article will introduce in detail how to use the PHP developer city function, focusing on how to build a product search and filtering system.
1. Database design
First, we need to design a database to store product information. We can create a table named "products" with the following fields:
2. Establish a connection
Before we start writing PHP code, we need to establish a connection to the database. You can use the following code to complete this step:
<?php $servername = "localhost"; $username = "your_username"; $password = "your_password"; $dbname = "your_database"; // 创建连接 $conn = new mysqli($servername, $username, $password, $dbname); // 检测连接 if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } ?>
3. Implementation of the search function
Next, we will implement a product search function. Users can search for products that contain the keyword in the product name or description based on the keyword. You can use the following code to implement the search function:
<?php // 获取用户输入的关键词 $keyword = $_GET["keyword"]; // 查询满足关键词的商品 $sql = "SELECT * FROM products WHERE name LIKE '%$keyword%' OR description LIKE '%$keyword%'"; $result = $conn->query($sql); // 输出搜索结果 if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "商品名称:" . $row["name"]. " - 价格:" . $row["price"]. "<br>"; } } else { echo "未找到相关商品"; } ?>
4. Implementation of the filtering function
In addition to the search function, the mall system also needs to provide a filtering function so that users can browse by category or brand commodity. You can use the following code to implement the filtering function:
<?php // 获取用户选择的分类和品牌 $category = $_GET["category"]; $brand = $_GET["brand"]; // 构建SQL查询语句 $sql = "SELECT * FROM products WHERE 1=1"; if (!empty($category)) { $sql .= " AND category = '$category'"; } if (!empty($brand)) { $sql .= " AND brand = '$brand'"; } // 执行查询 $result = $conn->query($sql); // 输出过滤结果 if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "商品名称:" . $row["name"]. " - 价格:" . $row["price"]. "<br>"; } } else { echo "未找到相关商品"; } ?>
In the above code, we use conditional judgment to build dynamic SQL statements to filter products based on the categories and brands selected by the user.
5. Summary
Through the above steps, we successfully developed the product search and filtering system in the mall function using PHP. Through this system, users can easily search and filter products that meet their needs. Of course, there are many other functions that need to be developed for the mall function, such as shopping cart, ordering, payment, etc. I hope this article is helpful to you, and I wish you successful development!
The above is the detailed content of How to use the PHP developer mall function: build a product search and filtering system. For more information, please follow other related articles on the PHP Chinese website!