查詢資料表 cdmobile,輸出所有欄位,滿足以下任一條件的欄位值以紅色顯示:
syntime 小於「當前時間前一週」 (即超過一週未同步)。a 欄位值為 無。b 欄位值為 無。<?php
// 資料庫連接 (建議 PDO)
$pdo = new PDO('mysql:host=localhost;dbname=your_db;charset=utf8mb4', 'user', 'pass');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "SELECT username, onoff, intime, syntime, device, a, b, person, dtime
FROM cdmobile
ORDER BY username DESC";
$stmt = $pdo->query($sql);
$rows = $stmt->fetchAll();
// 計算「一週前」時間戳 (當前時間 - 7 天)
$weekAgo = strtotime('-7 days');
// 輸出表格
echo '';
echo '';
foreach (['username','onoff','intime','syntime','device','a','b','person','dtime'] as $col) {
echo "$col ";
}
echo ' ';
foreach ($rows as $row) {
echo '';
// username
echo '' . htmlspecialchars($row['username']) . ' ';
// onoff
echo '' . htmlspecialchars($row['onoff']) . ' ';
// intime
echo '' . htmlspecialchars($row['intime']) . ' ';
// syntime - 條件 1
$synTime = $row['syntime'];
$synTs = strtotime($synTime);
$isLate = $synTs < $weekAgo; // 小於一週前 = 逾期
$style = $isLate ? 'style="color:red;"' : '';
echo "" . htmlspecialchars($synTime) . ' ';
// device
echo '' . htmlspecialchars($row['device']) . ' ';
// a - 條件 2
$aVal = $row['a'];
$aRed = ($aVal === '無');
$style = $aRed ? 'style="color:red;"' : '';
echo "" . htmlspecialchars($aVal) . ' ';
// b - 條件 3
$bVal = $row['b'];
$bRed = ($bVal === '無');
$style = $bRed ? 'style="color:red;"' : '';
echo "" . htmlspecialchars($bVal) . ' ';
// person
echo '' . htmlspecialchars($row['person']) . ' ';
// dtime
echo '' . htmlspecialchars($row['dtime']) . ' ';
echo ' ';
}
echo '
';
$nowtime = strtotime('+7 day') 為未來時間,比較 $nowtime >= $syntime 永真。正確邏輯:$weekAgo = strtotime('-7 days'); $isLate = $synTs < $weekAgo。htmlspecialchars() 防 XSS,雙重保障 (資料庫層面也應過濾)。mysql_* 函數,支援預處理、異常處理。<style>
.table-red { color: #dc3545; font-weight: bold; }
</style>
<?php
// 在循環中
$class = $isLate ? 'class="table-red"' : '';
echo "" . htmlspecialchars($synTime) . ' ';
// ...
<?php
$highlightRules = [
'syntime' => fn($val) => strtotime($val) < strtotime('-7 days'),
'a' => fn($val) => $val === '無',
'b' => fn($val) => $val === '無',
];
foreach ($rows as $row) {
echo '';
foreach ($row as $col => $val) {
$red = isset($highlightRules[$col]) && $highlightRules[$col]($val);
$class = $red ? 'class="table-red"' : '';
echo "" . htmlspecialchars($val) . ' ';
}
echo ' ';
}
將業務規則抽離為可配置陣列,新增/修改條件無需動核心邏輯,符合開閉原則。