I want to change the color of the entire row based on the duration of the date. For example, if the date's duration is between 3 and 6, the color is orange; more than 6 must be displayed in red. May I know how I can do this?
foreach ($ary_list as $k => $v) { $color= xxx; echo "<tr style=\"color:$color\">"; echo "<tr bgcolor=\"#F5F5F5\">\n"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["seal_area"]. "     "; echo "</font>\n"; echo "</td>\n"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["seal_barcode"]. "     "; echo "</font>\n"; echo "</td>\n"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["dt_issue"]. "     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["issue_admin"]. "     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["receive_by"]."     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["receive_id"]."     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["dt_return"]."     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["return_admin"]."     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["return_by"]. "     "; echo "</font>\n"; echo "</td>"; echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; echo "  " .$v["return_id"]."     "; echo "</font>\n"; echo "</td>"; /*echo "<td nowrap ".$rowspan.">\n"; echo "<font face=\"arial\" size=\"1\" color=\"#3C5F84\">\n"; $now = time(); // or your date as well $your_date = strtotime($v["dt_issue"]); $datediff = $now - $your_date; //echo round($datediff / (60 * 60 * 24)); //echo $datediff->format('%R%a days'); echo "  " .round($datediff / (60 * 60 * 24))."     "; echo "</font>\n"; echo "</td>";*/ echo "<td nowrap ".$rowspan.">\n"; $now = time(); $your_date = strtotime($v["dt_issue"]); $datediff = $now - $your_date; $daysDiff = round($datediff / (60 * 60 * 24)); $color = $daysDiff < 3 ? '#3C5F84' : ($daysDiff <= 6 ? 'orange' : 'red'); echo "<font face=\"arial\" size=\"1\" color=\"$color\">\n"; echo "  " .$daysDiff."     "; echo "</font>\n"; echo "</td>"; echo "</tr>"; }
The above code is how I calculate cycle time tab in php. For dt_issue, this is used with now() when inserting the query. I'll insert a screenshot below.
You can try changing the font color based on daysdiff