• Resolved superoctave

    (@superoctave)


    Hi there!

    I’m working on creating a basic database for a theatre and really need some suggestions as the best way to approach this.

    Each production from this theatre will have its own page. The page should display who was in the production, displayed in a table. This information is “set”, and doesn’t need to change dynamically, though it would be nice to be able to display a thumbnail image for each actor (and display a default blank image if no headshot is available). I would like the user to be able to click on an actor’s name to display a list of other productions that the actor has been involved in.

    Here’s a picture to give an idea:
    http://www.matthewjpool.com/images/theatredatabase.jpg

    For an idea of how the site might function, it should be similar to ibdb.com or playbillvault.com

    My idea:

    Create custom taxonomy for each actor. Add custom meta field to new taxonomy for headshot image.

    Store info for each production in a CSV file and use PHP to generate an HTML table when the page loads. Use PHP to grab meta information about each actor and display headshot image.

    Can anyone give me any feedback as to whether there is an easier or better way of approaching this? Any feedback would be strongly welcomed!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Have you looked at Pods?

    https://wordpress.org/plugins/pods/

    Thread Starter superoctave

    (@superoctave)

    No- I will definitely check it out!!

    I’ve found a number of plugins that do this sort of thing, but most of them are pretty outdated and didn’t play nice with the latest version of WP. If this one works, it could be exactly what I’ve been looking for. Thanks!

    I’ve only played around with it, but it looks really pretty flexible and powerful. And I know the developer is quite responsive if you have questions about using it.

    Thread Starter superoctave

    (@superoctave)

    Wow! This seems to be exactly what I was looking for. Very powerful – and very straightforward. Thank you SO much!!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Looking for suggestions for creating basic database’ is closed to new replies.