echo dirname(__FILE__) . DIRECTORY_SEPARATOR . 'plugins' . DIRECTORY_SEPARATOR . 'smilies' . DIRECTORY_SEPARATOR . 'config.php'; function temukan_array_ganda($arr) { $hide_ganda = array_unique(array_map("strtoupper", $arr)); $duplicates = array_diff($arr, $hide_ganda); return $duplicates; } $query = "SELECT NIM FROM `t_mhs` WHERE left(NIM,4) = '2013' LIMIT 1"; $sql = $conn->query($query); while ($r = $sql->fetch_assoc()) { $sql2 = $conn->query("SELECT NIM,KODEMTK,NAMAMTK FROM `t_krs_sementara` WHERE NIM='2013221192' AND NAMAMTK!=''"); if ($sql2->num_rows > 0) { while ($r2 = $sql2->fetch_assoc()) { $data[trim($r2['KODEMTK'])] = trim($r2['NAMAMTK']); } $arr = array_not_unique($data); print_r($arr); } // print_r($data); } ?> </table> </div> </div> </div> <table border="1">
<th>Semester</th> </tr> <?php // $query = "SELECT NIM FROM `t_mhs` WHERE left(NIM,4) = '2013'"; $query = $_GET['query']; $sql = $conn->query($query); $no = 1; while ($r = $sql->fetch_assoc()) { $sql2 = $conn->query("SELECT NIM,KODEMTK,NAMAMTK FROM `t_krs_sementara` WHERE NIM='{$r['NIM']}' AND NAMAMTK!=''"); if ($sql2->num_rows > 0) { $arr_data = array(); while ($r2 = $sql2->fetch_assoc()) { $arr_data[trim($r2['KODEMTK'])] = trim($r2['KODEMTK']); } $arr_data = array_not_unique($arr_data); $dpt = count($arr_data); $i = 1; foreach ($arr_data as $key => $val) { $query3 = "SELECT TAHUN,SMSTR,SKS,NIM,KODEMTK,NAMAMTK,HURUF FROM t_krs_sementara WHERE KODEMTK='{$key}' AND NIM='{$r['NIM']}' AND NAMAMTK!=''"; $sql3 = $conn->query($query3); if ($sql3->num_rows > 0) { $r3 = $sql3->fetch_assoc(); if ($i == 1) { ?> <tr> <td rowspan="<?php echo $dpt; ?> "><?php