Refered successfully"; }else if($_GET['msg'] == "failed"){ $msg = "
Something went wrong, please try again
"; } if($_SESSION['msg'] == "update") { $msg = "
Order Update Succesful. Customer will receive email.Refresh
"; } $rows1 = sql($DBH, "SELECT * FROM tbl_student_results where csv_no = ?", array($_GET['val']), "rows"); foreach($rows1 as $row1) { $u_name = $row1['name']; $u_registration_no = $row1['registration_no']; $u_homework = $row1['homework']; $u_test = $row1['test']; $u_exam = $row1['exam']; $total = ($u_homework + $u_test + $u_exam); sql($DBH, "UPDATE tbl_student_results set total = ?, teacher_no = ? WHERE registration_no = ? AND year = ? AND term = ? AND class = ?", array($total,$SESS_HASH_USER,$u_registration_no,$u_test)); $rows2 = sql($DBH, "SELECT * FROM tbl_student_results where csv_no = ? ORDER by (total) desc", array($_GET['val']), "rows"); $sno = 0; foreach($rows2 as $row2) { $sno++; $us_name = $row2['name']; $us_registration_no = $row2['registration_no']; $us_homework = $row2['homework']; $us_test = $row2['test']; $us_exam = $row2['exam']; $us_total = $row2['total']; $us_class = $row2['class']; $us_year = $row2['year']; $us_term = $row2['term']; if($us_total <=39){ $grade = "F"; } else if ($us_total >39 && $us_total<= 59) { $grade = "P"; } else if ($us_total >59 && $us_total<= 79) { $grade = "C"; } else if ($us_total >79 && $us_total<= 100) { $grade = "D"; } sql($DBH, "UPDATE tbl_student_results set grade = ?, position = ? WHERE registration_no = ? AND test = ?", array($grade,$sno,$us_registration_no,$us_test)); } } //Overall $STH = $DBH->prepare("SELECT count(*) FROM tbl_overall WHERE class = ? AND year = ? AND term = ?"); $result = $STH->execute(array($_GET['myclass'],$_GET['examyear'],$_GET['term'])); $cnt_overall = $STH->fetchColumn(); if($cnt_overall == 0){ $rows1 = sql($DBH, "SELECT * FROM tbl_overall WHERE class = ? AND year = ? AND term = ?", array($_GET['stclass'],$_GET['examyear'],$_GET['term']), "rows"); foreach($rows1 as $row1) { $st_registration_no = $row1['reg_no']; $st_class = $row1['class']; $st_name = $row1['name']; $b_in_s = sql($DBH, "SELECT SUM(total) FROM tbl_overall WHERE class = ? AND year = ? AND term = ? AND registration_no = ?", array($_GET['stclass'],$_GET['year'],$_GET['stterm'],$st_registration_no), "rows"); foreach($b_in_s as $b_in_row){ $b_ins = $b_in_row[0]; } sql($DBH, "insert into tbl_overall (name , reg_no , class , year , term, overall)values (?,?,?,?,?,?)", array($st_name,$st_registration_no,$_GET['stclass'],$_GET['year'],$_GET['stterm'],$b_ins)); $rows2 = sql($DBH, "SELECT * FROM tbl_overall WHERE class = ? AND year = ? AND term = ? ORDER by (overall) desc", array($_GET['stclass'],$_GET['year'],$_GET['stterm']), "rows"); $snum = 0; foreach($rows2 as $row2) { $snum++; $ust_name = $row2['name']; $ust_reg_no = $row2['reg_no']; $ust_test = $row2['test']; $rows1 = sql($DBH, "SELECT * FROM tbl_user where registration_no = ?", array($ust_reg_no), "rows"); foreach($rows1 as $row1) { $dob = $row1['age']; //date in mm/dd/yyyy format; or it can be in other formats as well $birthDate = "$dob"; //explode the date to get month, day and year $birthDate = explode("/", $birthDate); //get age from date or birthdate $age = (date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md") ? ((date("Y") - $birthDate[2]) - 1) : (date("Y") - $birthDate[2])); } sql($DBH, "UPDATE tbl_overall set position = ?, age = ? WHERE class = ? AND year = ? AND term = ? AND reg_no = ?", array($snum,$age,$_GET['stclass'],$_GET['year'],$_GET['stterm'],$ust_reg_no), "rows"); } } }else if($cnt_overall > 0){ $rows2 = sql($DBH, "SELECT * FROM tbl_overall WHERE class = ? AND year = ? AND term = ? ORDER by (overall) desc", array($_GET['stclass'],$_GET['year'],$_GET['stterm']), "rows"); $snum = 0; foreach($rows2 as $row2) { $snum++; $ust_name = $row2['name']; $ust_reg_no = $row2['reg_no']; $ust_test = $row2['test']; $b_in_s = sql($DBH, "SELECT SUM(total) FROM tbl_student_results WHERE class = ? AND year = ? AND term = ? AND registration_no = ?", array($_GET['stclass'],$_GET['year'],$_GET['stterm'],$ust_reg_no), "rows"); foreach($b_in_s as $b_in_row){ $b_ins = $b_in_row[0]; $STH = $DBH->prepare( "SELECT AVG(total) FROM tbl_student_results WHERE registration_no = ? AND class =? AND term = ? AND year = ?"); $result = $STH->execute(array($_GET['myreg'],$_GET['myclass'],$_GET['term'],$_GET['examyear'])); $AverageScore = $STH->fetchColumn(); } sql($DBH, "UPDATE tbl_overall set overall = ? WHERE class = ? AND year = ? AND term = ? AND reg_no = ?", array($b_ins,$_GET['stclass'],$_GET['year'],$_GET['stterm'],$ust_reg_no), "rows"); sql($DBH, "UPDATE tbl_overall set position = ? WHERE class = ? AND year = ? AND term = ? AND reg_no = ?", array($snum,$_GET['stclass'],$_GET['year'],$_GET['stterm'],$ust_reg_no), "rows"); sql($DBH, "UPDATE tbl_overall set AverageScore = ? WHERE class = ? AND year = ? AND term = ? AND reg_no = ?", array($AverageScore,$_GET['stclass'],$_GET['year'],$_GET['stterm'],$ust_reg_no), "rows"); } } ?> MOTHERCARE INT'L SCHOOL: My Term Result!
MOTHERCARE INT'L SCHOOL
prepare("SELECT count(*) FROM tbl_overall WHERE class =? AND term = ? AND year = ?"); $result = $STH->execute(array($_GET['myclass'],$_GET['term'],$_GET['examyear'])); $count_student = $STH->fetchColumn(); $AverageScore = sql($DBH, "SELECT AVG(total) FROM tbl_student_results WHERE registration_no = ? AND class =? AND term = ? AND year = ?", array($_GET['myreg'],$_GET['myclass'],$_GET['term'],$_GET['examyear']), "rows"); foreach($AverageScore as $b_in_row){ $AverageScore = round($b_in_row[0],2); } if($AverageScore <=39){ $htcomments = "Failure, work extremely hard next time" AND $cgrade = "F" AND $cgradeR = "FAIL"; } else if ($AverageScore >39 && $AverageScore<= 59) { $htcomments = "Pass. Put more effort next term" AND $cgrade = "P" AND $cgradeR = "PASS"; } else if ($AverageScore >59 && $AverageScore<= 79) { $htcomments = "Very Good Result, put more effort" AND $cgrade = "C" AND $cgradeR = "CREDIT"; } else if ($AverageScore >79 && $AverageScore<= 100) { $htcomments = "Excellent Result, Keep it up" AND $cgrade = "D" AND $cgradeR = "DISTINCTION"; } $b_in_q = sql($DBH, "SELECT AVG(total) FROM tbl_student_results where class =? AND term = ? AND year = ?", array($_GET['myclass'],$_GET['term'],$_GET['examyear']), "rows"); foreach($b_in_q as $b_in_row){ $b_in = round($b_in_row[0],2); } $b_in_qa = sql($DBH, "SELECT AVG(total) FROM tbl_student_results where class =? AND term = ? AND year = ?", array($_GET['myclass'],$_GET['term'],$_GET['examyear']), "rows"); foreach($b_in_qa as $b_in_row){ $b_inqa = $b_in_row[0]; } $b_in_m = sql($DBH, "SELECT MIN(total) FROM tbl_student_results where class =? AND term = ? AND year = ?", array($_GET['myclass'],$_GET['term'],$_GET['examyear']), "rows"); foreach($b_in_m as $b_in_row){ $b_inm = $b_in_row[0]; } $b_in_mx = sql($DBH, "SELECT MAX(total) FROM tbl_student_results where class =? AND term = ? AND year = ?", array($_GET['myclass'],$_GET['term'],$_GET['examyear']), "rows"); foreach($b_in_mx as $b_in_row){ $b_inmx = $b_in_row[0]; } $b_in_ag = sql($DBH, "SELECT AVG(age) FROM tbl_overall where class =? AND term = ? AND year = ?", array($_GET['myclass'],$_GET['term'],$_GET['examyear']), "rows"); foreach($b_in_ag as $b_in_row){ $b_inag = $b_in_row[0]; $b_age = round(($b_inag),2); } $rows1 = sql($DBH, "SELECT * FROM tbl_user where registration_no = ?", array($_GET['myreg']), "rows"); foreach($rows1 as $row1) { $user_name = $row1['fullname']; $user_gender = $row1['gender']; $user_age = $row1['age']; $user_profile_pic = $row1['profile_pic']; } if($user_profile_pic == "default"){ $profile_pic = ""; }else{ $profile_pic = ""; } $rows1 = sql($DBH, "SELECT * FROM tbl_overall where class =? AND term = ? AND year = ? AND reg_no =?", array($_GET['myclass'],$_GET['term'],$_GET['examyear'],$_GET['myreg']), "rows"); foreach($rows1 as $row1) { $user_position = $row1['position']; $overall = $row1['overall']; } if($user_position == 1){ $user_p = "$user_position st"; } else if($user_position == 2){ $user_p = "$user_position nd"; } else if($user_position == 3){ $user_p = "$user_position rd"; } else if($user_position == 21){ $user_p = "$user_position st"; } else if($user_position == 22){ $user_p = "$user_position nd"; } else if($user_position == 23){ $user_p = "$user_position rd"; } else if($user_position == 31){ $user_p = "$user_position st"; } else if($user_position == 32){ $user_p = "$user_position nd"; } else if($user_position == 33){ $user_p = "$user_position rd"; } else if($user_position == 41){ $user_p = "$user_position st"; } else if($user_position == 42){ $user_p = "$user_position nd"; } else if($user_position == 43){ $user_p = "$user_position rd"; } else if($user_position == 51){ $user_p = "$user_position st"; } else if($user_position == 52){ $user_p = "$user_position nd"; } else if($user_position == 53){ $user_p = "$user_position rd"; }else{ $user_p = "$user_position th"; } ?>
Student's Name:
Registration No:
Sex:
Term:
Session:
Age : date("md") ? ((date("Y") - $birthDate[2]) - 1) : (date("Y") - $birthDate[2])); } $rows = sql($DBH, "SELECT MIN(id) AS id, class FROM tbl_student_results WHERE registration_no = ? GROUP BY class", array($userst_registration_no), "rows"); foreach($rows as $row) { $userst_class = $row['class']; } $rows = sql($DBH, "SELECT MAX(id) AS id, subclass FROM tbl_student_results WHERE registration_no = ? GROUP BY subclass", array($userst_registration_no), "rows"); foreach($rows as $row) { $userst_subclass = $row['class']; } echo $age; ?> Yr(s)
Class:
No in Class:
Position:

