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_test1 = $row1['test1']; $u_test2 = $row1['test2']; $u_project = $row1['project']; $u_exam = $row1['exam']; $total = ($u_test1 + $u_test2 + $u_project + $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_test1 = $row2['test1']; $us_test2 = $row2['test2']; $us_project = $row2['project']; $us_exam = $row2['exam']; $us_total = $row2['total']; $us_class = $row2['class']; $us_year = $row2['year']; $us_term = $row2['term']; if($us_total <=29){ $grade = "Fail"; } else if ($us_total >29 && $us_total<= 39) { $grade = "Fair"; } else if ($us_total >39 && $us_total<= 49) { $grade = "Faily Good"; } else if ($us_total >49 && $us_total<= 59) { $grade = "Good"; } else if ($us_total >59 && $us_total<= 69) { $grade = "Very Good"; } else if ($us_total >69 && $us_total<= 79) { $grade = "Excellent"; } else if ($us_total >79 && $us_total<= 100) { $grade = "Very Excellent"; } 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"); } } ?> PASSION MODERN SCHOOLS: My Term Result!
PASSION MODERN SCHOOLS
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 <=29){ $htcomments = "Failure, sit up next term for a better result" AND $cgrade = "F"; } else if ($AverageScore >29 && $AverageScore<= 39) { $htcomments = "Fair Result, put more effort as greater tasks await you." AND $cgrade = "E"; } else if ($AverageScore >39 && $AverageScore<= 49) { $htcomments = "Fairly Good result, read harder as greater tasks await you." AND $cgrade = "D"; } else if ($AverageScore >49 && $AverageScore<= 59) { $htcomments = "Good Result, read harder to improve me" AND $cgrade = "C"; } else if ($AverageScore >59 && $AverageScore<= 69) { $htcomments = "Very Good commendable term's work. Keep the light glowing" AND $cgrade = "B"; } else if ($AverageScore >69 && $AverageScore<= 79) { $htcomments = "Excellent Impressive Result. Don't relent in your effort" AND $cgrade = "A"; } else if ($AverageScore >79 && $AverageScore<= 100) { $htcomments = "Very Excellent Result, Keep it up" AND $cgrade = "A+"; } $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{ $user_p = "- - -"; } ?>
Name of Pupil:
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) [DoB is ]
Class:
No in Class:
Total Score:
Position:    Grade:
Average Score:
Class Average Score:

Times Sch. Opened:
Times Present:
Times Absent:
Times Punctual:

Term Ending:
Next Term Begins :


PUPIL'S CONT. ASSESSMENT REPORT

ACTIVITIES
29 && $total<= 39) { $grade = "E"; } else if ($total >39 && $total<= 49) { $grade = "D"; } else if ($total >49 && $total<= 59) { $grade = "C"; } else if ($total >59 && $total<= 69) { $grade = "B"; } else if ($total >69 && $total<= 79) { $grade = "A"; } else if ($total >79 && $total<= 100) { $grade = "A+"; } echo" "; } ?>
Subject Cumm. Total Grade
$subject $total $grade

Reading Activities
Number Activities
Creative Activities
Nursery Rhymes
Music
Physical Activities
Games

PERSONAL QUALITIES

Self Confidence
Sociability
Inteligence
Interest & Curiousity
Comprehension
Personal Cleanliness


Class Teacher's Remarks:
Co-ordinator's Comment: