How to make requests by criteria with html select?

Question

MySQL

Good afternoon.
The database contains tables: actors, musicians, directors.
Each of these tables has a line "artist title", "date of birth" and so on.
I need to somehow make it so that the user has the opportunity to select data from the table by type:
" Select a profession (select with a choice of profession, and there are actors, musicians, stage directors in it." select the period (placeholder where the user enters the start date) ( placeholder where the user enters an end date) to submit the form ".
What is the way to do this?

Answer 1

to allow the user to select data

These are related html selects - example
After the user has selected, he submits the form. In your form handler, a request is made to the database:

SELECT your_param FROM table_name WHERE your_criteria = 1