PHP getidjabatan Examples

Example #1

File: admin_guru.php Project: rekysda/akademik

	<td>Mata Pelajaran</td>
		<td>:</td>
	<td><select name="matpel" class="form-control" id="matpel"required>';
        $hasilj = $koneksi_db->sql_query("SELECT * FROM akad_matpel ORDER BY nama asc");
        $admin .= '<option value="">== Mata Pelajaran ==</option>';
        while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
            $pilihan = $datasj['id'] == $matpel ? "selected" : '';
            $admin .= '<option value="' . $datasj['id'] . '"' . $pilihan . '>' . $datasj['nama'] . '</option>';
        }
        $admin .= '</select></td>
</tr>';
        $admin .= '<tr>
	<td>Guru</td>
		<td>:</td>
	<td><select name="guru" class="form-control" id="guru"required>';
        $idjabatan = getidjabatan('guru');
        $hasilj = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan where jabatan='{$idjabatan}'  ORDER BY nama asc");
        $admin .= '<option value="">== Nama Guru ==</option>';
        while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
            $pilihan = $datasj['id'] == $guru ? "selected" : '';
            $admin .= '<option value="' . $datasj['id'] . '"' . $pilihan . '>' . $datasj['nama'] . ' (' . $datasj['nip'] . ')</option>';
        }
        $admin .= '</select></td>
</tr>';
        $admin .= '
	<tr>
		<td>SKS Max Per Minggu</td>
		<td>:</td>
		<td><input type="text" name="sks" value="' . $sks . '" size="30" class="form-control"required></td>
	</tr>
	<tr>

Example #2

File: admin_lokasi.php Project: rekysda/akademik

</tr>';
        $admin .= '<tr>
		<td>Alamat</td>
		<td>:</td>
		<td><input type="text" name="alamat" value="' . $alamat . '" size="30" class="form-control"required></td>
	</tr>
		<tr>
		<td>Telepon</td>
		<td>:</td>
		<td><input type="text" name="telepon" value="' . $telepon . '" size="30" class="form-control"required></td>
	</tr>';
        $admin .= '<tr>
	<td>Kepala Sekolah</td>
		<td>:</td>
	<td><select name="kepsek" class="form-control" id="kepsek"required>';
        $idjabatan = getidjabatan('kepala sekolah');
        $hasilj = $koneksi_db->sql_query("SELECT * FROM hrd_karyawan where jabatan='{$idjabatan}' ORDER BY nama asc");
        $admin .= '<option value="">== Kepala Sekolah ==</option>';
        while ($datasj = $koneksi_db->sql_fetchrow($hasilj)) {
            $pilihan = $datasj['id'] == $kepsek ? "selected" : '';
            $admin .= '<option value="' . $datasj['id'] . '"' . $pilihan . '>' . $datasj['nama'] . ' (' . $datasj['nip'] . ')</option>';
        }
        $admin .= '</select></td>
</tr>';
        $admin .= '
	<tr>
		<td></td>
		<td></td>
		<td>
		<input type="submit" value="Simpan" name="submit"class="btn btn-success">&nbsp;
		<a href="?pilih=lokasi&amp;mod=yes"><span class="btn btn-warning">Batal</span></a>