George Chadderdon's Prog Rock Database Project

Welcome to my Prog Rock Database Project. This is my initial effort, still under construction, to develop a database web application. It is to be a searchable database of progressive rock music with links to information about the bands, their albums, and songs. The phenomenon of prog rock rock began in the mid-60s in the United Kingdom, probably inspired largely by the experimentations of the Beatles. One of the earliest prog rock albums was The Moody Blues' Days of Future Passed, a concept album with orchestral interludes between the folk/world music-flavored rock pieces. The prog rock movement largely died in the mid-70s, but had a brief resurgence in the 80s. Most, though not all, of these groups are or were British. Typical prog rock groups: King Crimson, Yes, Genesis, ELP (Emerson, Lake, and Palmer), Van Der Graaf Generator.

CLICK HERE TO VIEW THE DATABASE

Current features:

• MySQL prog rock database set up on 1&1 account.
• ProgRockAlbums table added and populated with a few albums.
• PHP page written for displaying the table. Click here to view the full table (in an un-prettied format).
• PHP web form created allowing entry of new albums. The form has input validation requiring certain fields be have entries and the release date be no earlier than 1965. Click here to access this.

Planned features:

• Creation of admin login providing password access to the adding of new album entries.
• Creation of an album add request mechanism which writes requests to an XML file.
• Admin option for browsing the XML requests and adding them to the album database.
• Tables for Artists and Songs.
• Addition of songs to the album entries.

For much more information about progressive rock, check out the Gibraltar Encyclopedia of Progressive Rock.

Last Updated: 11/29/2009