Tell me the materials for creating a form with which you can search in the database with the ability to select parameters (i.e. the user clicks "Advanced Search" and he has many, many circles appear where you can put a check mark and also one line where search word).

I would be very grateful for examples of such codes. And it is not necessary to search the MySQL database, if you can search by parameters using other technologies, then I will be doubly grateful if you tell them!

    1 answer 1

    What's so complicated!

    1. Option - we use different addresses handlers, for example, seach.php - script for processing ordinary search, seachbydetail.php - script for processing advanced search.
    2. A variant based on a pattern (I don’t remember the name), where the input script is always the same. Then we specify as a parameter which search method we use and plus the variables necessary for this method (example, index.php?action=seach&{необходимые методу переменные} or index.php?action=seachbydetail&{необходимые методу переменные} ).

    About how to make a form, there are many options. The simplest is 2 search forms with different addresses by handlers, but it is more beautiful to make dynamic on JS (JQuery).

    • I would understand the search process itself. In terms of the form, I’ll figure out how to write this data into variables too. But how to use PHP with MySQL to look for these variables? - nick777
    • Well, then give the structure of the table and the fields by which the search will be possible - Ale_x