php - 向 2 行的每个第二个结果添加样式，然后跳过 2 个结果？

Question

这句话说起来有点棘手；

我想做的是添加样式“background-color: black;”仅查询我的查询中的一些结果。

所以，如果我要回显我的结果，它会像这样显示；

1st result no style
2nd result black
3rd result black
4th result no style
5th result no style
7th result black
8th result black
9th result no style
10th result no style

我的查询

$getusers= $db->query("SELECT * FROM users");
    while($users= $getusers->fetch_assoc()) {

    $color = ??????????????? not sure

    echo '<div style="background-color: ' . $color . ';">';
    echo $users['username'];
    echo '</div>';
}

Answer 1

使用占位符变量。

遵循下面示例中 $i 的进展。

$getusers= $db->query("SELECT * FROM users");

// Starting at 2 will cause "no style" to happen only once on first pass.
$i = 2; 

while($users= $getusers->fetch_assoc()) {

    // if $i is 3 or 4 value would be "black"
    $rowBg = "background-color:black";

    // Set to an empty string (no style) if $i is 1 or 2.
    if($i <= 2) {
        $rowBg = "";
    }

    $i++;

    // Start over!
    if($i > 4)
        $i = 1;

    echo '<div style="' . $rowBg . ';">';
    echo $users['username'];
    echo '</div>';
}