Total Score:
Average Score:
Term Ending:


Total Sch. Days:
Times Present:
Times Absent:

Next Term Begins :


SCHOOL REPORT For
STUDENT'S CONTINUOUS ASSESSMENT REPORT
39 && $total<= 59) { $gradee = "P" AND $remarkk = "Pass"; } else if ($total >59 && $total<= 79) { $gradee = "C" AND $remarkk = "Credit"; } else if ($total >79 && $total<= 100) { $gradee = "D" AND $remarkk = "Distinction"; } echo" "; } ?>
Subject Home Work Test Exam
Score		 Term
Total		 Summary of Term's Work
30 20 50 100 Class
Avg.		 Grade Remarks
$subject $homework $test $exam $total $b_inmav $gradee $remarkk
Grand Total:
% Average:
Remarks:
Grade:
Grade Details: 79-100 = Distinction. 59-78 = Credit. 39-58 = Pass. 0-38 = Fail

AFFECTIVE DOMAIN REPORT
Punctuality
Regularity
Reliability
Neatness
Politeness
Honesty
Initiative
Perseverance
Attentiveness
SelfControl
Obedience
'Sense Of Responsibility'
Hand Writing
Public Speaking
Handling Tools
Drawing
Games
Painting
Sports
Music

Key:
 1 = Exellent.
2 = Very Good.
3 = Good.
4 = Fair.
5 = Poor.




Form Teacher's Comment :
Principal's Comment :