permisi agan-agan
mohon maaf sebelumnya, saya punya permasalahan meload data tabel kesamping, ane cari-cari di mbah google ga ketemu
untuk inputan yang ane pingin kaya gini dan dibatasi sampe tanggal 30
ini koding aen gan, tapi masih meload kebawah
Quote:
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th width="34" rowspan="2" class="center">No</th>
<th width="34" rowspan="2" class="center">FingerPrintID</th>
<th width="137" rowspan = "2" class="center">EmployeeID</th>
<th width="137" colspan = "2" class="center">Jam Masuk</th>
<th width="137" colspan = "2" class="center">Jam Keluar</th>
<th width="160" colspan = "2" class="center">Terlambat</th>
<th width="230" colspan = "2" class="center">Cepat Pulang</th>
</tr>
<tr>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
<th scope="col">Jam</th>
<th scope="col">Menit</th>
</tr>
</thead>
<tbody>
<?php
$cek1 = '07:00:00';
$cek2= '16:00:00';
$query = mysql_query("Select id, FingerPrintID, EmployeeID, min(TimeLog) as Absensi_Masuk, max(TimeLog) as Absensi_Keluar,
timediff(TimeLog,'$cek1' ) as SelisihMasuk, timediff(Timelog,'$cek2') as SelisihKeluar from siswa
Group by FingerPrintID, EmployeeID");
$no=1;
while($row=mysql_fetch_array($query)){
$time1 = $row['Absensi_Masuk'];
$waktu1 = explode(":", $time1);
$time2 = $row['Absensi_Keluar'];
$waktu2 = explode(":", $time2);
$Selisih1 = $row['SelisihMasuk'];
$Masuk1 = explode(":", $Selisih1);
$Selisih2 = $row['SelisihKeluar'];
$Masuk2 = explode(":", $Selisih2);
//query untuk database
//menampilkan hasil query dalam bentuk array
?>
<tr class="odd gradeX">
<td><?php echo $no;?></td>
<td><?php echo $row['EmployeeID']?></td>
<td><?php echo $row['FingerPrintID']?></td>
<td><?php echo $waktu1[0];?></td>
<td><?php echo $waktu1[1];?></td>
<td><?php echo $waktu2[0];?></td>
<td><?php echo $waktu2[1];?></td>
<td><?php echo $Masuk1[0]?></td>
<td><?php echo $Masuk1[1]?></td>
<td><?php echo $Masuk2[0]?></td>
<td><?php echo $Masuk2[1]?></td>
</tr>
<?php $no++ ; } ?>
<tr>
<td colspan="3">Jumlah</td>
</tr>
</tbody>
</table>
mohon bantuannya gan, hatur nuhun...