<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>"; } */