Well here is my scenario. I guess my first question is..... is something like this possible?
I do web development for my fire station and we have a total of 8 stations in our township. I want to try and keep a communication line open between all of the stations with a "Status Web Page" What is will be (when and if I purchase domain) is a simple index page with 8 boxes (1 per station) to show any needed news and important information for each station - much like in the file I have attached or you can visit it directly at [url removed, login to view]
I plan on having each station keep their browser window open at that page and I would set it up with an aut refresh (every 10 - 15 minutes or so)
Now the real work... getting the data in
I figured it would require the use of a database and thought it might be able to utilize a PHP Include to pull the data from the database into the page.
Firs and formost I am database illiterate so i would not be able to assist at all with that. We would need a form page so that each station could input the relevant data to be included onto the main page. My thought is to place this input page into a password protected directory and assign each station a username and password to enter / edit data - the info input page would be something simple like what I have here [url removed, login to view]
Obviously also there would have to be a page where people can in turn log in and delete items that were previously in there (Example a Hydrant is out of service and it is now repaired so the post would have to be removed)
I am open to any suggestions and although I understand this may be a big job I have to ask to be kind with bids as my fire department has no budget for this project (I am taking it on myself and will be paying any fees out of my own pocket like domain name and web hosting and such) I just want to do this as a safety feature for all firefighters in my town.