根据标准将css类添加到mysql结果中

Question

I populate a list of dates from a MySQLdatabase like this:

<?php
    while ($row = mysql_fetch_array($list_customers)) {
        echo "<tr>
";
            echo "<td>".$row['customer_date']."</td>
";
        echo "</tr>
";
    }
?>

Now I would like to add the result inside a <span> that changes class='' based on some criteria:

• If date result is within a 30 days reach from todays date, add class='yellow'
• If date result is over 30 days from today, add class='green'
• If date result has passed, based on todays date, add class='red'

Would this be possible? Thanks in advance.

Answer 1

Yes it is. Just compare your date with current time using a series of if statements and assign a variable to the class name, like this:

while ($row = mysql_fetch_query($list_customers)) {
    echo "<tr>
";
    $class = "class='green'";
    if (strtotime($row['customer_date']) < time()) {
        $class = "class='red'";
    }elseif (strtotime($row['customer_date']) < time() + 30*24*3600) {
        $class = "class='yellow'";
    }
    echo "<td><span $class>" . $row['customer_date'] . "</span></td>
";
    echo "</tr>
";
}