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

Junk · 21 Sep 2009 at 20:02

very easy.

dangerstat · 21 Sep 2009 at 20:29

Junk said:
very easy.

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

RobH · 21 Sep 2009 at 20:37

Can you issue a query that fetches the status of all services at once?

Terrier_Jimlad · 21 Sep 2009 at 20:37

yes pls

RobH · 21 Sep 2009 at 20:41

roflcakes22 said:
yes pls

That was a question, I don't know your database schema so I can't answer that. If you can then you would simply issue that query and return the results in an array. You can then iterate the results array and generate the required status information.

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

dangerstat · 21 Sep 2009 at 21:58

You'd create a table with something like

CREATE TABLE status (ID INT(10),NAME VARCHAR(80), STATUS INT(1))

you'd have a PHP page that first connects to the database

(normally this is something like $conn = mysql_connect($db,$user,$passwd);

then you'd execute an SQL select statement something like
$sql = SELECT * FROM STATUS;
$stmt = mysql_prepar($conn,$sql);
$res = mysql_execute($conn,$stmt);

then have something like

print "<table><tr><td>ID</td><td>NAME</td><td>STATUS</td></tr>
while(@record = statement.fectchrow()){
print "<tr>";
$crec=1;
foreach(@record as $colum){
if($crec==3){
if($column ==1){
print "<TD>SYSTEM IS UP</TD>";
}else{
print "<TD>SYSTEM IS DOWN</TD>";
}
}else{
print "<TD>$column</TD>";

}
print "</TR>"
}

print "</TABLE>";
}

Terrier_Jimlad · 21 Sep 2009 at 22:00

** edit **

dangerstat · 21 Sep 2009 at 22:05

Think that's against the rules fella

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;

Mattus · 21 Sep 2009 at 22:32

You need quotation marks.

Code:

$sql = "SELECT * FROM status"

robmiller · 22 Sep 2009 at 00:02

dangerstat said:
You'd create a table with something like

CREATE TABLE status (ID INT(10),NAME VARCHAR(80), STATUS INT(1))

you'd have a PHP page that first connects to the database

(normally this is something like $conn = mysql_connect($db,$user,$passwd);

then you'd execute an SQL select statement something like
$sql = SELECT * FROM STATUS;
$stmt = mysql_prepar($conn,$sql);
$res = mysql_execute($conn,$stmt);

then have something like

print "<table><tr><td>ID</td><td>NAME</td><td>STATUS</td></tr>
while(@record = statement.fectchrow()){
print "<tr>";
$crec=1;
foreach(@record as $colum){
if($crec==3){
if($column ==1){
print "<TD>SYSTEM IS UP</TD>";
}else{
print "<TD>SYSTEM IS DOWN</TD>";
}
}else{
print "<TD>$column</TD>";

}
print "</TR>"
}

print "</TABLE>";
}

You realise this has about 50 syntax errors in it, right?

topbanana · 22 Sep 2009 at 08:36

What happens when your MySql servers goes offline?

suarve · 22 Sep 2009 at 09:16

topbanana said:
What happens when your MySql servers goes offline?

Then it's self evident that the service is down

RobH · 22 Sep 2009 at 10:39

topbanana said:
What happens when your MySql servers goes offline?

You should have a fail state that returns something like "unable to retrieve service status" rather than collapsing into a script error.

dangerstat · 22 Sep 2009 at 17:24

robmiller said:
You realise this has about 50 syntax errors in it, right?

It was supposed to be an indication how to do it. I don't do other peoples homework