Color Coded Table Grid

denzlite

Hello. Was wondering if there was a way to modify the following code:

http://www.unix.com.ua/orelly/webprog/pcook/ch04_27.htm

What I would like to do is to make the background of a td a certain color depending on - say - a "status" row within mysql table (0 is pending and would be brown, 1:accepted:green and so on).

Thanks.

NogDog

In your stylesheet:

.pending { background-color: #ffcc66; }
.accepted { background-color: #66ff66; }
/* etc.... */
.default { background-color: #ffffff; }

In your PHP page:

<?php
$status = array(
   0 => 'pending',
   1 => 'accepted'
   /* etc.... */
);
// start output of table, then...
$class = (isset($status[$row['status']])) ? $status[$row['status']] : 'default';
echo "<td class='$class'>$row['something']</td>";

denzlite

Thanks. Don't I need some kind of if/then statement to evaluate a mysql row where the status value is stored? If I'm outputting a table with no sort feature how can the isset be anything other than default?

Thanks much.

NogDog

I'm assuming you've done some sort of query of the database already. In the example code I'm pretending that any given query result row has been fetched via mysql_fetch_assoc() or something similar to populate the array $row, and that one of the columns fetched was a "status" column, which will then be one of the elements of the $row array. Further, from your original message, I'm assuming that $row['status'] will therefore have some integer value: 0, 1, 2, etc.

The keys of the array $status correspond to the expected values of $row['status'] (i.e., the "status" column). Therefore, using the value of $row['status'] as an index to the $status array should give the desired value for the class attribute in the HTML being output.

The isset() part of the code is simply being used just in case some status value is returned from the DB that is not accounted for in the $status array, setting the class name to 'default' if it's not set.

denzlite

Excellent. Thanks much.