Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Home > Backend Development > PHP Tutorial > body text

How to add attribute filtering to the ecshop search page

PHP中文网

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

Original

1703 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