Music Database

Please Select One of the Following Options

Display and Maintain Artists and Albums

Display and Maintain Songs

Display and Maintain Playlists

Note to the Viewer

This is an experimental database. Please feel free to test and make any changes desired.

This project was conceived and developed as a learning exercise for PHP, MySQL Database, and manipulation of the HTML Document Object Model (DOM) with JavaScript. It was developed to demonstrate knowledge of those programming techniques, and creating a visually beautiful page design was not an objective of the project. Some of the techniques demonstrated are an (almost) tableless layout with CSS, scrollable tables for data presentation, validation and processing of HTML forms, and basics of JQuery. The application mimics part of the data structure for an iPod music player, with a fully normalized database including tables for artists, albums, songs, and playlists. The navigation was designed to be simple and self-explanatory. The reader is invited to review the PHP scripts and test the application, including updating the data base as desired.