D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
graduatingdcover.php
back
Copy
<?php if (!$_SESSION){ session_start(); } $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; //if(isset($acc) && ($acc=="administratoroftheduresult2018byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php if(isset($_GET['checksession'])) { $programmesn=$_GET['programmesn']; $session=$_GET['session']; $se=$session+1; $session=$session."/".$se; $sql = "SELECT *,programmes.sn as feli1,programmes.namer as feli2,departments.namer as feli3 FROM programmes inner join departments on programmes.departmentsn = departments.sn where programmes.sn=$programmesn"; $result = mysql_query($sql); $row=mysql_fetch_array($result); $feli=$row['feli2']. " [" . $row['feli3']. "]"; $dom=$row['numberofyears']; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php include("head.php"); ?> </head> <body> <?php include("top1.php"); ?> <?php include("dtable0.php"); ?> <?php include("nav.php"); ?> <?php include("dtable1.php"); ?> <?php include("topcontainer.php"); ?> <!--Content Goes Here--> <div align="center" style="text-transform:uppercase; font-weight:bold;"> DOMINICAN UNIVERSITY, IBADAN<BR /> GRADUATING STUDENTS FOR <?php echo $session; ?> ACADEMIC SESSION<BR /> </div> <hr /> <div align="left" style="text-transform:uppercase; font-weight:bold;"><?php echo $feli; ?></div> <?php $sql1="delete from tempgraduating"; if (!mysql_query($sql1)){ echo("Unable to delete from tempgraduating: " . mysql_error()); exit(); } $query_dio2 = "SELECT * FROM studentsexisting where programmesn=$programmesn and session='$session' and level=$dom and status='good'"; $dio2 = mysql_query($query_dio2, $csn) or die(mysql_error()); $row_dio2 = mysql_fetch_assoc($dio2); $totalRows_dio2 = mysql_num_rows($dio2); $domnum=$totalRows_dio2; if($totalRows_dio2>0){ do { $mat=$row_dio2['matric']; $de=$row_dio2['de']; ?> <?php $query_dio1 = "SELECT sum(unit) as dunit, sum(unit*gp) as dwgp FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and r.score>=0"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $dunit=$row_dio1['dunit']; $dwgp=$row_dio1['dwgp']; $dcgpa=round(($dwgp/$dunit),2); //adjustments of class of degree $nsql="select * from classofdegree where status='active' order by sn desc"; $nresult=mysql_query($nsql); $ndn=mysql_num_rows($nresult); if($ndn>0){ while($nrow=mysql_fetch_array($nresult)){ $ddclass=$nrow['class1']; $ddfrom=$nrow['dfrom']; $ddto=$nrow['dto']; if($dcgpa<$ddto && $dcgpa>=$ddfrom){ $dclass=$ddclass; } } } //end of adjustments of class of degree /* if($dcgpa>=6.0){ $dclass="First Class"; } if($dcgpa<6.0 && $dcgpa>=4.6){ $dclass="Second Class Upper"; } if($dcgpa<4.6 && $dcgpa>=2.9){ $dclass="Second Class Lower"; } if($dcgpa<2.9 && $dcgpa>=1.6){ $dclass="Third Class"; } if($dcgpa<1.6 && $dcgpa>=1.5){ $dclass="Pass"; } if($dcgpa<1.5){ $dclass="Fail"; } */ $sql1="select * from students where matric='$mat'"; $result1=mysql_query($sql1); $row1=mysql_fetch_array($result1); $dnamer=strtoupper($row1['surname']) . ", " . $row1['firstname'] . " " . $row1['othernames']; $sql="insert into tempgraduating (namer,matric,entry,classofdegree) values ('$dnamer','$mat','$de','$dclass')"; $result=mysql_query($sql); ?> <?php } while($row_dio2 = mysql_fetch_assoc($dio2)); ?> <table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr valign="top"> <td class="cellhead" width="40px">S/N</td> <td class="cellhead">NAME OF STUDENT</td> <td class="cellhead">MATRICULATION NUMBER</td> <td class="cellhead">ENTRY TYPE</td> </tr> <?php $query_dio1 = "SELECT * FROM tempgraduating where classofdegree='First Class' order by namer asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $i=0; ?> <?php if($totalRows_dio1>0){ ?> <tr valign="top"> <td> </td> <td colspan="3"> <div style="font-weight:bold; text-transform:uppercase;">First Class</div> </td> </tr> <?php do { $i++; ?> <tr valign="top"> <td class="cellbody2"><?php echo($i); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody"> <?php echo($row_dio1['matric']); ?></td> <td class="cellbody"> <?php echo($row_dio1['entry']); ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } ?> <?php $query_dio1 = "SELECT * FROM tempgraduating where classofdegree='Second Class Upper' order by namer asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $i=0; ?> <?php if($totalRows_dio1>0){ ?> <tr valign="top"> <td> </td> <td colspan="3"> <div style="font-weight:bold; text-transform:uppercase;">Second Class Upper</div> </td> </tr> <?php do { $i++; ?> <tr valign="top"> <td class="cellbody2"><?php echo($i); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody"> <?php echo($row_dio1['matric']); ?></td> <td class="cellbody"> <?php echo($row_dio1['entry']); ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } ?> <?php $query_dio1 = "SELECT * FROM tempgraduating where classofdegree='Second Class Lower' order by namer asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $i=0; ?> <?php if($totalRows_dio1>0){ ?> <tr valign="top"> <td> </td> <td colspan="3"> <div style="font-weight:bold; text-transform:uppercase;">Second Class Lower</div> </td> </tr> <?php do { $i++; ?> <tr valign="top"> <td class="cellbody2"><?php echo($i); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody"> <?php echo($row_dio1['matric']); ?></td> <td class="cellbody"> <?php echo($row_dio1['entry']); ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } ?> <?php $query_dio1 = "SELECT * FROM tempgraduating where classofdegree='Third Class' order by namer asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $i=0; ?> <?php if($totalRows_dio1>0){ ?> <tr valign="top"> <td> </td> <td colspan="3"> <div style="font-weight:bold; text-transform:uppercase;">Third Class</div> </td> </tr> <?php do { $i++; ?> <tr valign="top"> <td class="cellbody2"><?php echo($i); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody"> <?php echo($row_dio1['matric']); ?></td> <td class="cellbody"> <?php echo($row_dio1['entry']); ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } ?> <?php $query_dio1 = "SELECT * FROM tempgraduating where classofdegree='Pass' order by namer asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $i=0; ?> <?php if($totalRows_dio1>0){ ?> <tr valign="top"> <td> </td> <td colspan="3"> <div style="font-weight:bold; text-transform:uppercase;">Pass</div> </td> </tr> <?php do { $i++; ?> <tr valign="top"> <td class="cellbody2"><?php echo($i); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody"> <?php echo($row_dio1['matric']); ?></td> <td class="cellbody"> <?php echo($row_dio1['entry']); ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } ?> <?php $query_dio1 = "SELECT * FROM tempgraduating where classofdegree='Fail' order by namer asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $i=0; ?> <?php if($totalRows_dio1>0){ ?> <tr valign="top"> <td> </td> <td colspan="3"> <div style="font-weight:bold; text-transform:uppercase;">Fail</div> </td> </tr> <?php do { $i++; ?> <tr valign="top"> <td class="cellbody2"><?php echo($i); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody"> <?php echo($row_dio1['matric']); ?></td> <td class="cellbody"> <?php echo($row_dio1['entry']); ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } ?> </table> <div align="left" style="font-weight:bold;">Total Number of Students: <?php echo $domnum; ?></div> <table width="100%" border="0" cellpadding="3" cellspacing="2" style="padding-top:40px;"> <tr valign="top"> <td width="30%"> ______________________________<br /> <b>DEAN</b><br /> <b>DOMINICAN UNIVERSITY</b> </td> <td width="40%" align="center"> ______________________________<br /> <b>EXTERNAL EXAMINER</b><br /> <b> </b> </td> <td width="30%" align="right"> ______________________________<br /> <b>HEAD OF DEPARTMENT</b><br /> <b>DOMINICAN UNIVERSITY</b> </td> </tr> </table> <?php } else { echo("<div> </div>No Graduating Students!"); } ?> <!--Content Ends Here--> <?php include("bottomcontainer.php"); ?> <?php //include("dtable2.php"); ?> <?php //include("side.php"); ?> <?php include("dtable3.php"); ?> <?php include("foot.php"); ?> </body> </html> <?php } else { include("dadmin.php"); }?> <?php /*} else { include("ddadmin.php"); }*/?>