[insert_php]

if(isset($_POST[‘check’]))

{
extract($_POST);

//connect and send reg details
$con = mysqli_connect(“localhost”, “conooorg_saly”, “{{Ssgkk4}}”);
$db = mysqli_select_db($con, “conooorg_nursing”);

//chk result
$q = “select * from exam_result_cum where regnumber=’$examno’ AND password=’$password’ AND academicsession=’$classof’ AND resit=’1′ limit 1”;
//print $q;
$r = mysqli_query($con, $q);
$xp = mysqli_num_rows($r);

if($xp!=0)
{

$row = mysqli_fetch_array($r);
extract($row);

echo “

CUMMULATIVE RESULT FOR $resultfor EXAMINATION
$academicsession ACADEMIC SESSION
RESIT

“;

echo “

“;
echo “

“;
echo “

“;
echo “

NAME: $studentname
REGISTRATION NUMBER:     $regnumber

“;

echo “

“;

echo “

“;
if($phar_cum > 0){
if($phar_cum > 49){ $phar_remark = “PASS”; }elseif($phar_cum == 0){ $phar_remark = “-“; }else{ $phar_remark = “REF”; }
echo “

“;
}

if($diet_cum > 0){
if($diet_cum > 49){ $diet_remark = “PASS”; }elseif($diet_cum == 0){ $diet_remark = “-“; }else{ $diet_remark = “REF”; }
echo “

“;
}

if($health_cum > 0){
if($health_cum > 49){ $health_remark = “PASS”; }elseif($health_cum == 0){ $health_remark = “-“; }else{ $health_remark = “REF”; }

echo “

“;
}

if($ict_cum > 0){
if($ict_cum > 49){ $ict_remark = “PASS”; }elseif($ict_cum == 0){ $ict_remark = “-“; }else{ $ict_remark = “REF”; }
echo “

“;
}

if($phcn_cum > 0){
if($phcn_cum > 49){ $phcn_remark = “PASS”; }elseif($phcn_cum == 0){ $phcn_remark = “-“; }else{ $phcn_remark = “REF”; }
echo “

“;
}

if($osce_cum > 0){
if($osce_cum > 49){ $osce_remark = “PASS”; }elseif($osce_cum == 0){ $osce_remark = “-“; }else{ $osce_remark = “REF”; }
echo “

“;
}
echo “

COURSE 1ST SEMESTER 2ND SEMESTER TOTAL CUM REMARK
ANATOMY/PHYSIOLOGY AND PHARMACOLOGY $phar_1st $phar_2nd $phar_total $phar_cum $phar_remark
MED-SURG I AND DIETETICS $diet_1st $diet_2nd $diet_total $diet_cum $diet_remark
MED-SURG II AND MENTAL HEALTH $health_1st $health_2nd $health_total $health_cum $health_remark
FON/ICT/RESEARCH/STATISTICS $ict_1st $ict_2nd $ict_total $ict_cum $ict_remark
REPRODUCTIVE HEALTH AND PRIMARY HEALTH CARE $phcn_1st $phcn_2nd $phcn_total $phcn_cum $phcn_remark
OSCE $osce_1st $osce_2nd $osce_total $osce_cum $osce_remark

“;

echo “NOTE
“;
echo “

  • Candidates with Ref should prepare to write the exam on the $refdate.

    • “;
    echo “

  • Candidates without Ref should continue to the next block of their study

“;

echo “

“;

} else {
echo “E-RESULT CHECKER.

Result not found

Steps to print result sheet

  1. Enter your Registration Number
  2. Enter your Password, provided by management
  3. Select your Session
  4. Click ‘Check Result’ menu to proceed

    5. “;

    echo “

    “;
    echo “Registration Number: “;
    echo “Password: “;
    echo “Session: “;
    echo “

    “;

    }

    //post not
    } else {

    echo “E-RESULT SHEET.

    Steps to print result sheet

    1. Enter your Registration Number
    2. Enter your Password, provided by management
    3. Select your Session
    4. Click ‘Check Result’ menu to proceed

    “;

    echo “

    “;
    echo “Registration Number: “;
    echo “Password: “;
    echo “Session: “;
    echo “

    “;

    }

    [/insert_php]