prepare("select distinct subject_id from marks where (acad_session = :yr and stclass = :kls)" ); $skl->bindparam(':yr' , $yrs) ; $skl->bindparam(':kls' , $cls) ; //$skl->bindparam(':tm' , $trm) ; $skl->execute() ; while($rowsubj = $skl->FETCH(PDO::FETCH_ASSOC)) { $subjarray[] = $rowsubj['subject_id'] ; } $arrlength = count($subjarray); $subg = array() ; for($x = 0; $x < $arrlength; $x++) { $subj = $subjarray[$x] ; //get the subject corressponding to subjarray elements $subjarray[$x] $subjskl = $DBcon->prepare("select subjectname from subjects where subject_id = :id ") ; $subjskl->bindparam(':id' , $subj) ; $subjskl->execute() ; $rowpsubj = $subjskl->FETCH(PDO::FETCH_ASSOC) ; $realsubject = $rowpsubj['subjectname'] ; $subg[] = $realsubject ; } $subglenght = count($subg) ; echo "" ; echo "" ; echo"" ; echo"" ; for($x = 0; $x < $subglenght; $x++) { $real = substr($subg[$x],0,5) ; echo "" ; } echo"" ; echo"" ; //echo"" ; echo"" ; echo "" ; //get the student regno in the specified class and term from the mark table $st = $DBcon->prepare("select distinct stregno from marks where (acad_session =:yr and stclass = :kls) ") ; // $st->bindparam(':tm',$trm) ; $st->bindparam(':kls',$cls) ; $st->bindparam(':yr',$yrs) ; $st->execute() ; if($st->rowcount() > 0) { while($rowreg = $st->FETCH(PDO::FETCH_ASSOC)) { $regnoarray[] = $rowreg['stregno'] ; } } // using the regno extracted get the student name, and subjects scores $subglenght = count($subg) ; $arrayrealname = array() ; $reglenght = count($regnoarray) ; for($x = 0; $x < $reglenght; $x++) { $totalscore = array() ; $totalscore2 = array() ; $totalscore3 = array() ; $val = $regnoarray[$x] ; $stname = $DBcon->prepare("select * from students where regno = :reg") ; $stname->bindparam(':reg',$val) ; $stname->execute() ; if($stname->rowcount() > 0) { $rws = $stname->FETCH(PDO::FETCH_ASSOC) ; $name = $rws['studentname'] ; $arrayrealname[] = $rws['studentname'] ; } else $name = '-' ; echo "" ; echo "" ; echo "" ; foreach ($subjarray as $id) { $ft = 'FIRST TERM' ; $sc = $DBcon->prepare("select * from marks where ((stregno =:reg and subject_id =:ids) and (acad_session =:yr and term =:tm))") ; $sc->bindparam(':reg',$val) ; $sc->bindparam(':ids',$id) ; $sc->bindparam(':tm',$ft) ; $sc->bindparam(':yr',$yrs) ; $sc->execute() ; if($sc->rowcount()>0) { $rwd = $sc->FETCH(PDO::FETCH_ASSOC) ; $test =$rwd['test'] ; $md1 =$rwd['midterm'] ; $ex =$rwd['exam'] ; $tt = $test + $ex + $md1 ; $totalscore[] = $tt ; } else $tt = 0 ; //get 2nd term $ts = 'SECOND TERM' ; $sc2 = $DBcon->prepare("select * from marks where ((stregno =:reg and subject_id =:ids) and (acad_session =:yr and term =:tm))") ; $sc2->bindparam(':reg',$val) ; $sc2->bindparam(':ids',$id) ; $sc2->bindparam(':tm',$ts) ; $sc2->bindparam(':yr',$yrs) ; $sc2->execute() ; if($sc2->rowcount()>0) { $rwd2 = $sc2->FETCH(PDO::FETCH_ASSOC) ; $test2 =$rwd2['test'] ; $md2 =$rwd2['midterm'] ; $ex2 =$rwd2['exam'] ; $tt2 = $test2 + $ex2 + $md2 ; $totalscore2[] = $tt2 ; } else $tt2 = 0 ; //get third $td = 'THIRD TERM' ; $sc3 = $DBcon->prepare("select * from marks where ((stregno =:reg and subject_id =:ids) and (acad_session =:yr and term =:tm))") ; $sc3->bindparam(':reg',$val) ; $sc3->bindparam(':ids',$id) ; $sc3->bindparam(':tm',$td) ; $sc3->bindparam(':yr',$yrs) ; $sc3->execute() ; if($sc3->rowcount()>0) { $rwd3 = $sc3->FETCH(PDO::FETCH_ASSOC) ; $test3 =$rwd3['test'] ; $md3 =$rwd3['midterm'] ; $ex3 =$rwd3['exam'] ; $tt3 = $test3 + $ex3 + $md3 ; $totalscore3[] = $tt3 ; } else $tt3 = 0 ; if(($tt > 0) and ($tt2 > 0) and ($tt3 > 0)) { $ovt = $tt + $tt2 + $tt3 ; $ova = $ovt / 3 ; } elseif(($tt == 0) and ($tt2 == 0) and ($tt3 > 0)) { $ovt = $tt3 ; $ova = $ovt / 1 ; } elseif(($tt == 0) and ($tt2 == 0) and ($tt3 == 0)) { $ovt= '-' ; $ova = '-' ; } elseif(($tt > 0) and ($tt2 == 0) and ($tt3 == 0)) { $ovt = $tt ; $ova = $ovt / 1 ; } elseif(($tt == 0) and ($tt2 > 0 ) and ($tt3 == 0)) { $ovt = $tt2 ; $ova = $ovt / 1 ; } elseif(($tt > 0 ) and ($tt2 > 0 ) and ($tt3 == 0)) { $ovt = $tt + $tt2 ; $ova = $ovt / 2 ; } elseif(($tt == 0) and ($tt2 > 0) and ($tt3 > 0)) { $ovt = $tt3 + $tt2 ; $ova = $ovt / 2 ; } elseif(($tt > 0) and ($tt2 == 0) and ($tt3 > 0)) { $ovt = $tt + $tt3 ; $ova = $ovt / 2 ; } //$ot = $tt + $tt2 + $tt3 ; //set average array if($ova <> '-') $avs[] = $ova ; echo"" ; //echo"" ; } //work average $tts = array_sum($totalscore) ; $tts2 = array_sum($totalscore2) ; $tts3 = array_sum($totalscore3) ; $ots = $tts + $tts2 + $tts3 ; $numrow = count($totalscore) ; $numrow2 = count($totalscore2) ; $numrow3 = count($totalscore3) ; //GET MINIMUM NO OF SUBJETS $term1 = 'FIRST TERM' ; $sqlm1 = $DBcon->prepare("select * from subjno where (classlevel = :kls and term = :tm) and yr = :y ") ; $sqlm1->bindparam(':kls' , $stclass) ; $sqlm1->bindparam(':tm' , $term1) ; $sqlm1->bindparam(':y',$yrs) ; $sqlm1->execute() ; $rowm1 = $sqlm1->FETCH(PDO::FETCH_ASSOC) ; $min1 = $rowm1['nos'] ; if($tts > 0) { if($numrow < $min1) $av = $tts / $min1 ; else $av = $tts / $numrow ; } else $av = 0 ; //2nd term //GET MINIMUM NO OF SUBJETS $term2 = 'SECOND TERM' ; $sqlm2 = $DBcon->prepare("select * from subjno where (classlevel = :kls and term = :tm) and yr = :y ") ; $sqlm2->bindparam(':kls' , $stclass) ; $sqlm2->bindparam(':tm' , $term2) ; $sqlm2->bindparam(':y',$yrs) ; $sqlm2->execute() ; $rowm2 = $sqlm2->FETCH(PDO::FETCH_ASSOC) ; $min2 = $rowm2['nos'] ; if($tts2 > 0) { if($numrow2 < $min2) $av2 = $tts2 / $min2 ; else $av2 = $tts2 / $numrow2 ; } else $av2 = 0 ; //if($tts2 > 0) $av2 = $tts2 / $numrow2 ; else $av2 = 0 ; //3rd term //GET MINIMUM NO OF SUBJETS $term3 = 'THIRD TERM' ; $sqlm3 = $DBcon->prepare("select * from subjno where (classlevel = :kls and term = :tm) and yr = :y ") ; $sqlm3->bindparam(':kls' , $stclass) ; $sqlm3->bindparam(':tm' , $term3) ; $sqlm3->bindparam(':y',$yrs) ; $sqlm3->execute() ; $rowm3 = $sqlm3->FETCH(PDO::FETCH_ASSOC) ; $min3 = $rowm3['nos'] ; if($tts3 > 0) { if($numrow3 < $min3) $av3 = $tts3 / $min3 ; else $av3 = $tts3 / $numrow3 ; } else $av3 = 0 ; // if($tts3 > 0) $av3 = $tts3 / $numrow3 ; else $av3 = 0 ; $tav = $av + $av2 + $av3 ; $otav = $tav / 3 ; //$ots = array_sum($avs) ; echo"" ; //cumulative average $countx = count($avs) ; // $otav = $ots / $countx ; echo "" ; // echo "" ; if($otav >= 40.00) $stu = 'Pass'; else $stu = 'Fail'; echo "" ; echo ""; $avs = array() ; } //$rlenght = count($arrayrealname) ; // for($x = 0; $x < $rlenght; $x++) //{ // } //echo"" ; // echo"" ; echo "

". 'NAME' ."	". 'REGNO' ."	" . $real . "	". 'TOTAL' ."	". 'AVG' ."	". 'POS' ."	". 'STATUS' ."
".$name."	".$val."	".$ovt."	".round($ova,2)."	". $ots ."	".round($otav,2)."	".'NY'."	".$stu."
".'non'."

" ; ?>