$kelasid = $_POST['kelasid'];
$kelas = getkelas($kelasid);
$namaujian = getnamaujian($idujian);
$namaguru = getnamaguruujian($idujian);
header("Content-Type: application/force-download");
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sat, 26 Jul 2010 05:00:00 GMT");
header("content-disposition: attachment;filename=elearning_nilaiujian_" . $kelas . ".xls");
echo "<table>\n<tr><td colspan='2'></td>\n<td><b>LAPORAN NILAI SISWA</b></td>\n</tr>";
echo " <tr>\n <td colspan='2'></td>\n <td></td>\n </tr>";
echo " <tr>\n <td colspan='2'>Kelas </td>\n <td>{$kelas}</td>\n </tr>";
echo " <tr>\n <td colspan='2'>Nama Ujian </td>\n <td>{$namaujian}</td>\n </tr>";
echo " <tr>\n <td colspan='2'>Nama Guru </td>\n <td>{$namaguru}</td>\n </tr>";
echo " <tr>\n <td colspan='2'></td>\n <td></td>\n </tr></table>";
echo "<table border='1'>\n<tr bgcolor='#ECECEC'>\n <th>No.</th>\n <th>No.Induk</th>\n <th>Nama</th>\n <th>Nilai</th>\n </tr>";
/************************************/
$no = '1';
$hasil = $koneksi_db->sql_query("SELECT * FROM `kelas_isi`where kelas ='{$kelasid}'");
while ($data = $koneksi_db->sql_fetchrow($hasil)) {
$namasiswa = getnamasiswa($data['siswa']);
$nilaiujian = getnilaiujian($idujian, $data['siswa']);
echo '
<tr>
<td>' . $no . '</td>
<td>' . $data['siswa'] . '</td>
<td>' . $namasiswa . '</td>
<td>' . $nilaiujian . '</td>
</tr>';
$no++;
}
echo "</table>";
<table id="example" class="table table-striped table-bordered" cellspacing="0">
<thead>
<tr>
<th>Kelas</th>
<th>Username</th>
<th>Nama</th>
<th width="220px">Aksi</th>
</tr>
</thead>';
$admin .= '<tbody>';
$sql = "SELECT * FROM `useraura` where level ='Siswa' order by user asc";
$query = mysql_query($sql);
while ($data = mysql_fetch_array($query)) {
$id = $data['UserId'];
$siswa = $data['user'];
$kelas = getkelasisi($siswa);
if (!$kelas) {
$admin .= '<tr>
<td>' . $kelas . '</td>
<td>' . $siswa . '</td>
<td>' . getnamasiswa($siswa) . '</td>';
$admin .= '<td><a href="?pilih=importsiswa&mod=yes&aksi=del&user='******'" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Siswa Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=importsiswa&mod=yes&aksi=inputkelas&user='******'"><span class="btn btn-warning">Input Kelas</span></a></td>';
$admin .= '
</tr>';
}
}
$admin .= '</tbody></table>';
$admin .= '</div>';
}
}
echo $admin;
$namakelas = getkelas($kelasaktif);
$admin .= '<div class="panel panel-info">';
$admin .= '<div class="panel-heading"><b>Pengumuman Sekolah</b></div>';
$admin .= '
<ul class="bxslider">
';
$hasil2 = $koneksi_db->sql_query("SELECT * FROM pengumuman_sekolah order by tgl desc limit 5 ");
while ($data2 = $koneksi_db->sql_fetchrow($hasil2)) {
$judul2 = $data2['judul'];
$konten2 = $data2['konten'];
$tgl = datetimes($data2['tgl']);
$admin .= "<li><div class='slideshow'><h3>{$judul2}</h3>\n\t<table><tr><td align='right'><span class='label label-warning'>{$tgl}</span></td></tr>\n\t<tr><td>\n <p>{$konten2}</p>\n\t</td></tr></table>\n </div>\n </li>";
}
$admin .= '</ul>';
$admin .= '<div class="panel-heading"><b>Data profil</b></div>';
$getnamasiswa = getnamasiswa($user);
$admin .= "<table class='table'>";
$admin .= "<tr><td>Nama</td><td>:</td><td>{$getnamasiswa}</td></tr>";
$admin .= "<tr><td>Kelas</td><td>:</td><td>{$namakelas}</td></tr>";
$admin .= "</table>";
$admin .= '</div>';
}
if ($_SESSION['LevelAkses'] == "Guru") {
$admin .= '<div class="panel panel-info">';
$admin .= '<div class="panel-heading"><b>Pengumuman Sekolah</b></div>';
$admin .= '
<ul class="bxslider">
';
$hasil2 = $koneksi_db->sql_query("SELECT * FROM pengumuman_sekolah order by tgl desc limit 5 ");
while ($data2 = $koneksi_db->sql_fetchrow($hasil2)) {
$judul2 = $data2['judul'];