$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&amp;mod=yes&amp;aksi=del&amp;user='******'" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Siswa Ini ?\')"><span class="btn btn-danger">Hapus</span></a>&nbsp;<a href="?pilih=importsiswa&amp;mod=yes&amp;aksi=inputkelas&amp;user='******'"><span class="btn btn-warning">Input Kelas</span></a></td>';
                $admin .= '
</tr>';
            }
        }
        $admin .= '</tbody></table>';
        $admin .= '</div>';
    }
}
echo $admin;
示例#3
0
       $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'];