PHP，Bootstrap - 根据数字范围更改范围标签

Question

I am showing statistics from my database, if the number is between 80 and 99 I want the label to be label-success, if the number is between 51 and 79 label-warning and if the number is between 0 and 50 label-danger.

Something like this:

    $query = $db->query("SELECT * FROM stats");
    foreach ($query as $row) {

                $points = $row['points'];
            $votes = $row['votes'];


$postclass = "";

foreach (range(0,50) as $row) {
    $posclass = "danger";
}

foreach (range(51,79) as $row) {
    $posclass = "warning";
}

foreach (range(80,99) as $row) {
    $posclass = "success";
}


echo '
<span class="label label-'.$posclass.'" >'.$points.'</span>
<span class="label label-'.$posclass.'" >'.$votes.'</span>
';

}

Thanks!

Answer 1

This is busted an bizarre, you are looping over a range of numbers and assigning the number to $row... If I'm understanding your desire, I think you need to change your code to look like this, specifically on each row to see if the $points value is within a particular range.

Last update adds a seperatelabel for Points and Votes

$postclass = "";
if ($points > 0 && $points <= 50) {
    $pointsLabel = "danger";
} else if ($points > 50 && $points <= 79) {
    $pointsLabel = "warning";
} else {
    $pointsLabel = "success";
}

if ($votes > 0 && $votes<= 50) {
    $votesLabel = "danger";
} else if ($votes> 50 && $votes<= 79) {
    $votesLabel = "warning";
} else {
    $votesLabel = "success";
}

echo '
<span class="label label-'.$pointsLabel.'" >'.$points.'</span>
<span class="label label-'.$votesLabel.'" >'.$votes.'</span>
';