ACADEMIC MANAGEMENT SYSTEM

[proxy]

Hello wadau na maprogrammer wote mlioko humu naomba msadawenu katika hili,Kwa sasa nipo kwenye final Stage ya kuimalizia System itakayoitwa Academic Management System ,hii system nimebase zaidi katika level za chuo kwa sababu wanamfumo wa GPA pamoja na Acreditation na Best performance kwa mwanafunzi atakayefanya vizuri,System inauwezo wa kutrack progress ya mwanafunzi na kujua progress yake,Kama inavyoonesha hapo chini.

Kwa baadhi ya codes hizi:-
<?php
require('fpdf.php');
include('connect.php');

class PDF extends FPDF
{
function Footer()
{
$query_page=mysql_query("SELECT `dimensional` from provinal_lines where line_no='page'");
list($page)=mysql_fetch_array($query_page);
if($this->PageNo()==$page)
{
$tday=date("Y-m-j");
//Go to 2 cm from bottom
$this->SetY(-20);
//$this->Image('corporate.png',80,null,0,0);
$this->SetTextColor(black);
$this->SetFont('Arial','',9);
$this->Cell(15);
$this->SetTextColor(black);
$this->SetFont('Arial','I',6);
$this->Cell(10,10,$tday,0,0,'R');
}
}
}

$pdf=new PDF('P','mm','A4');
$pdf->AddPage();
$pdf->rect(15,15, 184,270);
$pdf->ln(60);
$regNo = trim($_GET['regNo']);
$year1=$_GET['year1'];
$year2=$_GET['year2'];
$year3=$_GET['year3'];
$year4=$_GET['year4'];

$sql="SELECT p.*,r.programDetails,r.duration FROM tbl_ems_personal_details p INNER JOIN tbl_ems_program_detail r ON p.programCode = r.programCode where regNo='$regNo'";
$sql1=mysql_query($sql);
$result1=mysql_fetch_assoc($sql1);

$regNo=$result1['regNo'];
$query_row=mysql_query("SELECT `dimensional` from provinal_lines where line_no='row_size'");
list($row_size)=mysql_fetch_array($query_row);

$pdf->Cell(11);
$fullName=ucwords(strtolower($result1['firstName']))." ".strtoupper($result1['otherName'])." ".ucwords(strtolower($result1['surName']));
$pdf->SetFont('Arial','',8);
$pdf->Cell(100,$row_size,'Name: '. $fullName,1,0,'L');
$pdf->Cell(70,$row_size, 'RegNo:'.$result1[regNo],1,0,'L');
$pdf->ln($row_size);
$pdf->Cell(11);
$pdf->SetFont('Arial','',8);
$pdf->Cell(170,$row_size,'Programme: '.$result1[programDetails],1,0,'L');
$pdf->ln(6);
$pdf->Cell(11);
$regNo = trim($_GET['regNo']);
$qrl_sup="SELECT courseCode,remarks from tbl_ems_examination_results where regNo='$regNo' and remarks<>'P' ORDER BY Semister,examId ASC";
$result_sup=mysql_query($qrl_sup);
//echo $qrl_sup;
$max_row=mysql_num_rows($result_sup);
if($max_row<>0)
{
$pdf->Cell(170,6,'',1,0 ,'l');
$pdf->ln(1);
$pdf->Cell(11);
$pdf->Cell(20,$row_size,'Remarks:',2,0 ,'l');
$i=1;
while(list($courseCode,$remarks)=mysql_fetch_array($result_sup))
{
if($i==$max_row)
{
$pdf->Cell(30,$row_size, $courseCode.'('.$remarks.')',2,0,'L');
}else
{
$pdf->Cell(20,$row_size, $courseCode.'('.$remarks.'),',2,0,'L');
}
$i++;
}
//$pdf->ln(11);
}
//check programme duration
$pduration=$result1['duration'];
if((isset($year3)) or (isset($year4)))
{
$check=mysql_query("SELECT Semister,remarks from tbl_ems_examination_results where regNo = '$regNo' and Semister='2' and yearOfStudy='$pduration'");
list($Semister,$remarks)=mysql_fetch_array($check);
}
//echo $Semister;
//exit();
if(($pduration==4) and (isset($year4)))
{
$setP=2;
}elseif(($pduration==3) and (isset($year3)))
{
$setPy=2;
}else{}
if(($setP==2) or ($setPy==2))
{
if(($Semister==2) and ($remarks=='P'))
{
$gpa="SELECT truncate(sum(point)/((count(courseCode))),2) as gpa FROM tbl_ems_examination_results where regNo = '$regNo' and courseCode<>'LG 211'and courseCode<>'LG 221' and courseCode<>'LG 311' and courseCode<>'LG 321' and courseCode<>'LG 311/321' and remarks<>'W'";
$gpa1=mysql_query($gpa);
$gpa2=mysql_fetch_assoc($gpa1);
$gpa3 = $gpa2[gpa];

switch ($gpa3)
{
case $gpa3 >=4.50:
$class = 'FIRST';
break;
case $gpa3 >=3.50:
$class= 'UPPER SECOND';

break;
case $gpa3 >=2.60:
$class = 'LOWER SECOND';
break;
case $gpa3 >=2.00:
$class = 'PASS';
break;

default:
$class = 'FAILED';

}
.........

Kilichonileta hapa ni kwamba nahitaji kubadilisha kwenye hiyo column ya points nahitaji kuzidisplay as a float au double ,lakini nimejaribu kuiport kupitia VB Excel(Macro) ,data zinakubali vizuri lakini points haziingii kama float na hata kama zikikubali ila total na GPA haziwi aligned vizuri kwenye cell ya hiyo attribute

Kama kuna yeyote anauelewa namna ya kuzipoint data kutoka kwenye Integer kwenye Float au Double tuwasiliane please.