<td>' . gethari($hari) . '</td> </tr>'; $admin .= '<tr> <td>Jam Ke</td> <td>:</td> <td>' . getjam($jamke) . '</td> </tr>'; $admin .= ' <tr> <td>Mata Pelajaran</td> <td>:</td> <td><select name="matpel" class="form-control" id="matpel" required>'; $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>';
<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;