How to implement php product filtering function

How to implement the product filtering function of php: first perform the query submitted by the user; then obtain the user's query request in the server-side program; then start to assemble the SQL query statement; finally return the query results to the user, Completed the function for users to filter products based on conditions.

Recommendation: "PHP Video Tutorial"

php's function of filtering products by conditions is relatively simple.

In fact, it is to form SQL query conditions based on different conditions and find out different products from the database.

For example:

Users can conduct comprehensive searches by price range, brand, and product name.

Then, after the user selects the above query conditions (maybe all three conditions are set, or maybe only 2 of them are set), submit it to the server, and the server program receives the user's query Conditions, start assembling SQL query statements, and finally execute the assembled SQL query statements and return the results to the user.

Code example:

Query submitted by the user:

price='0-1000'; //按价格范围0－1000元查询
 
brandid=20;  //要求品牌必须是ID号为20的这个(假设这个ID号为20的品牌，名字叫”西部数据")
productname='绿盘'; //商品名称只设置了2个字以做模糊查询

After the user clicks the query button, depending on the program, , it may be the get method or the post method to send the query request. It is assumed to be the post method.

Then in the server-side program, the user’s query request is received:

$price=$_POST['price'];
$price_arr=explode('-',$price); //这里是把价格范围按-号拆散成数组，方便在组装SQL查询语句时用。
 
$brandid=$_POST['brandid'];
$productname=$_POST['productname'];

Of course, after the above data is obtained, it must be The corresponding safety inspection and processing will be skipped here.

Next, start assembling the SQL query statement:

$sqlexp='';
//下面开始组根据用户设置的查询条件进行SQL查询条件的组装
 
if(!empty($price)) {
    $sqlexp.=&#39; and (price>=&#39;.$price_arr[0].&#39; and price<=&#39;.$price_arr[1];
 
}
if(!empty($brandid)) {
   $sqlexp.=&#39; and brandid=&#39;.$brandid;
}
if(!empty($productname)) {
   $sqlexp.=" and instr(productname,&#39;$productname&#39;)>0";
}
 
//下面执行SQL查询
 
$result=mysql_query("select * from product where state=1 ".$sqlexp);

After the above query is completed, put the query results Returning it to the user completes the function of the user filtering products according to conditions.

The above is the detailed content of How to implement php product filtering function. For more information, please follow other related articles on the PHP Chinese website!