perbaikan dari saya

<?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"> &times; </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;
}

?>