Add table columns & change color?

bluetiger

Anyone know how to do two things (or help me look in the right direction):
1) add a blank table column to either the beginning or the end of my code below?

2) change the cells of the blank table columns dependent on numerical data within each specific row?

Help if you can......

Okay...here's what I have so far:

<html>
<head>
<title>Network Check!</title>
<meta http-equiv="refresh" content="30;URL=http://localhost/netcheck2.php">
</head>

<?PHP
mysql_connect("localhost", "root");
mysql_select_db("netcheck");
mysql_query("LOAD DATA INFILE 'getfile.txt' REPLACE INTO TABLE nets
LINES TERMINATED BY '|'");
?>
<?php

$dbname = "netcheck"; 
$loginname = "root"; 
$loginpass = ""; 
$dbhost = "localhost"; 

echo('<html><body bgcolor="#FFFFFF">'); 
echo('<font face="arial" size="+2"><b><center>'); 
echo("Database $dbname </b>"); 

$id_link = @mysql_connect($dbhost, $loginname, $loginpass); 

$tables = mysql_list_tables($dbname, $id_link); 

$num_tables = mysql_num_rows($tables); 

// store table names in an array 
$arr_tablenames[] = ''; 

// store number of fields per table(index 0,1,2..) in an array 
$arr_num_fields[] = ''; 
for ($i=0; $i < $num_tables; $i++) { 
    $arr_tablenames[$i] = mysql_tablename($tables, $i); 
    $arr_num_fields[$i] = mysql_num_fields(mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link)); 
} 

// store field names in a multidimensional array: 
// [i] == table number, [ii] == field number for that table 
for ($i=0; $i < $num_tables; $i++) { 
    for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { 
        $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); 
        $hash_field_names[$i][$ii] = mysql_field_name($result, $ii); 
    }     
} 

for ($i=0; $i < $num_tables; $i++) { 
    echo("<center><h3>Table $arr_tablenames[$i] </h3></center>"); 
    echo('<table align="center" border="1"><tr>'); 
    $result = mysql_db_query($dbname, "select * from $arr_tablenames[$i]", $id_link); 
    for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { 
        echo("<th>"); 
        echo $hash_field_names[$i][$ii]; 
        echo("</th>"); 
    } 
    echo("</tr><tr>"); 
    $number_of_rows = @mysql_num_rows($result); 
    for ($iii = 0; $iii < $number_of_rows; $iii++) { 
        $record = @mysql_fetch_row($result); 
        for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { 
            echo("<td>"); 
            echo $record[$ii]; 
            echo("</td>"); 
        } 
    echo("</tr>"); 
    } 
    echo("</table>"); 
} 



echo('</body></html>');

?>
 
 Notes 
getfile.txt is located in /mysql/data/netcheck/ ...or location of data 
page currently refreshes every 30 seconds

Need to show this: 
Green= 

Less 1% error all links 
Less 5% Bandwidth Util. 
Less 25% CPU Util. 
100% Connectivity

Yellow= 

2% error- 5% (Email WAN list) 
30 sec. loss of conn. (none) 
(clears after 5 min.) 
+ 5% Bandwidth Util. (Email WAN list) 
+ 25% CPU Util. (Email WAN list)

Red= 
6% or higher error (Email - x3 every (300sec) & page) 
30 sec loss x2 under (5 min) (Flash) 
+10% Bandwidth Util. (Audible Alarm) 
+50% CPU Util

</body>
</html>

the getfile text is tab-delimited (here's a sample):
5 Net 5 Bldg 25 2 0 2 100|
1 Net 1 Bldg 26 10 5 8 100|

the_Igel

If you wish your question to be answered, please cut off everything unimportant and enclose the code in [ php ] tag. Most people answer questions for fun, and there's no fun in trying to figure out what's not working in your code. 🙂

junkie_doodle

first of all the php already outputs a full HTML body, so the page layout is not right....

and here're the answers of your two questions

echo("</tr><tr>"); 
$number_of_rows = @mysql_num_rows($result); 
for ($iii = 0; $iii < $number_of_rows; $iii++) { 
$record = @mysql_fetch_row($result); 
for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { 
echo("<td>"); 
echo $record[$ii]; 
echo("</td>"); 
} 
echo("</tr>"); 
}

can be rewritten like this

echo("</tr><tr>"); 
$number_of_rows = @mysql_num_rows($result); 
for ($iii = 0; $iii < $number_of_rows; $iii++) { 
$record = @mysql_fetch_row($result); 
for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { 
echo("<td>"); 
echo $record[$ii]; 
echo("</td>");

//here i edit

echo "<td";
// is $record[$ii] odd? then dont give bgcolor, else bgcolor=#ffdddd
$record[$ii] & 1? : echo  ">": echo " bgcolor=\"#ffdddd\">";

echo "&nbsp;<td>";

//here it ends 

} 
echo("</tr>"); 
}

hope it helps...

-- added a missing semi column [01/10/2002 | 02:24 am]

bluetiger

I added the lines you suggested got this:
Parse error: parse error in C:\apache\htdocs\netcheck3.php on line 72 --------->

    $number_of_rows = @mysql_num_rows($result); 
    for ($iii = 0; $iii < $number_of_rows; $iii++) { 
        $record = @mysql_fetch_row($result); 
        for ($ii=0; $ii < $arr_num_fields[$i]; $ii++) { 
            echo("<td>"); 
            echo $record[$ii]; 
            echo("</td>"); 
			//here i edit		
			echo "<td";
			// is $record[$ii] odd? then dont give bgcolor, else bgcolor=#ffdddd
			$record[$ii] & 1? : echo  ">": echo " bgcolor=\"#ffdddd\">
			echo "&nbsp;<td>";
			//here it ends 
	} 
    echo("</tr>"); 
    } 
    echo("</table>"); 
}

bluetiger

I added an extra field to the table so now the code displays an extra column that is rendered blank.
How can a get that field to display colors based on whether values in the previous 4 fields meet certain criteria?

Does that even make sense?

I am such a newbie today