<th>SKS</th> <th>Status</th> <th>Aksi</th> </tr> </thead>'; $hasil = $koneksi_db->sql_query("SELECT * FROM akad_guru"); while ($data = $koneksi_db->sql_fetchrow($hasil)) { $jenjang = $data['jenjang']; $tingkat = $data['tingkat']; $lokasi = $data['lokasi']; $matpel = $data['matpel']; $guru = $data['guru']; $sks = $data['sks']; $status = $data['status']; $admin .= '<tr> <td>' . getlokasi($lokasi) . '</td> <td>' . getjenjang($jenjang) . ' / ' . gettingkat($tingkat) . '</td> <td>' . getdataguru("nama", $guru) . '</td> <td>' . getdataguru("nip", $guru) . '</td> <td>' . getmatpel($matpel) . '</td> <td>' . $sks . '</td> <td>' . $status . '</td> <td><a href="?pilih=guru&mod=yes&aksi=del&id=' . $data['id'] . '" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Data Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=guru&mod=yes&aksi=edit&id=' . $data['id'] . '"><span class="btn btn-warning">Edit</span></a></td> </tr>'; } $admin .= '</tbody></table>'; /************************************/ } echo $admin;
$hasilj = $koneksi_db->sql_query("SELECT *FROM akad_guru where tingkat = '{$tingkat}' ORDER BY id asc"); $admin .= '<option value="">== Pilih Mata Pelajaran ==</option>'; while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) { $admin .= '<option value="' . $datasj['matpel'] . '">' . getmatpel($datasj['matpel']) . '</option>'; } $admin .= '</select></td> </tr>'; $admin .= ' <tr> <td>Guru</td> <td>:</td> <td><select name="guru" class="form-control" id="guru" required>'; $hasilj = $koneksi_db->sql_query("SELECT * FROM akad_guru ORDER BY id asc"); $admin .= '<option value="">== Pilih Guru ==</option>'; while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) { $admin .= '<option value="' . $datasj['guru'] . '"class="' . $datasj['matpel'] . '"' . $pilihan . '>' . getdataguru('nama', $datasj['guru']) . '</option>'; } $admin .= '</select></td> </tr>'; $admin .= ' <tr> <td></td> <td></td> <td> <input type="hidden" name="lokasi" value="' . $lokasi . '"> <input type="hidden" name="jenjang" value="' . $jenjang . '"> <input type="hidden" name="tingkat" value="' . $tingkat . '"> <input type="hidden" name="kelas" value="' . $kelas . '"> <input type="hidden" name="tahunajaran" value="' . $tahunajaran . '"> <input type="hidden" name="hari" value="' . $hari . '"> <input type="hidden" name="jam" value="' . $jamke . '">
<table id="example"class="table table-striped table-bordered" cellspacing="0" width="100%"> <thead> <tr> <th>Nama</th> <th>Jenjang</th> <th>Alamat</th> <th>Telepon</th> <th>Kepala Sekolah</th> <th>Aksi</th> </tr> </thead>'; $hasil = $koneksi_db->sql_query("SELECT * FROM departemen order by replid asc"); while ($data = $koneksi_db->sql_fetchrow($hasil)) { $nama = $data['nama']; $jenjang = $data['keterangan']; $kepsek = $data['kepsek']; $alamat = $data['alamat']; $telepon = $data['telepon']; $admin .= '<tr> <td>' . $nama . '</td> <td>' . getjenjang($jenjang) . '</td> <td>' . $alamat . '</td> <td>' . $telepon . '</td> <td>' . getdataguru('nama', $kepsek) . '</td> <td><a href="?pilih=lokasi&mod=yes&aksi=del&id=' . $data['replid'] . '" onclick="return confirm(\'Apakah Anda Yakin Ingin Menghapus Data Ini ?\')"><span class="btn btn-danger">Hapus</span></a> <a href="?pilih=lokasi&mod=yes&aksi=edit&id=' . $data['replid'] . '"><span class="btn btn-warning">Edit</span></a></td> </tr>'; } $admin .= '</tbody></table>'; /************************************/ } echo $admin;