twelch1980
Member
I am in the process of having a website built for my online radio station and need some assistance with the following:
I want to have at the top a Now Playing section along with a recently played on the right sidebar. The software I am using does not have that function SPECIFICALLY built in BUT can work with the following
- 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.
Anyone ever done something like this? I know NOTHING about scripts at all.
Troy
I want to have at the top a Now Playing section along with a recently played on the right sidebar. The software I am using does not have that function SPECIFICALLY built in BUT can work with the following
- 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.
Anyone ever done something like this? I know NOTHING about scripts at all.
Troy