1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : semesterdresult2.php
back
<?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'])) {
	$de=$_GET['de'];
	$semester=$_GET['semester'];
	$level=$_GET['level'];
	$programmesn=$_GET['programmesn'];
	$session=$_GET['session'];
	$se=$session+1;
	$session=$session."/".$se;
	
	$dp=$_GET['decimalplace'];
	

$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']. "]";

$dept=$row['feli3'];
$prog=$row['feli2'];
?>

<!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">


<style>
.wie { width:20px; }
.wie2 { width:30px; }
</style>


</head>
<body>

<?php include("top.php"); ?>
<?php include("dtable0no.php"); ?>
<?php include("nav.php"); ?>
<?php include("dtable1no.php"); ?>
<?php include("topcontainer.php"); ?>
<!--Content Goes Here-->
<div align="center">
<div class="headingnormal">RESULTS TABLE</div>
<div class="headingnormal">DEPARTMENT OF <?php echo $dept; ?></div>
<div class="headingnormal">PROGRAMME: <?php echo $prog; ?></div>

<div class="headingbiggest"><?php echo $session; ?> Session, Year <?php echo $level; ?> <?php echo $de; ?>, Semester <?php echo $semester; ?></div>
</div>
<div>&nbsp;</div>

<?php
$sql = "SELECT * FROM coursestobetaken where session='$session' and level=$level and semester=$semester and de='$de' and programmesn=$programmesn";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
if($num>0){
?>



<?php
$query_dio2 = "SELECT * FROM studentsexisting where programmesn=$programmesn and session='$session' and level=$level and status='good' and de='$de'";
$dio2 = mysql_query($query_dio2, $csn) or die(mysql_error());
$row_dio2 = mysql_fetch_assoc($dio2);
$totalRows_dio2 = mysql_num_rows($dio2);
?>

<?php if ($totalRows_dio2>0) { $z=0;
				?> 


                       
 <table width="100%" cellpadding="3" cellspacing="2" border="1">             
 <tr valign="bottom">
<td width="20px" class="cellhead">&nbsp;</td>
<td class="cellhead">Matric</td>

<td class="cellhead">Name of Student</td>

<?php
$query_dio1 = "SELECT distinct code, namer, unit, status FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn  where t.programmesn=$programmesn and t.session='$session' and t.level=$level and t.semester=$semester and t.de='$de'";

$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) { $y=0; ?> 
<?php do { $y++; ?>
<td width="60px" class="cellhead">
<table width="100%" border="0" cellpadding="3" cellspacing="2">
<tr valign="top"><td><?php echo($row_dio1['code']); ?></td></tr>
<tr valign="top"><td style="border-top:2px solid #ccc;"><?php echo($row_dio1['unit']); ?>-<?php echo($row_dio1['status']); ?></td></tr>
</table>
</td>
<?php $lil[$y]=$row_dio1['code']; 
$feri=$feri . $row_dio1['code'] . " &raquo; " . $row_dio1['namer'] . "<br>"; 
?>
<?php } while ($row_dio1 = mysql_fetch_assoc($dio1)); ?>
<?php } ?>


 </tr>



<?php do { $z++; $matric=$row_dio2['matric']; ?>
<tr valign="middle">
<td class="cellbody"><?php echo($z); ?>.</td>
<td class="cellbody"><?php echo($row_dio2['matric']); ?></td>
<td class="cellbody">
<?php
$sqld="select * from students where matric='".$matric."'";
$resultd=mysql_query($sqld);
$rowd=mysql_fetch_array($resultd);
?>
<?php echo($rowd['surname']); ?>, <?php echo($rowd['firstname']); ?> <?php echo($rowd['othernames']); ?>
</td>



<?php for($b=1;$b<=$y;$b++){ ?>
<?php
$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 t.session='$session' and t.level=$level and t.semester=$semester and t.de='$de' and r.matric='$matric' and t.code='".$lil[$b]."'";

$dio1 = mysql_query($query_dio1, $csn) or die(mysql_error());
$row_dio1 = mysql_fetch_assoc($dio1);
?>
<td class="cellbody2"><?php echo($row_dio1['score']); ?></td>
<?php } ?>




</tr>
<?php } while ($row_dio2 = mysql_fetch_assoc($dio2)); ?> 
 
  </table>  

<p>&nbsp;</p>  

<div style="width:320px; float:left; line-height:300%; margin-left:50px;">
<b>Head of Department</b><br />
Signature: ______________________<br />
Name: _________________________<br />
</div>  



<div style="width:320px; float:right; line-height:300%;">
<b>Dean</b><br />
Signature: ______________________<br />
Name: _________________________<br />
</div> 
  
  
<br clear="all" />
<p>&nbsp;</p>

<div style="padding:20px 15px 20px 15px; font-weight:bold; color:#960;">
<div style="float:right">
C &raquo; Compulsory<br />
R &raquo; Required<br />
E &raquo; Elective<br />
</div>
<?php echo($feri); ?>
</div>




<div style="clear:both">

<?php
$tpcgpa=$tpcgpa/$z;
$tccgpa=$tccgpa/$z;
$tacgpa=$tacgpa/$z;

$tpcgpa=round($tpcgpa,$dp);
$tccgpa=round($tccgpa,$dp);
$tacgpa=round($tacgpa,$dp);
?>

<script>
	var data = [
		{ CGPA:"<?php echo($tpcgpa); ?>", Semester:"Previous" },
		{ CGPA:"<?php echo($tccgpa); ?>", Semester:"Current" },
		{ CGPA:"<?php echo($tacgpa); ?>", Semester:"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:"Average CGPA",
			lines: true
		},
		yAxis:{
			title:"Semester(s)",
			template:"#Semester#"
		},
		padding:{
			left:75,
			right:30
		}
	})
	barChart.parse(data,"json");

	</script>
</div>


<?php
} else {
	echo("No Registered Students!");
}
?>

<?php
} else {
	echo("No result found!");	
}
?>

<!--Content Ends Here-->
<?php include("bottomcontainer.php"); ?>
<?php //include("dtable2.php"); ?>
<?php //include("side.php"); ?>
<?php include("dtable3no.php"); ?>
<?php include("foot.php"); ?>


</body>
</html>

<?php } else {
include("dadmin.php");
}?>

<?php /*} else {
include("ddadmin.php");
}*/?>