php - 根据条件更改 颜色

Question

您好，我有这个 PHP，它采用 sql 查询将其分成两列并打印表格。现在我需要更改值 > 0 的 TD 的颜色。我按类别添加了颜色更改。它有效但不正确。它会改变整个字符串的颜色，但不会改变 TD 单元的颜色。

$stmt=ociparse($olink, $sql);
if (!$stmt) {
    $e = oci_error($olink); 
    trigger_error(htmlentities($e['message']), E_USER_ERROR);
}
$r =ociexecute($stmt,OCI_NO_AUTO_COMMIT);
if (!$r) {
    $e = oci_error($stmt);  // For oci_execute errors pass the statement handle
    print htmlentities($e['message']);
    print "\n<pre>\n";
    print htmlentities($e['sqltext']);
    printf("\n%".($e['offset']+1)."s", "^");
    print  "\n</pre>\n";
}
$ncols = oci_num_fields($stmt);
$cur_dt = 1;
echo "<TABLE border=\"1\" width=\"100%\" align='center' cellspacing='0' cellpadding='0'  class=\"sortable\">";
/* echo "\n<tr>"; */
for ($i = 1; $i <= $ncols; $i++) {
echo "<th bgcolor=\"#2B75C1\" class=\"header\">".oci_field_name($stmt, $i)."</th>";
}
for ($i = 1; $i <= $ncols; $i++) {
echo "<th bgcolor=\"#2B75C1\" class=\"header\">".oci_field_name($stmt, $i)."</th>";
}
$str=1;
while (oci_fetch($stmt)) {
if ($str % 2 == 1)
{
    echo "\n";
echo "<tr";
$hrr="";
echo ">";
}
for ($i = 1; $i <= $ncols; $i++) {
echo "<td";
echo $hrr;
if (oci_result($stmt, 2) >= $cur_dt)  {$hrr= " class=\"hour\"";echo $hrr;}
echo ">";
echo oci_result($stmt, $i);
}
echo "</td>";
if ($str % 2 == 0) {echo "</tr> \n";}
$str++;
}
echo "</TABLE>";
oci_close($olink);
?>
</div>
</body>
</html>

0 in second column should be blue, but it ged "hour" class and change color

Answer 1

创建一个 class在你的css像 .change{background-color:green} 这样的文件在你的 <td>

for ($i = 1; $i <= $ncols; $i++) {
$hrr ="";
if (oci_result($stmt, 2) >= $cur_dt)  {$hrr = 'class="change"';}
echo "<td ".$hrr.">";
 echo oci_result($stmt, $i);
}
 echo "</td>";
if ($str % 2 == 0) {echo "</tr> \n";}
 $str++;
}