How to store and relate this data within WordPress

  • alfie

    (@drtanz)


    11 years, 8 months ago

    I have a dilemma in how the data in this scenario should be organised, as well as queried.

    The main elements in the scenario are the following:

    Competition
    Team
    Player

    Each player plays for one particular team.

    Each team participates in one or more competitions.

    First I’d like to know how this data should be stored within WordPress, using Custom Post Types, Taxonomies, or maybe custom tables?

    Next comes querying. Let’s say I want to display all players who play in the |Eurocup| competition, and I also want next to each player displayed, his team name and info about team.

    Finally, the whole system should prevent redundancy of data. That is, if for example I remove a team from one of the competitions, the players within the team should be automatically disassociated from that competition. Same if the team description changes, the player list should also display the updated team description.

    Maybe there is a simple solution to this data storage and relationship in WordPress and I’m missing it, so I’d really appreciate some tips on how to implement this.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Pioneer Web Design

    (@swansonphotos)

    11 years, 8 months ago

    Each Competition would be a Page. That page would load a custom page template that would use a combination of HTML and custom queries to output data in the manner desired (and some CSS work also).

    Each Team is given it’s own category which of course would be the team name. Each category would have it’s own custom template (Team logo, output list of players, etc.)

    Each Player has a post in the team category. Using the permalink structure /%category%/%postname%/ would make their url to be sportsite.com/team/player (which would work well for SEO). If a player is added or removed from said Team category, the well written custom queries used would then not display them in the lists(s).

    Once above is all created, it’s a matter of site flow and design (custom queries, those page templates, custom css).

    Assuming yearly competitions, I would set up WP Multisite per year sportsite.com/year/, first year of course requiring much work, but the subsequent years would start with a copy of the previous year db, and an import of pages and posts to start.

    If done well with CSS, each year could easily provide a fresh look by simple edits to the stylesheet.

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    11 years, 8 months ago

    Duplicate topic – http://wordpress.org/support/topic/how-to-store-data-for-my-plugin?replies=3 closing. Please keep to the original thread and not create duplicates.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to store and relate this data within WordPress’ is closed to new replies.