ajax - thinkphp多条件筛选功能疑问？

Question

请问类似淘宝这种多条件筛选功能怎么组合筛选？我现在实现了大红框里面点击条件组合筛选的功能，但是输入框和里面的价格条件怎么和外面的条件去组合呢？ 比如我要筛选 500-1000 价格范围内的女款电子表，求思路。谢谢

Answer 1

Your question is whether the front-end is implemented or the server is implemented. I guess it is the front-end implementation.

Then this query condition can be used to filter table data directly using get 方式，比如用户点击 手表，JavaScript 中监听所有类别的点击事件，然后在当前 url followed by the corresponding field name and field value of watch to jump.

Similarly for the price, the operation logic when clicking the OK button is the same as clicking the Watch.

Taobao does not combine various filtering conditions at once and then query. Instead, click on a certain filtering condition to perform a filter refresh.

Answer 2

Generally, parameters are passed through get method for filtering. After entering the price, there should be a confirm button. When clicking the confirm button, use js to get the current link, and then assemble the price link to jump.

Answer 3

Use sql to combine where conditions to query the database, and then return the queried data to the front end

Answer 4

Your question is a bit strange. There is essentially no difference between clicking and typing. They are both part of the form.
As for how to check the database, you need to formulate sql according to your table structure.
However, to achieve this function, you generally need to use a search engine. It is not very good to directly check the database, and it is too stressful.