Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > How to add attribute filtering to the ecshop search page

How to add attribute filtering to the ecshop search page

PHP中文网

Release： 2023-03-01 07:58:01

Original

1719 people have browsed it

You can just replace the hard-coded variables of his sql query with the ones passed through the search.

sql where changes according to the filtering conditions, for example:

$filter[&#39;brand&#39;] = isset($_REQUEST[&#39;brand&#39;]) ? trim($_REQUEST[&#39;brand&#39;]) : &#39;&#39;;//品牌
$filter[&#39;price&#39;] = isset($_REQUEST[&#39;price&#39;]) ? trim($_REQUEST[&#39;price&#39;]) : &#39;&#39;;//价格
$filter[&#39;attribute&#39;] = isset($_REQUEST[&#39;attribute&#39;]) ? trim($_REQUEST[&#39;attribute&#39;]) : &#39;&#39;;//属性

$where = " WHERE 1";
if($filter[&#39;brand&#39;] != &#39;&#39;){
    $where .= " AND brand=" . addslashes($filter[&#39;brand&#39;]);
}
if($filter[&#39;price&#39;] != &#39;&#39;){
    $where .= " AND price=" . addslashes($filter[&#39;price&#39;]);
}
if($filter[&#39;attribute&#39;] != &#39;&#39;){
    $where .= " AND attribute=" . addslashes($filter[&#39;attribute&#39;]);
}

Copy after login

Related labels：

ecshop，搜索页，属性筛选

source：php.cn

Previous article：Can this library be dsiable readline? Next article：How to implement file download function in laravel?

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn