javascript - 使用 php java-script 和 html 创建跟踪器

Question

我正在使用 php java-script 和 html 创建一个跟踪器。我需要检查所有记录日期并突出显示（颜色）所有日期小于当前日期 30 天的单元格。
现在我正在通过以下代码获取数据

<?php
$sql = "select * from vendor";
$conn = Database::connect ();
$stmt = $conn->prepare ( $sql );
$result = $stmt->execute ();
if ($result) {
foreach ( $stmt->fetchAll ( PDO::FETCH_FUNC, 'feat_product' ) as $row ) {
}
}
?>

function feat_product($bgserial, $claimexpiry, $expirydate, $projectcode, 
$vendorname, $ponumber, $currency, $inhouse, $guarantee, $division, 
$issuedate, $bgtype) {

echo '<tr>';
echo '<td>' . $bgserial . '</td>';
echo '<td>' . $claimexpiry . '</td>';

echo '<td>' . $expirydate . '</td>';
echo '<td>' . $vendorname . '</td>';
echo '<td>' . $projectcode . '</td>';
echo '<td>' . $ponumber . '</td>';
echo '<td>' . $currency . '</td>';
echo '<td>' . $inhouse . '</td>';
echo '<td>' . $guarantee . '</td>';
echo '<td>' . $division . '</td>';
echo '<td>' . $issuedate . '</td>';
echo '<td>' . $bgtype . '</td>';
echo '</tr>';

}

标签： javascriptphphtml

Answer 1

我正在提交代码，只需根据您的变量输入变量名称：-

$today = date("d-m-Y") ;
$exp = date('d-m-Y',strtotime($exp_date));
$expDate =  date_create($exp);
$todayDate = date_create($today);
$diff = date_diff($todayDate, $expDate);
if ($diff->format("%R%a") < 30){
    //Your code here
}