As a personal project, I’m wanting to create a block that will show the actors in a particular production on my community theatre’s website.
I have a list of people and their images, and a list of productions and roles (which could be actor, or behind the scenes).
A single person could be a stage manager in one show, a director in the next and an actor in the third. So really I should have a database with two tables – Shows with roles and links to people, and a people table with names and photos.
At the simplest level I could use ACF and just enter the data for each show – but I’m lazy and figure I’ll be reusing people and headshots, so a database might be the way to go.
My first thought was to create a entirely separate database, but it appears that best practice is for plugins etc to create tables in the WP database and then use WP functions to access the data?
The interface for the blog would be selecting a show name, and the output would be a list of roles with names and imagines which I can then style.
Am I on the right track or missing an obvious solution?
[ad_2]