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
