0)
{
$row1 = mysql_fetch_array($result1) ;
$pin = $row1['PINCODE'] ;
$owner = $row1['REGNO'] ;
$numbused = $row1['NOUSED'] ;
$tm = $row1['TERM'] ;
$yr = $row1['acadsession'] ;
//check reg no
if($numbused >= 4) $msg[] = 'You have used this Pin above its Limit please buy another Card' ;
if($term != $tm) $msg[] = 'You have used this Pin to Check another Term Result, Please Get another Card' ;
if($yr != $schyear) $msg[] = 'You have used this Pin to Check another Session Result, Please Get another Card' ;
}// end if access, i.e, if pin exist
//statrt checking result if pins are valid
if(empty($msg))
{
if($term == 'THIRD TERM')
{
//check if the student result is ready.
$sql3 = " select * from marks where (stregno = '$regno' and acad_session = '$schyear') and stclass = '$classid'" ;
$result3 = mysql_query($sql3) or die('Error: ' . mysql_error());
if(mysql_num_rows($result3) > 0)
{
$row3 = mysql_fetch_array($result3) ;
$resultno3 = $row3['stregno'] ;
$_SESSION["getresultcm"] = $resultno3 ;
$_SESSION["getresultc"] = $resultno3 ;
}
else
$msg[] = 'Sorry, Your 3RD Term Result is not Ready or Make Sure you entered correct Information' ;
}
else
{
//check if the student result is ready.
$sqlc = " select * from marks where (stregno = '$regno' and acad_session = '$schyear') and (term = '$term'and stclass = '$classid')" ;
$resultc = mysql_query($sqlc) or die('Error: ' . mysql_error());
if(mysql_num_rows($resultc) > 0)
{
$rowc = mysql_fetch_array($resultc) ;
$resultnoc = $rowc['stregno'] ;
$_SESSION["getresultc"] = $resultnoc ;
}
else
$msg[] = 'Sorry, Your Result is not Ready or Make Sure you entered correct Information' ;
}
//begin get total student for cumulative
//get total in Class
if($term == 'THIRD TERM')
{
$sqlpoc = " select distinct stregno from marks where (acad_session = '$schyear' and stclass= '$classid' ) ";
$pocresult = mysql_query($sqlpoc) or die('Error: ' . mysql_error());
$pocrow = mysql_fetch_array($pocresult) ;
$numbc = mysql_num_rows($pocresult) ;
$_SESSION["classnumc"] = $numbc ;
}
else
{
$sqlpoc = " select distinct stregno from marks where (term = '$term' and acad_session = '$schyear') and stclass= '$classid' ";
$pocresult = mysql_query($sqlpoc) or die('Error: ' . mysql_error());
$pocrow = mysql_fetch_array($pocresult) ;
$numbc = mysql_num_rows($pocresult) ;
$_SESSION["classnum"] = $numbc ;
}
//end
//begin card check
if(empty($msg))
{
if($term == 'THIRD TERM')
{
if($level == 'Primary') header("location: resultsheet/pjsheet.php");
if($level1 == 'JS') header("location: resultsheet/pjsheet.php");
}
else
{
if($level1 == 'JS') header("location: resultsheet/jsheet.php");
if($level == 'Primary') header("location: resultsheet/basicsheet.php");
}
}
}
}
?>
Result Portal