custom field – Generate Sites based on customized database/table-contents

Question

I want a subset of automatically generated sites on my wordpress installation.

The data should be stored in a seperate MySQL database and consists of multiple tables with lot of 1:n interaction.

For most of the tables I would like to make a template which information from one entry of this table I would like to show when the entry-name is used as a permalink.

———

For the example below, when I open the link to x.yz/city/munich the site should show me the information that in the City Munich there are 5.500 cats and 7.210 dogs.
The informations should be displayed in exact defined areas so the layout does not change if I open the link to x.yz/city/berlin only the numbers for the pets are changing.
For the information focused on pets I want another layout who does show me on the link to x.yz/pet/cat that they are existent as pet in Munich but not in Berlin.

Tabelle: City
ID (PRIMARY) – Name (UNIQUE)
1 – Munich
2 – Berlin

Tabelle: Pet
ID (PRIMARY) – Name (UNIQUE)
1 – Cat
2 – Dog

Tabelle: Population
ID (PRIMARY) – City-ID (SECONDARY) – Population – Pet-ID (SECONDARY)
1 – 1 – 5.500 – 1
2 – 1 – 7.210 – 2
3 – 2 – 1.400 – 2

——-

Thanks a lot for your help!

0
Pax 7 days 2022-11-23T10:43:05-05:00 0 Answers 0 views 0

Leave an answer

Browse
Browse