Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /*
- logika yang saya gunakan adalah join
- pada codingnya saya pisah2 data utamanya ke array $rawData yang nanti di baca2 dengan foreach atau for sesuai cocok/tidaknya coding yang digunakan
- */
- $mysqli=new mysqli("localhost","root2","musthofa","test_guru");
- if(!isset($_GET['nip'])){
- $sql="select nip from tb_dosen order by rand() limit 1";
- $result = $mysqli->query($sql);
- $row = $result->fetch_array(MYSQLI_ASSOC);
- header("location:?nip=".$row['nip']);
- exit();
- }
- else{
- $rawData=array();
- $nip=$_GET['nip'];
- $sql="select * from tb_dosen";
- $rawData['dosen'] = $mysqli->query($sql)->fetch_array(MYSQLI_ASSOC);
- $aTable=array(
- 'bimbingan'=>'bimbingan',
- 'buku'=>'buku',
- 'jabatan'=>'jabatan_ak',
- 'jabatan_fungsional'=>'jafung',
- 'pendidikan'=>'pendidikan',
- 'penelitian'=>'penelitian',
- 'pengajaran'=>'pengajaran',
- 'penghargaan'=>'penghargaan',
- 'pkm'=>'pkm',
- 'seminar'=>'seminar'
- );
- foreach($aTable as $name=>$table){
- $rawData[$name]=fetchTableKuliah('tb_'.$table,$nip);
- }
- // echo '<pre>';print_r($data);die();
- }
- ?><div class="modal-header">
- <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button>
- <h4 class="modal-title">Status Informasi Dosen</h4>
- </div>
- <!--modal body-->
- <div class="modal-body row">
- <div class="col-lg-12">
- <div class="row">
- <div class="col-lg-4">
- <?php $data=$rawData['dosen'];?>
- <table class="table table-condensed">
- <tr>
- <td><label>N.I.P</label></td>
- <td><?php echo $data['nip']; ?></td>
- </tr>
- <tr>
- <td><label>N.I.D.N / N.I.D.K</label></td>
- <td><?php echo $data['nidn_nidk']; ?></td>
- </tr>
- <tr>
- <td><label>Nama</label></td>
- <td><?php echo $data['nama']; ?></td>
- </tr>
- <tr>
- <td><label>Jenis Kelamin</label></td>
- <td><?php echo $data['jenis_kelamin']; ?></td>
- </tr>
- <tr>
- <td><label>Alamat</label></td>
- <td><?php echo $data['alamat']; ?></td>
- </tr>
- <tr>
- <td><label>Agama</label></td>
- <td><?php echo $data['agama']; ?></td>
- </tr>
- <tr>
- <td><label>Pendidikan Terakhir</label></td>
- <td><?php echo $data['pendidikan_terakhir']; ?></td>
- </tr>
- <tr>
- <td><label>Jabatan</label></td>
- <td><?php echo $data['jabatan']; ?></td>
- </tr>
- <tr>
- <td><label>Telepon</label></td>
- <td><?php echo $data['telepon']; ?></td>
- </tr>
- <tr>
- <td><label>Email</label></td>
- <td><?php echo $data['email']; ?></td>
- </tr>
- </table>
- </div>
- <div class="col-lg-2">
- <?php echo "<img src='administrasi/foto/".$data['foto']."' width='195px' height='195px'>"; ?>
- </div>
- <div class="col-lg-6">
- <!--<div class="panel panel-primary panel-heading">ddd</div>-->
- <ul class="nav nav-tabs">
- <li class="active"><a data-toggle="tab" href="#pendidikan">Pendidikan</a></li>
- <li><a data-toggle="tab" href="#buku">Buku</a></li>
- <li><a data-toggle="tab" href="#bimbingan">Bimbingan</a></li>
- <li><a data-toggle="tab" href="#akademik">Jab. Akademik</a></li>
- <li><a data-toggle="tab" href="#fungsional">Jab. Fungsional</a></li>
- <li><a data-toggle="tab" href="#penelitian">Penelitian</a></li>
- <li><a data-toggle="tab" href="#pengajaran">Pengajaran</a></li>
- <li><a data-toggle="tab" href="#penghargaan">Penghargaan</a></li>
- <li><a data-toggle="tab" href="#pkm">PKM</a></li>
- <li><a data-toggle="tab" href="#seminar">Seminar</a></li>
- </ul>
- <div class="tab-content">
- <div id="pendidikan" class="tab-pane fade in active">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tahun Lulus</th>
- <th>Jenjang</th>
- <th>Gelar</th>
- <th>Nama Universitas</th>
- <th>Bidang Ilmu</th>
- <th>No. Ijazah</th>
- </tr>
- <?php
- //while ($l=mysql_fetch_array($hasil)){
- //menamiplkan record pendidikan
- foreach($rawData['pendidikan'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_pendidikan']; ?></td>
- <td><?php echo $data['tahun_lulus']; ?></td>
- <td><?php echo $data['jenjang']; ?></td>
- <td><?php echo $data['gelar']; ?></td>
- <td><?php echo $data['nama_universitas']; ?></td>
- <td><?php echo $data['bidang_ilmu']; ?></td>
- <td><?php echo $data['no_ijasah']; ?></td>
- </tr>
- <?php } ?>
- </table>
- </div>
- <div id="buku" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Penulis</th>
- <th>Judul Buku</th>
- <th>Tahun Terbit</th>
- <th>Penerbit Buku</th>
- </tr>
- <?php
- foreach($rawData['buku'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_buku']; ?></td>
- <td><?php echo $data['penulis']; ?></td>
- <td><?php echo $data['judul_buku']; ?></td>
- <td><?php echo $data['tahun_terbit']; ?></td>
- <td><?php echo $data['penerbit_buku']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="bimbingan" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No. Bimbingan</th>
- <th>Tahun Bimbingan</th>
- <th>Nama Mahasiswa</th>
- <th>Judul</th>
- </tr>
- <?php
- foreach($rawData['bimbingan'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_bimbingan']; ?></td>
- <td><?php echo $data['tahun_bimbingan']; ?></td>
- <td><?php echo $data['nama_mahasiswa']; ?></td>
- <td><?php echo $data['judul']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="akademik" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tahun Diangkat</th>
- <th>Posisi</th>
- <th>No. SK</th>
- </tr>
- <?php
- foreach($rawData['jabatan'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_jabatan']; ?></td>
- <td><?php echo $data['tahun_diangkat']; ?></td>
- <td><?php echo $data['posisi']; ?></td>
- <td><?php echo $data['no_sk']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="fungsional" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tahun Jabatan Fungsional</th>
- <th>Jabatan Fungsional</th>
- <th>SK Jabatan Fungsional</th>
- <th>SK Sertifikasi</th>
- </tr>
- <?php
- foreach($rawData['jabatan_fungsional'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_jafung']; ?></td>
- <td><?php echo $data['tahun_jafung']; ?></td>
- <td><?php echo $data['jafung']; ?></td>
- <td><?php echo $data['sk_jafung']; ?></td>
- <td><?php echo $data['sk_sertifikasi']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="penelitian" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tahun Penelitian</th>
- <th>Judul Penelitian</th>
- <th>Tempat Publikasi</th>
- </tr>
- <?php
- foreach($rawData['penelitian'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_penelitian']; ?></td>
- <td><?php echo $data['tahun_penelitian']; ?></td>
- <td><?php echo $data['judul_penelitian']; ?></td>
- <td><?php echo $data['tempat_publikasi']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="pengajaran" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tahun Akademik</th>
- <th>Semester</th>
- <th>Mata Kuliah</th>
- <th>SK Mengajar</th>
- </tr>
- <?php
- foreach($rawData['pengajaran'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_pengajaran']; ?></td>
- <td><?php echo $data['tahun_akademik']; ?></td>
- <td><?php echo $data['semester']; ?></td>
- <td><?php echo $data['mata_kuliah']; ?></td>
- <td><?php echo $data['sk_mengajar']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="penghargaan" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tanggal Penghargaan</th>
- <th>Jenis Penghargaan</th>
- <th>Pemberi</th>
- </tr>
- <?php
- foreach($rawData['penghargaan'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_penghargaan']; ?></td>
- <td><?php echo $data['tanggal_penghargaan']; ?></td>
- <td><?php echo $data['jenis_penghargaan']; ?></td>
- <td><?php echo $data['pemberi']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="pkm" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tahun PKM</th>
- <th>Tempat PKM</th>
- <th>Judul PKM</th>
- <th>Publikasi PKM</th>
- </tr>
- <?php
- foreach($rawData['pkm'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_pkm']; ?></td>
- <td><?php echo $data['tahun_pkm']; ?></td>
- <td><?php echo $data['tempat_pkm']; ?></td>
- <td><?php echo $data['judul_pkm']; ?></td>
- <td><?php echo $data['publikasi_pkm']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- <div id="seminar" class="tab-pane fade">
- <table class="table table-condensed">
- <tr>
- <th>No.</th>
- <th>Tanggal Seminar</th>
- <th>Judul Seminar</th>
- <th>Sebagai</th>
- <th>Jenis Seminar</th>
- <th>Kota</th>
- </tr>
- <?php
- foreach($rawData['seminar'] as $data){
- ?>
- <tr>
- <td><?php echo $data['no_seminar']; ?></td>
- <td><?php echo $data['tanggal_seminar']; ?></td>
- <td><?php echo $data['judul_seminar']; ?></td>
- <td><?php echo $data['sebagai']; ?></td>
- <td><?php echo $data['jenis_seminar']; ?></td>
- <td><?php echo $data['kota']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <?php
- function fetchTableKuliah($table, $nip){
- global $mysqli;
- $sql="select * from {$table} where nip like '{$nip}'";
- if(!$result = $mysqli->query($sql)){
- $err=sprintf("Errormessage: %s\n", $mysqli->error);
- return $err;
- }
- else{
- while($row = $result->fetch_array(MYSQLI_ASSOC)){
- $raw[]=$row;
- }
- return $raw;
- }
- return false;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement