Implementation of filters for categories of goods in an online store, how to implement?

Question

PHP

There is a table of categories and a table with filters for these categories. In the table with filters, I store a link to the category id and the name of the filter, which is selected from the product attributes. But what about values? Let's say you can filter by brand, or you can filter by screen diagonal, so you need different queries, what to do?

Answer 1

Well, theoretically, you should have parameters in each row of the product. And when you select products, you specify the selection criteria in the SQL query.
WHERE category_id = 5, display_size > 5