<th>Aksi</th>
</tr>
</thead>';
$hasil = $koneksi_db->sql_query("SELECT * FROM akad_siswalomba order by tgl desc");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$tgl1 = $data['tgl'];
$siswa = $data['siswa'];
$kelas = $data['kelas'];
$lomba = $data['lomba'];
$pic = $data['pic'];
$hasillomba = $data['hasillomba'];
$admin .= '<tr>
<td>' . datetimes($tgl1, false, false) . '</td>
<td>' . getsiswa($siswa) . '</td>
<td>' . getkelas($kelas) . '</td>
<td>' . getlomba($lomba) . '</td>
<td>' . $pic . '</td>
<td>' . $hasillomba . '</td>
<td><a href="?pilih=siswalomba&mod=yes&aksi=del&id=' . $data['id'] . '&siswa=' . $siswa . '" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Data Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=siswalomba&mod=yes&aksi=edit&id=' . $data['id'] . '"><span class="btn btn-warning">Edit</span></a></td>
</tr>';
}
$admin .= '</tbody></table>';
$admin .= '</div>';
}
if ($_GET['aksi'] == '') {
$admin .= '<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">Daftar Siswa</h3></div>';
$admin .= '
<table id="example"class="table table-striped table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
$no = 1;
$hasil = $koneksi_db->sql_query("SELECT * FROM akad_siswalomba where tgl between '{$tgl1}' and '{$tgl2}' and siswa='{$idsiswa}' order by tgl asc");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$id = $data['id'];
$tgl = $data['tgl'];
$kelas = $data['kelas'];
$siswa = $data['siswa'];
$pic = $data['pic'];
$lomba = $data['lomba'];
$hasillomba = $data['hasillomba'];
echo '<tr height="25">
<td align="center">' . $no . '</td>
<td align="center">' . tanggalindoshort($tgl) . '</td>
<td align="center">' . getkelas($kelas) . '</td>
<td align="left">' . $pic . '</td>
<td align="left">' . getlomba($lomba) . '</td>
<td align="left">' . $hasillomba . '</td>
</tr>';
$no++;
}
echo '
<!-- END TABLE CONTENT -->
</table> ';
echo "</body></html>";
/*
if (isset($_GET['tglmulai'])){
echo "<script language=javascript>
window.print();
</script>";
}
*/
