|
0)
//echo $ts;
// else
// echo '-' ;
?>
prepare("select * from subjno where (classlevel = :kls and term = :tm) and yr = :y ") ;
$sqlm3->bindparam(':kls' , $stclass) ;
$sqlm3->bindparam(':tm' , $term3) ;
$sqlm3->bindparam(':y',$schyear) ;
$sqlm3->execute() ;
$rowm3 = $sqlm3->FETCH(PDO::FETCH_ASSOC) ;
$min3 = $rowm3['nos'] ;
$avgq = $DBcon->prepare("select * from marks where (acad_session =:yr and stclass =:kls) and (term = :tm AND stregno = :reg)") ;
$avgq->bindparam(':yr' , $schyear) ;
$avgq->bindparam(':kls' , $classid) ;
$avgq->bindparam(':tm' , $term3) ;
$avgq->bindparam(':reg' , $regno) ;
$avgq->execute() ;
$num3 =$avgq->rowcount() ;
if($num3 > 0)
{
$count3 = array_sum($thirdtot) ;
if($num3 < $min3)
$avg3 = $count3 / $min3 ;
else
$avg3 = $count3 / $num3 ;
//echo round($avg3,2) ;
}
else
{
$avg3 = '-' ;
//echo $avg3 ;
}
?>
prepare("select * from marks where (stclass = :kls and acad_session = :yr) and (stregno = :reg ) ") ;
$so->bindparam(':kls' , $classid) ;
$so->bindparam(':yr' , $schyear) ;
$so->bindparam(':reg' , $regno) ;
//$so->bindparam(':tm' , $term) ;
$so->execute() ;
//$res = mysql_query($so) or die('Error: ' . mysql_error()) ;
while ($ro = $so->FETCH(PDO::FETCH_ASSOC))
{
$fst = $ro['test'] ;
$sc = $ro['midterm'] ;
$exa = $ro['exam'] ;
$tom = $fst + $sc + $exa ;
$maya[] = $tom ;
}
$cal = array_sum($maya) ;
//start
$streamno = array();
$arresult = array() ;
$myarray = array() ;
//$finarray = array() ;
$sqla = $DBcon->prepare("select distinct stregno from marks where (stclass =:kls and acad_session =:yr) " ) ;
$sqla->bindparam(':kls',$classid) ;
$sqla->bindparam(':yr',$schyear) ;
//$sqla->bindparam(':tm',$term) ;
$sqla->execute() ;
//$exec = mysql_query($sqla) or die('Error: ' . mysql_error());
//$row = mysql_fetch_array($exec) ;
while ($streamrow = $sqla->FETCH(PDO::FETCH_ASSOC))
{
$streamno[] = $streamrow['stregno'];
}
foreach ($streamno as $val)
{
$sqlgo =$DBcon->prepare("select * from marks where ((stregno = :v and stclass = :kls) and (acad_session = :yr)) ") ;
$sqlgo->bindparam(':v',$val) ;
$sqlgo->bindparam(':kls',$classid) ;
//$sqlgo->bindparam(':tm',$term) ;
$sqlgo->bindparam(':yr',$schyear) ;
$sqlgo->execute() ;
//$go = mysql_query($sqlgo) or die('Error: ' . mysql_error());
//$gorow = mysql_fetch_array($go) ;
$rownumber = $sqlgo->rowcount() ;
while ($gorow = $sqlgo->FETCH(PDO::FETCH_ASSOC))
{
$first = $gorow['test'] ;
$sec = $gorow['midterm'] ;
$ex = $gorow['exam'] ;
$tota = $first + $sec + $ex ;
$myarray[] = $tota ;
//$myarray[] = $ar ;
}
$tosum = array_sum($myarray) ;
if($rownumber < $min)
$ar = $tosum/$min ;
else
$ar = $tosum/$rownumber;
$arresult[] = $ar ;
$myarray = array() ;
}
arsort($arresult) ;
$ps = 0 ;
foreach($arresult as $tot)
{
$ps++ ; $app = position($ps) ;
if($avg3 == $tot)
{
//echo $ps.$app ;
break ;
}
}
?>
Cumulative Grade: Total Score:
Average Score:
prepare("select * from subjno where (classlevel = :kls and term = :tm) and yr = :y ") ;
$sqlm1->bindparam(':kls' , $stclass) ;
$sqlm1->bindparam(':tm' , $term1) ;
$sqlm1->bindparam(':y',$schyear) ;
$sqlm1->execute() ;
$rowm1 = $sqlm1->FETCH(PDO::FETCH_ASSOC) ;
$min1 = $rowm1['nos'] ;
$avgq1 =$DBcon->prepare("select * from marks where (acad_session = :yr and stclass = :kls) and (term = 'FIRST TERM' AND stregno = :reg)") ;
$avgq1->bindparam(':yr',$schyear) ;
$avgq1->bindparam(':kls',$classid) ;
$avgq1->bindparam(':reg',$regno) ;
$avgq1->execute() ;
//$exavgq1 = mysql_query($avgq1) ;
$num1 = $avgq1->rowcount();
if($num1 > 0)
{
$count1 = array_sum($firsttot) ;
if($num1 < $min1)
$avg1 = $count1 / $min1 ;
else
$avg1 = $count1 / $num1 ;
}
else
$avg1 = '-' ;
// get second term average
//get minimum no of subject
$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',$schyear) ;
$sqlm2->execute() ;
$rowm2 = $sqlm2->FETCH(PDO::FETCH_ASSOC) ;
$min2 = $rowm2['nos'] ;
$avgq2 =$DBcon->prepare("select * from marks where (acad_session = :yr and stclass = :kls) and (term ='SECOND TERM' AND stregno = :reg)") ;
$avgq2->bindparam(':yr',$schyear) ;
$avgq2->bindparam(':kls',$classid) ;
$avgq2->bindparam(':reg',$regno) ;
$avgq2->execute() ;
//$exavgq2 = mysql_query($avgq2) ;
$num2 = $avgq2->rowcount() ;
if($num2 > 0)
{
$count2 = array_sum($secondtot) ;
if($num2 < $min2)
$avg2 = $count2 / $min2 ;
else
$avg2 = $count2 / $num2 ;
}
else
$avg2 = '-' ;
if(($avg1 == '-') and ($avg2 == '-') and ($avg3 == '-'))
{
$cuv = '-' ;
}
elseif(($avg1 == '-') and ($avg2 == '-') and ($avg3 > 0))
{
$cuv = $avg3 ;
}
elseif(($avg1 > 0) and ($avg2 > 0) and ($avg3 > 0))
{
$cumavgt = $avg1 + $avg2 + $avg3 ;
$cuv = $cumavgt / 3 ;
}
elseif(($avg1 > 0) and ($avg2 == '-') and ($avg3 == '-'))
{
$cuv = $avg1 ;
}
elseif(($avg1 == '-') and ($avg2 > 0 ) and ($avg3 == '-'))
{
$cuv = $avg2 ;
}
elseif(($avg1 > 0 ) and ($avg2 > 0 ) and ($avg3 == '-'))
{
$cumavgt = $avg1 + $avg2 ;
$cuv = $cumavgt / 2 ;
}
elseif(($avg1 == '-') and ($avg2 > 0) and ($avg3 > 0))
{
$cumavgt = $avg3 + $avg2 ;
$cuv = $cumavgt / 2 ;
}
elseif(($avg1 > 0) and ($avg2 == '-') and ($avg3 > 0))
{
$cumavgt = $avg1 + $avg3 ;
$cuv = $cumavgt / 2 ;
}
//$cuv = $cumavgt / 3 ;
echo round($cuv, 2) ;
?>
Position:
prepare("select * from marks where (stregno = :reg and acad_session = :yr) and stclass =:kls ") ;
$so->bindparam(':reg',$regno) ;
$so->bindparam(':yr',$schyear) ;
$so->bindparam(':kls',$classid) ;
$so->execute() ;
//$res = mysql_query($so) or die('Error: ' . mysql_error()) ;
$rn = $so->rowcount();
while ($ro = $so->FETCH(PDO::FETCH_ASSOC))
{
$fst = $ro['test'] ;
$snd = $ro['midterm'] ;
$exa = $ro['exam'] ;
$tom = $fst + $snd + $exa ;
$maya[] = $tom ;
}
$cal = array_sum($maya) ;
$av1 = $cal / $rn ;
//start
$streamno = array();
$arresult = array() ;
$myarray = array() ;
//$finarray = array() ;
$sqla =$DBcon->prepare("select distinct stregno from marks where (stclass = :kls and acad_session = :yr) ") ;
$sqla->bindparam(':kls',$classid) ;
$sqla->bindparam(':yr',$schyear) ;
$sqla->execute();
while ($streamrow = $sqla->FETCH(PDO::FETCH_ASSOC))
{
$streamno[] = $streamrow['stregno'];
}
foreach ($streamno as $val)
{
$sqlgo = $DBcon->prepare("select * from marks where(stregno = :v and acad_session = :yr) ") ;
$sqlgo->bindparam(':v',$val) ;
$sqlgo->bindparam(':yr',$schyear) ;
$sqlgo->execute();
//$go = mysql_query($sqlgo) or die('Error: ' . mysql_error());
$rownumber = $sqlgo->rowcount() ;
//$gorow = mysql_fetch_array($go) ;
while ($gorow = $sqlgo->FETCH(PDO::FETCH_ASSOC))
{
$first = $gorow['test'] ;
$sec = $gorow['midterm'] ;
$ex = $gorow['exam'] ;
$tota = $first + $sec + $ex ;
$myarray[] = $tota ;
}
$tosum = array_sum($myarray) ;
$ar = $tosum/$rownumber;
$arresult[] = $ar ;
// $arresult[] = $tosum ;
$myarray = array() ;
}
arsort($arresult) ;
$ps = 0 ;
foreach($arresult as $tot)
{
$ps++ ; $ap = position($ps) ;
if($av1 == $tot)
{
echo $ps.$ap ;
break ;
}
}
?>
Out of |
