D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
personaldyearly.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($_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'"; //echo($query_dio1); //exit(); $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"); ?> <script src="bar/dhtmlxchart.js" type="text/javascript"></script> <link rel="STYLESHEET" type="text/css" href="bar/dhtmlxchart.css"> </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 dnamer2,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']; $prog=$row['dnamer2'] . " " . $row['dnamer']; $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; ?> <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> <td align="left"><strong>Course of Study:</strong><span style="text-transform:uppercase; font-weight:bold;"> <?php echo $programme; ?></span></td> </tr> <tr valign="top"> <td><strong>Faculty:</strong> <span style="text-transform:uppercase; font-weight:bold;"><?php echo $faculty; ?></span></td> <td align="left"><b>Date of Birth: </b><?php echo($row['dater']); ?></td> <td align="left"><strong>Gender: </strong></td> </tr> <tr valign="top"> <td ><strong>Nationality: </strong><br /></td> <td align="left"><b>Mode of Entry: </b> <?php $ded=$row['de']; if($ded=='DE'){ echo($ded); } else { echo('UTME'); } ?></td> <td align="left"><b>Year of Admission: </b><?php echo $row['yearofentry']; ?><br /></td> </tr> <tr valign="top"> <td ><b>Session of Admission: </b><?php echo $yearofentry; ?></td> <td align="left"><strong>Year of Graduation:</strong></td> <td align="left"><strong>Class of Degree: </strong></td> </tr> </table> <p> </p> <?php $query_dio1 = "SELECT distinct(session) 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' order by session asc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $felinum = mysql_num_rows($dio1); $i=0; while($row_dio1 = mysql_fetch_assoc($dio1)){ $i++; $feli[$i]=$row_dio1['session']; } ?> <?php for($i=1;$i<=$felinum;$i++){ $j=$i%2; ?> <table border="1" cellpadding="5" cellspacing="5" style="float:left; border-collapse:collapse <?php if($j==1){ echo('clear:left;'); } ?>"> <tr valign="top"> <td colspan="9" align="center"> <b>YEAR <?php echo($i); ?> COURSES - <?php echo($feli[$i]); ?></b> </td></tr> <tr valign="top"> <td width="25%" rowspan="2" valign="middle" class="cellhead">COURSE</td> <td width="15%" rowspan="2" valign="middle" class="cellhead">STATUS</td> <td width="15%" rowspan="2" valign="middle" class="cellhead">MARK</td> <td width="15%" rowspan="2" valign="middle" class="cellhead">UNIT</td> <td width="15%" rowspan="2" valign="middle" class="cellhead">GP</td> <td width="15%" rowspan="2" valign="middle" class="cellhead">WGP</td> <td colspan="3" valign="middle" class="cellhead">APPROVAL STATUS</td> </tr> <tr valign="top"> <td width="15%" valign="middle" class="cellhead">DEPT</td> <td width="15%" valign="middle" class="cellhead">FAC</td> <td width="15%" valign="middle" class="cellhead">SEN</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.session='".$feli[$i]."' and t.de='$de_ass' order by 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){ do { ?> <tr valign="top"> <td class="cellbody3"><?php echo($row_dio1['code']); ?></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 echo $row_dio1['dept_status']; ?></td> <td class="cellbody3"><?php echo $row_dio1['fac_status']; ?></td> <td class="cellbody3"><?php echo $row_dio1['sen_status']; ?></td> </tr> <?php } while($row_dio1 = mysql_fetch_assoc($dio1)); } else { echo('<tr valign="top"><td colspan="6"> </td></tr>'); } ?> <tr valign="top"> <td colspan="9" align="left"> <?php $query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.session='".$feli[$i]."' 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); ?> <b> Units Taken: </b><?php echo($row_dio1['eli']); $ut=$row_dio1['eli']; ?> </td></tr> <tr valign="top"> <td colspan="9" align="left"> <?php $query_dio1 = "SELECT sum(unit) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.session='".$feli[$i]."' 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); ?> <b> Units Passed: </b><?php echo($row_dio1['eli']); ?> </td></tr> <tr valign="top"> <td colspan="9" align="left"> <?php $query_dio1 = "SELECT sum(unit*gp) as eli FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.session='".$feli[$i]."' 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); ?> <b> Weighted Grade Point: </b><?php echo($row_dio1['eli']); $wgp=$row_dio1['eli']; ?> </td></tr> <tr valign="top"> <td colspan="9" align="left"> <?php $cgpa[$i]=round(($wgp/$ut),$dp); ?> <b> Cumulative Grade Point Average: </b><?php echo($cgpa[$i]); ?> </td></tr> <tr valign="top"> <td colspan="9" align="left"><strong>KEYS: </strong>DEPT=Department, FAC=Faculty, SEN=Senate, A=Approved, NYA=Not Yet Approved.</td> </tr> <tr valign="top"> <td colspan="9" align="left"><table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr> <th width="50%" scope="col"><table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <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">C</td> <td align="center">3</td> </tr> <tr> <td align="left">45-49</td> <td align="center">D</td> <td align="center">2</td> </tr> <tr> <td align="left">40-44</td> <td align="center">E</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="50%" scope="col"><table width="100%" border="1" cellspacing="1" cellpadding="1" style="border-collapse:collapse"> <tr> <th align="left" scope="col">Average(CGPA)</th> <th scope="col"> </th> </tr> <tr> <td align="left">4.50-5.00</td> <td align="left">First Class</td> </tr> <tr> <td align="left">3.50-4.49</td> <td align="left">2nd Class Upper</td> </tr> <tr> <td align="left">2.40-3.49</td> <td align="left">2nd Class Lower</td> </tr> <tr> <td align="left">1.50-2.39</td> <td align="left">Third Class</td> </tr> <tr> <td align="left">1.00-1.49</td> <td align="left">Pass</td> </tr> <tr> <td align="left">0.00-1.48</td> <td align="left">Fail</td> </tr> </table></th> </tr> <tr> <td> </td> <td> </td> </tr> </table></td> </tr> </table> <?php } ?> <br style="clear:both;" /> <p> </p> <div id="chart" style="width:350px;height:150px;border:1px solid #A4BED4; float:right;"></div> <div style="padding:20px 0px 10px 0px;"> <?php $query_dio1 = "SELECT sum(unit) as eli 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); ?> <b> Total Units Taken: </b><?php echo($row_dio1['eli']); $ut=$row_dio1['eli']; ?><br /> <?php $query_dio1 = "SELECT sum(unit) as eli 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); ?> <b> Total Units Passed: </b><?php echo($row_dio1['eli']); ?><br /> <?php $query_dio1 = "SELECT sum(unit*gp) as eli 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); ?> <b> Weighted Grade Point: </b><?php echo($row_dio1['eli']); $wgp=$row_dio1['eli']; ?><br /> <?php $dcgpa=round(($wgp/$ut),$dp); ?> <b> Cumulative Grade Point Average: </b><?php echo($dcgpa); ?><br /> <?php //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"; } */ ?> <b> Class of Degree: </b><?php echo($dclass); ?> </div> <table width="100%" border="0" cellpadding="3" cellspacing="2" style="padding-top:40px;"> <tr valign="top"> <td width="50%"> </td> <td width="50%" align="center"> ______________________________<br /> <b> REGISTRAR</b></td> </tr> </table> <script> var data = [ <?php for($i=1;$i<=$felinum;$i++){ ?> { CGPA:"<?php echo($cgpa[$i]); ?>", Year:"<?php echo($i); ?>" }, <?php } ?> { CGPA:"<?php echo($dcgpa); ?>", Year:"All" } ]; var barChart = new dhtmlXChart({ view:"barH", container:"chart", value:"#CGPA#", width:20, label: "#CGPA#", gradient:"3d", color:"#ffcc00", xAxis:{ start:0, end:7, step:1, title:"CGPA", lines: true }, yAxis:{ title:"Year(s)", template:"#Year#" }, padding:{ left:75, right:30 } }) barChart.parse(data,"json"); </script> <!--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("personaldyearly.php"); }?> <?php /*} else { include("ddadmin.php"); }*/?>