PHP while loop, even/odd rows returned

Question

I have a PHP loop that displays data for a particular posting on my website. What I want to do is dynamically assign either and even/odd CSS class for the number of row that is returned. For example,

first row returned - odd class
second row returned - even class
third row - odd class

This will allow me to assign different background colors to keep the data visually separate.

I should clarify - this data isn't being returned in a table.

 while ($row = mysql_fetch_assoc($result)) {

    echo "
    <div class=\"songContainer\" id=\"" . $row['trackid'] . "\">

What is your question? What have you tried so far? Please post some code. Please use the search function of the site (because this looks like a duplicate question). — hakre
– hakre, Commented Nov 18, 2011 at 3:10
Quicker to have a frontend jquery code like datatables.com - google jquery table display plugin. — Alvin K.
– Alvin K., Commented Nov 18, 2011 at 3:10
possible duplicate of php: how to add odd/even loop in array — hakre
– hakre, Commented Nov 18, 2011 at 3:11

Pascal · Accepted Answer · 2011-11-18 03:10:09Z

14

Depending on which browsers you have to target, you could just do that with CSS:

.mytable tr:nth-child(even) { background-color: #FFF; }
.mytable tr:nth-child(odd) { background-color: #EEE; }

You can even do more complex things with this pseudo-class: http://www.quirksmode.org/css/nthchild.html

If you really need PHP, use a modulo:

$i = 0;
foreach ($arr as $val) {
    if (0 == $i % 2) {
        // even
    }
    else {
        // odd
    }
    $i++;
}

answered Nov 18, 2011 at 3:10

Pascal

17k4 gold badges62 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Moe Sweet · Accepted Answer · 2011-11-18 03:09:52Z

2

nth-child class is supported in CSS3 like this.

table tr:nth-child(even) td{

}

table tr:nth-child(odd) td{

}

But if you're to support older ones too, you have no choice but to generate class names by PHP.

answered Nov 18, 2011 at 3:09

Moe Sweet

3,7013 gold badges37 silver badges46 bronze badges

Comments

Charlie Brown · Accepted Answer · 2011-11-18 03:10:41Z

1

$num_rows = 0;
$current_class = "";
while ($row = mysql_fetch_array($result)){
    $current_class = "class_odd";
    if($num_rows % 2 == 0){
        $current_class = "class_even";
    }

    $num_rows++;
}

answered Nov 18, 2011 at 3:10

Charlie Brown

14410 bronze badges

Comments

Purag · Accepted Answer · 2011-11-18 03:10:15Z

0

Use this jQuery:

$("tr:nth-child(2n)").addClass("even")
  .prev().addClass("odd");

It selects every second tr element and adds an even class to it. Then it selects the previous tr element and adds an odd class to it.

Example.

answered Nov 18, 2011 at 3:10

Purag

17.1k4 gold badges57 silver badges78 bronze badges

Comments

Bjoern Borg · Accepted Answer · 2019-08-19 09:21:14Z

0

When using php you can use this instead of modulo suggested by Pascal:

    $i = 0;
    foreach ($arr as $val) {
        if ( $i = 1 - $i ) {
            // even
        }
        else {
            // odd
        }
    }

answered Aug 19, 2019 at 9:21

Bjoern Borg

594 bronze badges

Collectives™ on Stack Overflow

PHP while loop, even/odd rows returned

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related