Help me with a PHP code that will be changing tables rows colors

[zamzam]

Hello People,
Help me with a PHP code that will be changing tables rows colors as they being displayed. I have sql that is pulling records from a database and being displayed on a table on web page in rows. Now I want PHP or java scripts that make one row appear as red then next row as blue and next red just like that.

Thanks in advance.

[guido2004]

Create 2 styles for table rows in your CSS, one with background color red, the other blue.
Then, in the loop that creates the table, use a variable (boolean for example) to decide which style to give to the current row.

[Shrapnel_N5]

Do you want advice, how to do it or ready-made code?
That is very simple though.
A variable and a condition.

if ($color=="blue") $color="red";
else $color="blue"; 

Hope you have an idea, how PHP works, to paste this code into right place.

[zamzam]

Please give an example. I have not manage to figure out the way to do it

[dmcleary]

Hi zamzam,

$rowColour = 0;

while($myrow = mysql_fetch_array($find_rows)){

echo "<div style=\"background:" . ($rowColour&#37;2 ? '#000' : '#fff') . ";\">" . $myrow['data'] . "</div>";

$rowColour++;

}

I'm sure there are more ways to do it but that one should work and I find to be quite compact.

Regards,


David

[mmarif4u]

Simple Example with for loop:

<?php
$num = 1;
echo "<table border='1'>";
$no = 1;
for($num; $num <= 6; $num++){
if($no &#37; 2 == 0){
$font ="red";
}
elseif($no % 2 == 1){
$font ="blue";
}
echo "<tr>";
echo "<td><font color=$font>name</font></td>";
echo "</tr>";

$no++;
}
echo "</table>";
?>

While loop with query:

<?php
echo "<table border='1'>";
$no = 1;
while(your query){
if($no % 2 == 0){
$font ="red";
}
elseif($no % 2 == 1){
$font ="blue";
}
echo "<tr>";
echo "<td><font color=$font>name</font></td>";
echo "</tr>";

$no++;
}
echo "</table>";
?>

You can set it for background of the rows.

[Andrew E.]

Or you can use js

Here is how I would do it in jquery:

$("tr:even").css("background-color", "red");
$("tr:odd").css("background-color", "blue");

[PHPycho]

The way i do is to use the function as follow:

//usage

$i = 0;
foreach($array as $key => $val){
?>
<tr<?=altColor($i)?>>
....
</tr>
<?php
 $i++;
}

function:

function altColor($count, $row1 = "class1", $row2 = "class2"){
    $row = "";
    if($count%2 == 0){
        $row = " class='".$row1."'";
    } else{
        $row = " class='".$row2."'";
    }
    return $row;
} 

[PHPycho]

The way i do is to use the function as follow:

//usage

$i = 0;
foreach($array as $key => $val){
?>
<tr<?=altColor($i)?>>
....
</tr>
<?php
 $i++;
}

function:

function altColor($count, $row1 = "class1", $row2 = "class2"){
    $row = "";
    if($count%2 == 0){
        $row = " class='".$row1."'";
    } else{
        $row = " class='".$row2."'";
    }
    return $row;
} 

Additionally you can do alternation @ load time using javascript(jquery etc.)

[Vali]

Or you can use js

Here is how I would do it in jquery:

$("tr:even").css("background-color", "red");
$("tr:odd").css("background-color", "blue");

Use jQuery, and your site will be much simpler.

[kamm]

This is the one I like - stick this in your loop...

$class = ($class == 'even') ? 'odd' : 'even'; 

<tr class="$class">

[oddz]

http://www.sitepoint.com/forums/show...35#post4393834

[Shrapnel_N5]

Not much of these numerous advisors ever think of template use

[oddz]

<?php
$arrRows = array('one','two','three','four','five','six');
$cycle = false;
?>
<table>
    <thead>
        <tr>
            <th>Num</th>
        </tr>
    </thead>
    <tbody><?php
    foreach($arrRows as $arrRow) {
        printf('<tr style="background-color:%s;"><td>%s</td></tr>',(($cycle =! $cycle)?'red':'yellow'),$arrRow);
    }
    ?></tbody>
</table>