Several concerns

It works.

What do you mean by installation here?

For the dataset I use it because I thought it was the right solution but since it’s the first time I manipulate it, I wouldn’t be.

The dropdownReg is for the dropdown button that concerns the regions and the dropdownDep is the same but for the different departments associated with the region used.

For this part I use only this database.

The database fiels involved are the first name, the last name, the expertise, the zip, the city and the link on the “make an appointment” button that redirects to the practitioner’s file.

Then I try to get that when you arrive on the page you see practitioners randomly each time and the same when the user chooses the region and the department. And I would like to be able to allow the user to change the region and the department dynamically without the need for a reset button.

For example if I’m looking for a practitioner in the region of Occitania and in fact I want to see a practitioner in Ile de France, I can change the region without resetting and the same for the departments associated with the regions.

I don’t know why I mixed dataset + code shares

I show you how the dataset-setup

  1. The user has 2 dropdown lists in front of him and practitioners are displayed randomly

  2. The user clicks on the drop down list 1 and choose a region.

  3. After choosing the region from the drop down list a search function starts

  4. The user chooses a suitable practitioner otherwise (6)

  5. In addition, all values in the drop-down lists are unique.

  6. The user now has the possibility to choose from the drop-down list 2 which concerns the departments associated with the region.

  7. After selecting the drop-down list a search function starts.

Edit

Oh yes, I almost forgot, there is a pagination that doesn’t work correctly when you choose a region, but if you choose a department, it works correctly.

It’s just for the clarification for this piece of code even if I know that by reordering the code, it will fix it.