Bulan : /
| No |
Tanggal |
Hari |
Masuk |
Pulang |
";
echo "".$no." | ";
echo "".$data['tgl']." | ";
echo "".$hariindo." | ";
$dt = "SELECT TIME_FORMAT(checktime,'%H:%i') AS a from checkinout
where date(checktime)='$hr' and userid='$dari' and hour(checktime)<12 group by date(checktime) order by time(checktime) limit 1;";
$sql2 = mysqli_query($con,$dt);
$dt1 = mysqli_fetch_assoc($sql2);
$dtp = " SELECT TIME_FORMAT(checktime,'%H:%i') AS b from checkinout
where date(checktime)='$hr' and userid='$dari' and hour(checktime)>15 group by date(checktime) order by time(checktime) desc limit 1;";
$sql21 = mysqli_query($con,$dtp);
$dt11 = mysqli_fetch_assoc($sql21);
echo " ".($dt1['a'])." | ";
echo " ".($dt11['b'])." | ";
echo "
";
$no++;
}
?>