WordPress.org

Ready to get started?Download WordPress

Forums

Custom Dynamic pages from DB result (3 posts)

  1. kamy99
    Member
    Posted 1 year ago #

    Hi:

    I have a site running on CodeIgniter right now, but I want to migrate it to WP. I've figured out all the other parts except the dynamic pages that I'm generating now.

    I'm working on a singer website who has many albums and many songs (over 200). Some of the songs appear in multiple albums, ie “Best of” and Compilations.
    I have 3 tables, albums, songs, songs_to_albums.
    This gives me the posibility of assigning different songs to different albums.

    All songs have lyrics, most have videos , either on youtube or on our server.

    All songs and albums have star ratings and description.

    I need an Albums page where it extracts all albums.

    Each album is linked to an “Album-specific” page which extracts all the songs that are in the album, plus description, rating….

    Each song within an album is linked to “Song-specific” page, which extracts specific song info from the db, ie title, description, and albums it appears on.

    I need a page that lists all the songs dynamically, indicating on which albums they appear.

    I don’t want to create static pages for albums and songs, they must be dynamic.

    Currently all these pages, SQL queries, etc exist, so I need to know how to integrate them into WP.

    I realize I have to create some custom solution in WP, but since I'm not @ that advanced in WP I don't even know where to start !

    Thank you in advance for your help.

    Kamy

  2. Andrew Bartel
    Member
    Posted 1 year ago #

    Check out Custom Post Types and Scribu's excellent plugin Posts to Posts

  3. kamy99
    Member
    Posted 1 year ago #

    Thanks, didn't see the use of that plugin for my needs.

    The Custom Post Types link helped, but I'm still way off.

    I was hoping to find a more detailed explanation as what to do.

Topic Closed

This topic has been closed to new replies.

About this Topic