D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
personaldtranscript.php
back
Copy
<?php if (!isset($_SESSION)){ session_start(); } $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; //if(isset($acc) && ($acc=="administratoroftheduresult2018byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php if(isset($_POST['findstudent'])) { $mat=$_POST['mat']; $programmesn=$_POST['programmesn']; $dp=$_POST['decimalplace']; ?> <?php $query_ass="select * from students where matric = '$mat'"; $result_ass=mysql_query($query_ass) or die(mysql_error()); $row_ass=mysql_fetch_assoc($result_ass); $de_ass=$row_ass['de']; $query_dio1 = "SELECT *,r.sn as dsn FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.de='$de_ass'"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); ?> <?php if ($totalRows_dio1==0) { $jkjk="Student with Matric No: <b>".$mat."</b> was not found. It is either there is no student with this matric number or that student has not yet been registered for any session!"; include("personaltranscript.php"); exit(); } ?> <!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--> <?php $sql = "SELECT *,d.namer as dnamer,p.namer as dprog FROM programmes as p inner join departments as d on p.departmentsn=d.sn where p.sn=$programmesn"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_assoc($result); $department=$row['dnamer']; $programme=$row['dprog']; $faculty=$row['facultysn']; $sql = "SELECT *,f.namer as dnamer FROM departments as d inner join faculties as f on d.facultysn=f.sn where d.facultysn=$faculty"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_assoc($result); $faculty=$row['dnamer']; ?> <?php $sql = "SELECT *,date_format(dob,'%b %e, %Y') as dater FROM students where matric='$mat'"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_assoc($result); $yearofentry=$row['yearofentry']; $yearofentry=$yearofentry+1; $yearofentry=$row['yearofentry'] . "/" . $yearofentry; $yearofexit = $yearofentry+4; $matric = $row['matric']; ?> <div style="text-align:center; margin:auto;"> <h3 style="color :red;">TRANSCRIPT OF ACADEMIC RECORDS</h3> </div><br><br> <table width="100%" border="0" cellpadding="3" cellspacing="2"> <tr valign="top"> <td><b>Name: </b><span><?php echo($row['surname']); ?></span>, <?php echo($row['firstname']); ?> <?php echo($row['othernames']); ?></td> <td align="left"><b>Matric. No: </b><?php echo($row['matric']); ?></td> </tr> <tr valign="top"> <td align="left"><b>Date of Birth: </b><?php echo($row['dater']); ?></td> <td><strong>Faculty:</strong> <span style="text-transform:uppercase; font-weight:bold;"><?php echo $faculty; ?></span></td> </tr> <tr valign="top"> <td align="left"><b>Mode of Entry: </b> <?php $ded=$row['de']; if($ded=='DE'){ echo($ded); } else { echo('UTME'); } ?></td> <td align="left"><strong>Programme of Study:</strong><span style="text-transform:uppercase; font-weight:bold;"> <?php echo $programme; ?></span></td> </td> </tr> <tr valign="top"> <td align="left"><b>Year of Admission: </b><?php echo $row['yearofentry']; ?><br /></td> <td><b>Year of Graduation: </b><?php echo $yearofexit; ?><br /> </td> </tr> </tr> </table> <div style="text-align:center"> <p><strong>COURSES TAKEN AND MARKS OBTAINED</strong></p> </div> <table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr valign="top"> <td width="10%" valign="middle" class="cellhead">SESSION</td> <td width="10%" valign="middle" class="cellhead">CODE</td> <td width="40%" valign="middle" class="cellhead">COURSE DESCRIPTION</td> <td width="8%" valign="middle" class="cellhead">STATUS</td> <td width="7%" valign="middle" class="cellhead">MARK</td> <td width="5%" valign="middle" class="cellhead">UNIT</td> <td width="5%" valign="middle" class="cellhead">GP</td> <td width="5%" valign="middle" class="cellhead">WGP</td> <td width="10%" valign="middle" class="cellhead">REMARK</td> </tr> <tr valign="top"> <td colspan="12"> <?php $query_dio1 = "SELECT sum(unit) as dkoko FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='Compulsory' and t.de='$de_ass'"; //$query_dio1 = "SELECT sum(unit) as dkoko FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='Compulsory' 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); ?> <b>Compulsory (<?php echo($row_dio1['dkoko']); ?> Units)</b> </td> </tr> <?php $query_dio1 = "SELECT * FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='Compulsory' and t.de='$de_ass' order by t.session asc, t.code asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); ?> <?php if($totalRows_dio1>0){ $pscor1 = 0; $anum1 = 0; do { $rowscore = $row_dio1['score']; $rowscore = str_replace('.00', '', $rowscore); $pscor1 += $row_dio1['score']; ?> <tr valign="top"> <td class="cellbody3"><?php echo($row_dio1['session']); ?></td> <td class="cellbody3"><?php echo($row_dio1['code']); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody3"><?php echo($row_dio1['status']); ?></td> <td class="cellbody3"><?php echo($row_dio1['score']); ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']); ?></td> <td class="cellbody3"><?php if($row_dio1['score']==NULL){ echo(' '); } else { echo($row_dio1['gp']); } ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']*$row_dio1['gp']); ?></td> <td class="cellbody3"><?php if($row_dio1['score']==NULL){ echo(' '); } else { if($row_dio1['score']>=40){ echo('Passed'); } else { echo('Failed'); } } ?></td> </tr> <?php $anum1++; } while($row_dio1 = mysql_fetch_assoc($dio1)); } else { $anum1 = 0; echo('<tr valign="top"><td colspan="9"> </td></tr>'); } ?> <tr valign="top"> <td colspan="12"> <?php $query_dio1 = "SELECT sum(unit) as dkoko FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='Internal' and t.de='$de_ass'"; //$query_dio1 = "SELECT sum(unit) as dkoko FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='Internal' 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); ?> <b>Internal Required & Electives (<?php echo($row_dio1['dkoko']); ?> Units)</b> </td> </tr> <?php $query_dio1 = "SELECT * FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='Internal' and t.de='$de_ass' order by t.session asc, t.code asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); ?> <?php if($totalRows_dio1>0){ $pscor2 = 0; $anum2 = 0; do { $rowscore = $row_dio1['score']; $rowscore = str_replace('.00', '', $rowscore); $pscor2 += $row_dio1['score']; ?> <tr valign="top"> <td class="cellbody3"><?php echo($row_dio1['session']); ?></td> <td class="cellbody3"><?php echo($row_dio1['code']); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody3"><?php echo($row_dio1['status']); ?></td> <td class="cellbody3"><?php echo($row_dio1['score']); ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']); ?></td> <td class="cellbody3"><?php if($row_dio1['score']==NULL){ echo(' '); } else { echo($row_dio1['gp']); } ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']*$row_dio1['gp']); ?></td> <td class="cellbody3"><?php if($row_dio1['score']==NULL){ echo(' '); } else { if($row_dio1['score']>=40){ echo('Passed'); } else { echo('Failed'); } } ?></td> </tr> <?php $anum2++; } while($row_dio1 = mysql_fetch_assoc($dio1)); } else { $anum2 = 0; echo('<tr valign="top"><td colspan="9"> </td></tr>'); } ?> <tr valign="top"> <td colspan="12"> <?php $query_dio1 = "SELECT sum(unit) as dkoko FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='External' and t.de='$de_ass'"; //$query_dio1 = "SELECT sum(unit) as dkoko FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='External' 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); ?> <b>External Required & Electives (<?php echo($row_dio1['dkoko']); ?> Units)</b> </td> </tr> <?php $query_dio1 = "SELECT * FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.stance='External' and t.de='$de_ass' order by t.session asc, t.code asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); ?> <?php if($totalRows_dio1>0){ $pscor = 0; $anum3 = 0; do { $rowscore = $row_dio1['score']; $rowscore = str_replace('.00', '', $rowscore); $pscor += $row_dio1['score']; ?> <tr valign="top"> <td class="cellbody3"><?php echo($row_dio1['session']); ?></td> <td class="cellbody3"><?php echo($row_dio1['code']); ?></td> <td class="cellbody"> <?php echo($row_dio1['namer']); ?></td> <td class="cellbody3"><?php echo($row_dio1['status']); ?></td> <td class="cellbody3"><?php echo($row_dio1['score']); ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']); ?></td> <td class="cellbody3"><?php if($row_dio1['score']==NULL){ echo(' '); } else { echo($row_dio1['gp']); } ?></td> <td class="cellbody3"><?php echo($row_dio1['unit']*$row_dio1['gp']); ?></td> <td class="cellbody3"><?php if($row_dio1['score']==NULL){ echo(' '); } else { if($row_dio1['score']>=40){ echo('Passed'); } else { echo('Failed'); } } ?></td> </tr> <?php $anum3++; } while($row_dio1 = mysql_fetch_assoc($dio1)); } else { $anum3 = 0; echo('<tr valign="top"><td colspan="9"> </td></tr>'); } ?> <?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 and t.de='$de_ass'"; $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']; $query_dio1 = "SELECT sum(unit) as dunit 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>=40 and t.de='$de_ass'"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $dpass=$row_dio1['dunit']; $query_dio1 = "SELECT sum(unit) as dunit FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.de='$de_ass'"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $totalsub = $anum1+$anum2+$anum3; $dreg=$row_dio1['dunit']; $ppsor = $pscor1+$pscor2+$pscor; $averageall = round(($ppsor/$totalsub),$dp); ?> <tr valign="top"> <td class="cellbody3"> </td> <td class="cellbody3"> </td> <td class="cellbody"> </td> <td class="cellbody3"> </td> <td class="cellbody3"><?php echo $ppsor; ?></td> <td class="cellbody3"><?php echo($dreg); ?></td> <td class="cellbody3"><?php echo($dwgp); ?></td> </tr> <?php $dcgpa=round(($dwgp/$dunit),$dp); ?> </table> <div align="left" style="text-transform:uppercase; padding:20px 5px 50px 5px;"> <p>Total Number of Courses Taken: <b><?php echo($totalsub); ?></b><br /> Total Units Taken: <b><?php echo($dunit); ?></b><br /> Total Units Passed: <b><?php echo($dpass); ?></b><br /> Total Mark Gotten: <b><?php echo "$ppsor.00"; ?></b><br /> Overaall Average: <b><?php echo($averageall); ?></b><br /> <?php /* 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"; } */ $nsql2="select * from comprehensive where matric='$matric'"; $nresult2=mysql_query($nsql2); $ndn2=mysql_num_rows($nresult2); if($ndn2>0){ while($nrow2=mysql_fetch_array($nresult2)){ $secred=$nrow2['secred']; $systematic=$nrow2['systematic']; $moral=$nrow2['moral']; $secredo=$nrow2['secredo']; $systematico=$nrow2['systematico']; $moralo=$nrow2['moralo']; } $caverage = round((($secred+$systematic+$moral+$secredo+$systematico+$moralo)/6),2); ?> <h3>Comprehensive Examination</h3> <table style="border-collapse: collapse;" border="1" cellpadding="5" cellspacing="5" width="50%"> <tr> <td>Sacred Scriptures (Written)</td> <td><b><?php echo($secred); ?></b></td> </tr> <tr> <td>Systematic (Written)</td> <td><b><?php echo($systematic); ?></b></td> </tr> <tr> <td>Moral (Written)</td> <td><b><?php echo($moral); ?></b></td> </tr> <tr> <td>Sacred Scriptures (Oral)</td> <td><b><?php echo($secredo); ?></b></td> </tr> <tr> <td>Systematic (Oral)</td> <td><b><?php echo($systematico); ?></b></td> </tr> <tr> <td>Moral (Oral)</td> <td><b><?php echo($moralo); ?></b></td> </tr> </table> Comprehensive Exam Average: <b><?php echo($caverage); ?></b><br /><br /> <?php }else{ echo "No comprehensive Examination Yet<br>"; $caverage = 0; } $cummu = round((($averageall+$caverage)/2),$dp); //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($cummu<$ddto && $cummu>=$ddfrom){ $dclass=$ddclass; } } } //end of adjustments of class of degree ?> Cummulative Average: <b><?php echo($cummu); ?></b><br /><br /> <h3>Class of Degree: <b><?php echo($dclass); ?></h3></b> </p><br> <p>Grading System</p> <table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr> <th width="35%" scope="col"> <table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <tr> <th align="left" colspan="3" scope="col">United States of America</th> </tr> <tr> <th align="left" scope="col">Scores</th> <th align="center" scope="col"> </th> <th align="center" scope="col"> </th> </tr> <tr> <td align="left">70-100</td> <td align="center">A</td> <td align="center">5</td> </tr> <tr> <td align="left">60-69</td> <td align="center">B+</td> <td align="center">4</td> </tr> <tr> <td align="left">50-59</td> <td align="center">B-</td> <td align="center">3</td> </tr> <tr> <td align="left">45-49</td> <td align="center">C</td> <td align="center">2</td> </tr> <tr> <td align="left">40-44</td> <td align="center">D</td> <td align="center">1</td> </tr> <tr> <td align="left">0-39</td> <td align="center">F</td> <td align="center">0</td> </tr> </table> </th> <th width="35%" scope="col"><table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <tr> <th align="left" colspan="3" scope="col" >Dominican Institute Ibadan</th> </tr> <tr> <th align="left" scope="col">Average(CGPA)</th> <th scope="col"> </th> </tr> <tr> <td align="left">70+</td> <td align="left">A</td> </tr> <tr> <td align="left">60+</td> <td align="left">B+</td> </tr> <tr> <td align="left">50+</td> <td align="left">B-</td> </tr> <tr> <td align="left">45+</td> <td align="left">C</td> </tr> <tr> <td align="left">40+</td> <td align="left">D</td> </tr> <tr> <td align="left">0-39</td> <td align="left">F</td> </tr> </table></th> <th width="30%" scope="col"> <table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <tr> <th align="left" colspan='3' scope="col" >Angelicum Rome</th> </tr> <tr> <th align="left" scope="col">Marks</th> <th align="center" scope="col">Grades</th> </tr> <tr> <td align="left">9.75-10</td> <td align="center">Summa cum Laude</td> </tr> <tr> <td align="left">8.51-9.74</td> <td align="center">Magna cum Laude</td> </tr> <tr> <td align="left">7.51-8.50</td> <td align="center">Cum Laude</td> </tr> <tr> <td align="left">6.51-7.50</td> <td align="center">Bene Probatus</td> </tr> <tr> <td align="left">6.00-6.50</td> <td align="center">Congruenter Probatus</td> </tr> <tr> <td align="left">0-6.49</td> <td align="center">Fail</td> </tr> </table> </th> </tr> </table> </div> <p> </p> <table width="100%" border="0" cellpadding="3" cellspacing="2"> <tr valign="top"> <td width="100%" align="center"> _______________________________<br /> <b>Rev. Fr. Samuel Onyiba, O.P.</b><br> <b>REGISTRAR</b><br> <b>DOMINICAN INSTITUTE, IBADAN</b> </td> </tr> </table> <!--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("personaltranscript.php"); }?> <?php /*} else { include("ddadmin.php"); }*/?>