Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

ricardo1871's avatar

if date difference is more than 2 echo red else echo green

THis is pure php (sorry but badly need help) I was able to get the date difference of two dates but my goal is if the date diff is more than 2 days echo it red else is green here is my code:

$query_getCreatedDate3 = "select created_date as DesignqcDate, created_date as DesignqcDate2
                                                                         from lab_order_history
                                                                         where order_number = ".$res_dep['order_number']." and order_status = 'tech_design_qc'";
												$result_getCreatedDate = mysqli_query($con, $query_getCreatedDate3);
                                                $row_getCreatedDate = mysqli_fetch_array($result_getCreatedDate, MYSQLI_ASSOC);
												$DesignqcDate2 = $row_getCreatedDate['DesignqcDate2'];
                                                

                                                $result_getCreatedDate = mysqli_query($con, $query_getCreatedDate3);
                                                $row_getCreatedDate = mysqli_fetch_array($result_getCreatedDate, MYSQLI_ASSOC);

                                                $query_getCreatedDate2 = "select created_date as DesigningDate, created_date as DesigningDate2
                                                                         from lab_order_history
                                                                         where order_number = ".$res_dep['order_number']." and order_status = 'start_design_external'";

													$result_getCreatedDate = mysqli_query($con, $query_getCreatedDate2);
                                                    $row_getCreatedDate = mysqli_fetch_array($result_getCreatedDate, MYSQLI_ASSOC);
                                                    $DesigningDate  = $row_getCreatedDate['DesigningDate'];
													$DesigningDate2 = $row_getCreatedDate['DesigningDate2'];
                                                    $DesignqcDate2=date_create($DesignqcDate2);
												    $DesigningDate2=date_create($DesigningDate2);
													$diff=date_diff($DesignqcDate2,$DesigningDate2);

                                                     if($diff < 2){
                                                     	 echo '<span style="background-color:#2ecc71;border-radius: 30px;padding: 3px 5px;color: #fff;">'.$diff->format("$DesigningDate: %a Days").'</span>';
                                                     	}else {
                                                     		echo '<span style="background-color:#e74c3;border-radius: 30px;padding: 3px 5px;color: #fff;">'.$diff->format("$DesigningDate: %a Days").'</span>';
                                                     	}
 
												?></td>
0 likes
0 replies

Please or to participate in this conversation.