H.S.C. 2006 Online Result
$link = @mysql_pconnect(DB_SERVER, DB_USER, DB_PASS);
if (!$link) {
$error='Server is busy. Please try again later';
} else {
if(!@mysql_select_db(DB,$link)) {
$error='Database not found';
} else {
$res = @mysql_query("SELECT a.NAME, a.FNAME, a.MNAME, a.REGNO, a.SESSION, a.GPA, a.RESULT, a.STUD_GROUP, a.STUD_TYPE, a.LTRGRD, b.I_NAME, b.CENTRE FROM ".$_POST['board']." a, ".$_POST['board'].INSTITUTE." b WHERE a.roll_no='".$_POST['roll']."' AND a.I_CODE = b.I_CODE AND a.C_CODE=b.C_CODE",$link);
$data = @mysql_fetch_row($res);
if (!$data) {
$error='No Record Found';
}
}
}
if($error) {
?>
} else {
?>
Board echo strtoupper($_POST['board']);?>
Roll No. echo $_POST['roll'];?>
Registration No. echo $data[3];?>
Academic Session
if($data[4] == '3')
echo "2003";
else if($data[4] == '4')
echo "2004";
else if($data[4] == '2')
echo "2002";
else if($data[4] == '1')
echo "2001";
else
echo $data[4];
?>
Name echo $data[0];?>
Father's Name echo $data[1];?>
Mother's Name echo $data[2];?>
Institute Name echo $data[10];?>
Centre Name echo $data[11];?>
Student Group echo $data[7];?>
Student Type echo $data[8];?>
Result
if(strtoupper($data[6]) == 'P'){
echo 'PASSED';
} else if (strtoupper($data[6]) == 'A') {
echo 'Absent';
} else if (strtoupper($data[6]) == 'W') {
echo 'Withheld';
} else if (strtoupper($data[6]) == 'R') {
echo 'Reported';
} else if (strtoupper($data[6]) == 'C') {
echo 'Cancelled';
} else if (
strtoupper($data[6]) == 'E') {
echo 'Expelled';
} else if (strtoupper($data[6]) == 'F' || strtoupper($data[6]) == '' ) {
echo 'FAILED';
} else {
if ( substr($data[6],-1,1) == '1' ) {
echo 'FAILED IN '.substr($data[6],-1,1).' SUBJECT';
} else {
echo 'FAILED IN '.substr($data[6],-1,1).' SUBJECTS';
}
}
?>
GPA echo $data[5];?>
$subj = explode(',',$data[9]);
foreach ($subj as $k=>$v) {
if ( ($v != null) && ( trim($v) != ":") ){
$s = explode(':',$v);
$s_code[] = $s[0];
$s_grade[] = $s[1];
}
}
if ($_POST['board'] == "madrasah") {
$s_code_str = implode(",", array_values(str_replace('+',',',$s_code)));
$sql = 'select SUB_CODE, SUB_NAME from '.SUBJECT_MADRASAH.' where SUB_CODE in ('.$s_code_str.')';
} else {
$s_code_str = implode(",", array_values($s_code));
$sql = 'select SUB_CODE, SUB_NAME from '.SUBJECT_SSC.' where SUB_CODE in ('.$s_code_str.')';
}
$res = @mysql_query($sql);
while($row = @mysql_fetch_row($res)){
$s_data[$row[0]] = $row[1];
}
foreach ($s_code as $k => $v) {
if(strpos($v,'+')) {
$tmp = explode('+',$v);
$s_name[$k] = str_replace($tmp[0].'+'.$tmp[1],$s_data[$tmp[0]].' AND '.$s_data[$tmp[1]],$v);
} else {
$s_name[$k] = $s_data[$v];
}
}
?>
Grade Details
$j = sizeof($s_name);
for($i=0; $i<$j; $i++) {
?>
echo $s_name[$i];?> echo " ".$s_grade[$i];?>
}
?>
}
?>