I'm hoping someone can help me with this and possibly give me a little assistance in getting this setup, since although I've been a long time programmer, I've just never really worked with web sites. Here's my goal:
I run synchronized Christmas light shows during the winter. I've setup my website so a user can view past years shows along with information about the current seasons shows.
What I want to do is to have a display that would show the list of Light shows (by song) being displayed for the current season. But I want some kind of a marker/pointer that would be pointing to the show name that is currently being played. That way the users would know what shows might be coming up next or when a particular show they may like to see would be coming up.
The controller that runs the shows, I believe I should be able to make it send out a web call to a URL address that could send an update that would reflect the next show being displayed.
I'm figuring I will have a database table that would contain the list of the shows being displayed that would include a field for the order being played (so the displayed list would order them correctly) and possibly a Boolean field for each row that would reflect if it's currently being displayed.
So what I need (and need to understand it) is how can I set this up so that my controller could send the show playing information to a URL endpoint and somehow that endpoint would update the table to reflect the current playing show (and clear out any previously set playing status).
Hopefully that makes sense in my request, and would very much appreciate any help or guidance I can get to help me with this task.