query("SELECT * FROM 2013_offers2 WHERE fid = '$dfid'"); if ($row = $db->fetch_array($offerquery)) { $programme = $row['programme']; $inst = $row['inst']; $exam="hkdse"; $details ="true"; } } $errors = array(); $isProgrammeExist = false; if ($inst != '' && $programme != '' && $exam == 'hkdse' && preg_match('/^[0-9]+$/', $dfid) && $details == 'true') { $query = $db->query("SELECT fid FROM 2013_offers2 WHERE fid = '$dfid'"); if (!$db->num_rows($query)) { exit('Record not found

'); } $banding_array = array('A1', 'A2', 'A3', 'B4', 'B5', 'B6', 'C7', 'C8', 'C9', 'C10', 'D11', 'D12', 'D13', 'D14', 'E15', 'E16', 'E17', 'E18', 'E19', 'E20'); $grade_array = array('7' => '5**', '6' => '5*', '5' => '5', '4' => '4', '3' => '3', '2' => '2', '1' => '1', '0' => 'U'); $fid = $_exam = ''; $query = $db->query("SELECT o.*, a.result_slip, a.jupas_banding, a.main_round_result, a.showpublic FROM 2013_offers2 o LEFT JOIN 2013_attachments a ON o.fid = a.fid WHERE o.fid = '$dfid'"); $record = $db->fetch_array($query); $__fid = $record['fid']; $record['timestamp'] = date('d/m/Y, H:i a', $record['timestamp']); $record['inst'] = $university[$record['inst']]; $record['programme'] = 'JS' . $record['programme'] . ' / ' . $programmes[$record['programme']]; $record['banding'] = $banding_array[$record['banding']-1]; $record['remarks'] = nl2br(stripslashes($record['remarks'])); $totalPhotos = 0; $photos = array(); $record['result_slip'] != '' && ($photos['result_slip'] = $record['result_slip']); $record['jupas_banding'] != '' && ($photos['jupas_banding'] = $record['jupas_banding']); $record['main_round_result'] != '' && ($photos['main_round_result'] = $record['main_round_result']); $query = $db->query("SELECT g.grade, s.sn, s.fn FROM 2013_grades_dse g, 2013_subj s WHERE g.fid = '$__fid' AND g.subj = s.sn AND s.exam = 'hkdse' ORDER BY g.subj, g.grade ASC"); $emailSql = $db->query("SELECT email FROM 2013_personal_info WHERE fid = '$__fid' AND show_email = 1"); if ($row = $db->fetch_array($emailSql)) { $email = $row['email']; } $grade = array(); while ($fetch = $db->fetch_array($query)) { $grade[] = $fetch; } $ue_array = $clc_array = array(); for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'elang') { $elang_array = $grade[$i]; array_splice($grade, $i, 1); break; } } for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'clang') { $clang_array = $grade[$i]; array_splice($grade, $i, 1); break; } } for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'math') { $math_array = $grade[$i]; array_splice($grade, $i, 1); break; } } for ($i = 0; $i < count($grade); $i++) { if ($grade[$i]['sn'] == 'ls') { $ls_array = $grade[$i]; array_splice($grade, $i, 1); break; } } $elang_array['grade'] = $grade_array[$elang_array['grade']]; $clang_array['grade'] = $grade_array[$clang_array['grade']]; $math_array['grade'] = $grade_array[$math_array['grade']]; $ls_array['grade'] = $grade_array[$ls_array['grade']]; $out = ''; for ($i = 0; $i < count($grade); $i++) { $grade[$i]['grade'] = $grade_array[$grade[$i]['grade']]; $out .= << {$grade[$i]['fn']} {$grade[$i]['grade']}

EOD; } } else if ( $inst != '' && $programme != '' && preg_match('/^[0-9]{4}$/', $programme) ) { // Check existence of programme $isProgrammeExist = array_key_exists($programme, $programmes); if (!$isProgrammeExist) { $errors[] = 'Programme not exists'; } else { require_once 'results-'.$exam.'.php'; } } else if ($exam != '' && $inst == '' && $programme == '') { $query = $exam == 'hkale' ? $db->query("SELECT fid, inst, programme, timestamp FROM 2013_offers WHERE exam='$exam' AND valid=1 ORDER BY timestamp DESC LIMIT 10") : $db->query("SELECT fid, inst, programme, timestamp FROM 2013_offers2 WHERE valid=1 ORDER BY timestamp DESC LIMIT 10"); $latest = array(); while ($rows = $db->fetch_array($query)) { $latest[] = $rows; } $totalInst = array(); $query = $exam == 'hkale' ? $db->query("SELECT inst, COUNT(*) AS total FROM 2013_offers WHERE exam='$exam' AND valid=1 GROUP BY inst ORDER BY total DESC") : $db->query("SELECT inst, COUNT(*) AS total FROM 2013_offers2 WHERE valid=1 GROUP BY inst ORDER BY total DESC"); while ($rows = $db->fetch_array($query)) { $totalInst[] = $rows; } $query = $exam == 'hkale' ? $db->query("SELECT fid FROM 2013_offers WHERE exam='$exam'") : $db->query("SELECT fid FROM 2013_offers2"); $totalReports = $db->num_rows($query); $query = $db->query("SELECT fid FROM 2013_offers2 WHERE emailconfirm=1"); $totalemailReports = $db->num_rows($query); } else if ($inst != '' && $programme == '') { $query = $exam == 'hkale' ? $db->query("SELECT programme, COUNT(*) AS total FROM 2013_offers WHERE exam='$exam' AND inst = '$inst' AND valid=1 GROUP BY programme ORDER BY total DESC") : $db->query("SELECT programme, COUNT(*) AS total FROM 2013_offers2 WHERE inst = '$inst' AND valid=1 GROUP BY programme ORDER BY total DESC"); $output = array(); while ($row = $db->fetch_array($query)) { $output[$row['programme']] = $row['total']; } } $cityu = $hkbu = $polyu = $cuhk = $hkust = $hku = $lu = $hkie = $ouhk = ''; foreach ($programmes as $key => $value) { $uni = substr($key, 0, 1); switch ($uni) { case 1: $cityu .= ''; break; case 2: $hkbu .= ''; break; case 3: $polyu .= ''; break; case 4: $cuhk .= ''; break; case 5: $hkust .= ''; break; case 6: $hku .= ''; break; case 7: $lu .= ''; break; case 8: $hkie .= ''; break; case 9: $ouhk .= ''; break; } } $selected = ' class="active"'; $cityu_selected = $inst == 'cityu' ? $selected : ''; $hkbu_selected = $inst == 'hkbu' ? $selected : ''; $polyu_selected = $inst == 'polyu' ? $selected : ''; $cuhk_selected = $inst == 'cuhk' ? $selected : ''; $hkust_selected = $inst == 'hkust' ? $selected : ''; $hku_selected = $inst == 'hku' ? $selected : ''; $lu_selected = $inst == 'lu' ? $selected : ''; $hkie_selected = $inst == 'hkie' ? $selected : ''; $ouhk_selected = $inst == 'ouhk' ? $selected : ''; $current_al = $exam == 'hkale' ? ' class="current"' : ''; $current_dse = $exam == 'hkdse' ? ' class="current"' : ''; $rightContent = $exam != '' && $inst == '' && $programme == '' ? 'right-content2' : 'right-content'; ?> EOD; $currentMenuResults = ' class="current"'; require_once 'header.tpl.php'; ?>

[29/7 12:00PM] 免責聲明

成績查詢

››成績查詢 ›› ›› / ››編號

院校:
課程:

(總覽)已報告之課程

課程名稱報告人數

$val): ?>

最新更新

發布了報告

最多報告院校

報告總數

電郵已驗證報告

Error

$timestamp ? ($now - $timestamp) : ($timestamp - $now); for ($j = 0; $difference >= $lengths[$j] && $j < count($lengths)-1; $j++) { $difference /= $lengths[$j]; } $difference = round($difference); return $difference . ' ' . $periods[$j] . '前'; } ?>