PHP getdataguru Examples

Example #1

File: admin_guru.php Project: rekysda/akademik

            <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&amp;mod=yes&amp;aksi=del&amp;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&amp;mod=yes&amp;aksi=edit&amp;id=' . $data['id'] . '"><span class="btn btn-warning">Edit</span></a></td>
</tr>';
    }
    $admin .= '</tbody></table>';
    /************************************/
}
echo $admin;

Example #2

File: admin_jadwal.php Project: rekysda/akademik

    $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 . '">

Example #3

File: admin_lokasi.php Project: rekysda/akademik

<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&amp;mod=yes&amp;aksi=del&amp;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&amp;mod=yes&amp;aksi=edit&amp;id=' . $data['replid'] . '"><span class="btn btn-warning">Edit</span></a></td>
</tr>';
    }
    $admin .= '</tbody></table>';
    /************************************/
}
echo $admin;