Multiple Dynamic Category Pages

Ask the community
,
1

Okay so I am running a project for a tour operator. The category pages (repeaters) need to be linked as follows:

Continents Page > Countries Page > Cities Page > City Page > Hotel Page

My database is set out as:

Continent | Country | City | Hotel Name

I have also tried using a database for just continents which seemed to work but when linking it to the countries database it isn’t pulling through the correct countries, it is only pulling through all of the countries in the countries database. The structure should be:

7 continents (let’s choose europe here for an example) - that page links through to a page full of european countries (let’s choose england) - that page should link through to a page full of english cities (let’s choose london) - that page should link through to a page describing London with links to 2 hotel pages (let’s say premier inn) - that page should link through to a description about the hotel and some photos.

2

I think you need to learn about routers and create a router that will take the user through the urls of domain.com/continent/country/city/information/hotelname and if the user hits domain.com/continent it will lists all countries in that continent. Routers are perfect for this kind of work but demands heavy coding.

You could also make the links send query parameters like domain.com/europe?city=london and in code check for query city and filter the results depending on that.

Or create all pages as dynamic items gallery pages for each data collection and link them together with dynamic urls. It all demands coding a bit over the capacity in a post here.

I should read up on routers if you can code a bit or hire someone for a couple of hours to do it for you.