[PHP DEV.] Server Status Monitor

Hello! Thanks for checking in on my post.

I am wanting to make a service checker that checks to see if services are up periodically and then put the data into a database. I think it would be best to use some type of Cron Job. (Something like this is what I'm talking about: So here is something I am not sure about, https://teamexon [DOT] eu/stav-sluzieb.html).

So how would I have the script that displays the data get a date, tell if it is on or off, and then Get the most recent data?

Thanks,
TJ

This sounds like a 2 part question. The first part is to write a shell or perl script (possible with PHP but I wouldn't do it) to do the checking and maintain the database. The 2nd part, in PHP, would read the data from the database and display it appropriately. Depending on how often you run the first script, I would not think checking the status in the PHP script would be necessary. The database will always be up to date if you run the first script frequently enough.

Okay. Heres the deal, I am only some what good with PHP and dont know shell or perl.

How would I tell it to receive the last three days to display on the site? And also in the main script, how could I also tell it to put a date in the database.

Another question, how could when the status are okay, how could it put a "1" for okay in the database, and then when the script displays the data on the page "1" = an image?

Sounds like a good opportunity to learn, especially if you are going to be using cron.

Structure your query to do that. You need to design your database schema before you do any programming.

They same way you do any other field. All databases have date field definitions.

All databases also have boolean field definitions. How you display that on your page is a matter of personal preference. You could use an image or simply the words 'up' and 'down'. Perhaps in green and red respectively.

Okay, sorry for delay.

How often should I have the service checking? 1, 5, 10, 20 times a day?

That is entirely up to you. I have no idea what your users are expecting or what the purpose is with respect to history.

True. Heres a question. If I have it update once every 30 minutes, can it delete the previous check from earlier in the day?

Yes. You can pretty much delete/add/update anything you want, any time you want.