My first attempt at making a Jukebox with a web interfsce for public areas was successful, but very basic. It operated by compiling a list of music in a folder at start-up, randomisng the list and then just played through the list using PLC as the player.

Now I would like to expand on this in the rewrite by including a database to store all of the music details and file locations. This way I can pass rows of the table to the page and have it display artist, album, title information without having to try and extract it from the file location.

The Unique key of the selected track can then be passed to the player, and the file location looked up from the table using the key.

Yes, I like this idea.