Backend DevelopmentPHP Tutorial[PHP open source product] One of the analysis of the product filtering function of Ecshop (mainly analyzing category.php)_PHP tutorial[PHP open source product] One of the analysis of the product filtering function of Ecshop (mainly analyzing category.php)_PHP tutorial
1. First, let’s explain why we need to analyze the category.php file.
(1) The reasons are as follows:
①I am curious about the implementation of the shopping mall product filtering function;
② I am more interested in the design of data tables for products in the mall. (This function involves interaction with the database, and has a certain connection with the design of the data table in the database);
③The multi-condition (attribute) filtering function is needed in many websites today and is very widespread (such as: general mall websites, group purchase websites, real estate websites, information classification websites, etc.).
(2) What we hope to achieve is:
① Be able to have a preliminary understanding of the multi-condition filtering function. (At least if you do it yourself, you can achieve it quickly);
②In the implementation of multi-condition filtering, how should the database be designed to be more optimized and reasonable (refer to previous experience);
③Have an understanding of some strategies or techniques in multi-condition screening (will summarize a few points)
2. Then, let’s first take a look at what the demand is now? (For multi-condition filtering, please refer to JD.com, Suning, Gome, etc.)
①Jingdong Mall’s product filtering function (screenshot):
②Suning Mall’s product filtering function (screenshot)
③Gome Online’s product filtering function (screenshot)
Supplement: In fact, to observe this function, we must also think about the address bar. I will omit it here. After all, it will be simpler if we analyze it this way. The above examples are just an introduction. I will improve it later.
④ECSHOP’s product filtering function is implemented, and the display details (screenshot + text) are as follows:
1) First, my local server has a virtual host address for the ecshop demo website installed on this machine:
"GSM mobile phone" category in the navigation bar. As follows:
If I want to view phones branded "Nokia", then click on the "Nokia" tab:
The access address is:
The result page is:
The access address is:
The result page is:
Analysis: From the changes in the address bar and screenshots above, we can initially see what ecshop’s multi-condition search method is like.
Conjecture 1: Every time the user clicks on the condition (attribute) to filter products, the search address bar will change. Why does the address bar change? In the final analysis, it must be for each product. The hyperlink address of the attribute's a tag has been changed. And every time you click, it will change according to the different search conditions.
Thus we know that the hyperlink of this attribute is dynamically generated. The ecshop background must have done a lot of judgment and finally generated a hyperlink address for each product attribute to prevent the last search condition from being lost.
Conjecture 2: What is the basis for calculating the price range of a product? It is still set up manually in the background. The price range of JD.com’s products seems to be very regular, which is quite different from the price range of ecshop. Don't worry about so much, let's study ecshop first.
Conjecture 3: Parameter filter_attr=163.0.160.0 The numbers in must represent the following: select all of them under the color, screen size, phone mode, and appearance style attributes. Which ones are worth it?
----> With these questions, let’s directly study how ecshop implements the above multi-condition search function. . . GO. . .
First, we go to the ecshop website to change the directory, find the category.php file, and open it to study it.
