Making playlists

JohnM
JohnM
Offline
0
Here's what I want to do and I want to see if it can be done without customization. I have basic skills, can modify CSS and scripts, not good at creating from scratch.

I want to keep my music collection in a MYSQL database, with artist, album, song time and format (mp3/flac, etc). Just the info, not the music.

I want to display that on my site with a user logging in and having the ability to select some number of songs as their custom playlist. I would like to write back to a MYSQL database the user ID and the songs they selected.

So basically I need the ability to read/update an sql database and the ability to take input from a selection and save in a database.

Imagine a DJ allowing the students to select the songs they want to hear ahead of time from a list, which might be a subset of the total or the total list, depending on the restrictions that might be set.

Thanks
Responses (3)
  • Accepted Answer

    Wednesday, December 07 2011, 10:15 PM - #Permalink
    0
    but I don't understand... WHO will be making the playlists? you, or the users?

    the users can make the playlists on the frontend... but now that I think about it, to add an item to a playlist a FILE must exist, otherwise this is not possible

    so I'm afraid you can't do 100% what you want without code customization..!
    The reply is currently minimized Show
  • Accepted Answer

    JohnM
    JohnM
    Offline
    Thursday, December 08 2011, 10:04 PM - #Permalink
    0
    Perhaps playlist is the wrong term. I want to take a list of available music, allow the users to search against that list and select some music from that list that will eventually be used to create a playlist. I don't want to upload 30000 songs online, just show them what is available and let them select. Their selections would be saved. Probably not a good fit for this software since it is more geared towards a jukebox type situation where you need the music present. Thanks.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, December 13 2011, 05:28 PM - #Permalink
    0
    ok, I think I understand. some kind of a "whishlist" feature.. right?
    well, yes, actually the playlist feature was kind similiar to this, but not exactly. aslo, as I mentioned, no songs can be added to a playlist if no file exists.

    so what you need can be done with some customization work, its not possible out of the box.
    The reply is currently minimized Show
Your Reply