[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 secondsemester_result_y1 where regnumber=’$examno’ AND password=’$password’ AND classof=’$classof’ AND semester=’$semester’ AND myset=’$myset’ limit 1″;
$r = mysqli_query($con, $q);
$xp = mysqli_num_rows($r);
if($xp!=0)
{
$row = mysqli_fetch_array($r);
extract($row);
if($payment_status==”PAID”){
$finalremark = “PASS”;
if($anatphy < 50){ $finalremark = "REF"; }
if($msd1 < 50){ $finalremark = "REF"; }
if($msd2 < 50){ $finalremark = "REF"; }
if($fnn < 50){ $finalremark = "REF"; }
if($phc < 50){ $finalremark = "REF"; }
if($osce < 50){ $finalremark = "REF"; }
echo "
YEAR TWO “.$semester.” SEMESTER EXAMINATION RESULT
“.$classof.” ACADEMIC SESSION
“;
echo “
| NAME: | $studentname |
| REGISTRATION NUMBER: | $regnumber |
“;
echo “
| SN | COURSE | SCORE | REMARK | ||
|---|---|---|---|---|---|
| 1 | ANATOMY/PHYSIOLOGY AND PHARMACOLOGY | “. number_format($anatphy, 2).” | “; IF($anatphy>=47){ echo “PASS”; }ELSE{ echo “REF”; } echo ” | ||
| 2 | MED-SURG I AND DIETETICS | “. number_format($msd1, 2).” | “; IF($msd1>=47){ echo “PASS”; }ELSE{ echo “REF”; } echo ” | ||
| 3 | MED-SURG II AND MENTAL HEALTH | “. number_format($msd2, 2).” | “; IF($msd2>=47){ echo “PASS”; }ELSE{ echo “REF”; } echo ” | ||
| 4 | FON/ICT/RESEARCH/STATISTICS | “. number_format($fnn, 2).” | “; IF($fnn>=47){ echo “PASS”; }ELSE{ echo “REF”; } echo ” | ||
| 5 | REPRODUCTIVE HEALTH AND PRIMARY HEALTH CARE | “. number_format($phc, 2).” | “; IF($phc>=47){ echo “PASS”; }ELSE{ echo “REF”; } echo ” | ||
| 6 | OSCE | “. number_format($osce, 2).” | “; IF($osce>=47){ echo “PASS”; }ELSE{ echo “REF”; } echo ” | ||
| REMARK | $finalremark $note | ||||
“;
echo “
NOTE
“;
echo ”
“;
“;
//echo ‘
}else { echo “PAYMENT FOR SCHOOL FEES NOT PROCESSED.”; }
} else {
echo “E-RESULT CHECKER
Result not found
Steps to print result sheet
- Enter your Registration Number
- Enter your Password, provided by management
- Select your Session
- Select your Set
- Select the semester
“;
echo “
“;
}
//post not
} else {
echo “E-RESULT SHEET
Steps to print result sheet
- Enter your Registration Number
- Enter your Password, provided by management
- Select your Session
- Select your Set
- Select the semester
- Click ‘Check Result’ menu to proceed
“;
echo “
“;
}
[/insert_php]