SQL/PHP project - easy you think?

Terrier_Jimlad · 21 Sep 2009 at 19:58

Hi,

I want to develop a little service status for our work. Basically I want a page that has something like:

• Service 1 - ONLINE (maybe online.gif)
• Service 2 - ONLINE
• Service 3 - OFFLINE (maybe offline.gif)

etc etc and I want this to be pulled from a little SQL database which is controlled by a small admin.php page which has each service listed, with maybe either a dropdown box or checkbox saying whether it's online or not, and then the changes made here will reflect the front page

Do you think that would be easy? Also, if that worked a treat, i'd like to also be able to put in a little schedule for example when I knew we had planned downtime at a particular time, it would auto change?

Thanks

Terrier_Jimlad · 21 Sep 2009 at 20:34

ok ok ... anyone want to help me begin?

I guess it would be something easy like IF STATUS = OFFLINE then <html snippet> etc etc

I could probably do that myself, but would i have to write that query for every service I have or can you do that in one array or something? sorry for sounding like a pleb

Terrier_Jimlad · 21 Sep 2009 at 20:37

yes pls

Terrier_Jimlad · 21 Sep 2009 at 21:31

database isnt done yet, i can quickly create some databases, i just didnt know how to approach it based on the code yet

Terrier_Jimlad · 21 Sep 2009 at 22:00

** edit **

Terrier_Jimlad · 21 Sep 2009 at 22:08

I get this eror:

Code:

Parse error: syntax error, unexpected T_STRING in /home/test.php on line 9

Line 9 reads:

Code:

$sql = SELECT * FROM STATUS;