Playlist history on website

I am building a website to compliment my hobby. What I want to do is this, and I am not sure if it is possible…

I want at the top of my website for a spot to say currently playing, and have the song currently playing show up. I also want to have a list show what recently played, say 6 items, in a list. Is this possible? I am sure it is, but I just want to double check before I migrate from SPL over to mAirlist.

Troy

There is no built-in function for that in mAirList (somewhat out of scope for the playout system), but I usually recommend something like that (assuming that your website is written in PHP or any other dynamic language):

  • On your webserver, set up a MySQL or similar database with a table that holds the list of songs played (columns: starttime, artist, title; don’t forget to set an index on the “starttime” column for faster access when searching and sorting).

  • Then place a secret PHP script on the server that receives the artist and title of the current song, and inserts a new row into the SQL table, along with the current time.

  • Set up HTTP GET logging in mAirList so that that script is called everytime an item is started in mAirList. If possible, use the item types filter so that only “Music” items are transferred.

  • On your website, add code that retrieves the last x items from the SQL table and displays it to the user.

Wow. That seems difficult. Is there anyone on the forum that is good with scripting and willing to assist with this process if it goes that far?

Actually pretty easy with a little bit of PHP skills (ask any web developer).

OK. Thanks.