I want to change color of the whole line depends of duration of the date. Example, If duration of the date is between 3 and 6 color is orange; more than 6 must be show as red. May I know How can I make that?
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>";
}
Above code is in php how I count for cycle time tab. For dt_issue, it use with now() while inserting to query. I will insert the screenshot below.

Advertisement
Answer
You can try this to change the color of the font depends on daysdiff
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>";
And if you want to change the color of the whole line , you should do it before echo the <tr> tag , like echo "<tr style="color:$color">";
Whole line example:
foreach ($ary_list as $k => $v) {
$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 "<tr style="color:$color" bgcolor="#F5F5F5">";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["seal_area"]. "     ";
echo "</font>n";
echo "</td>n";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["seal_barcode"]. "     ";
echo "</font>n";
echo "</td>n";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["dt_issue"]. "     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["issue_admin"]. "     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["receive_by"]."     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["receive_id"]."     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["dt_return"]."     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["return_admin"]."     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["return_by"]. "     ";
echo "</font>n";
echo "</td>";
echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >n";
echo "  " .$v["return_id"]."     ";
echo "</font>n";
echo "</td>";
/*echo "<td nowrap ".$rowspan.">n";
echo "<font face="arial" size="1" >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";
echo "<font face="arial" size="1" color="$color">n";
echo "  " .$daysDiff."     ";
echo "</font>n";
echo "</td>";
echo "</tr>";
}