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

    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
  • 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

    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
Your Reply