connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
$get_data="select FUNIVCODE,FUNIVNAME,FUNIVADD1,pdf_logo_path from control";
$result=$conn->query($get_data);
if (mysqli_num_rows($result) > 0)
{
// output data of each row
while($row = mysqli_fetch_assoc($result))
{
$FUNIVCODE=$row['FUNIVCODE'];
$FUNIVNAME=$row['FUNIVNAME'];
$FUNIVADD1=$row['FUNIVADD1'];
$pdf_logo_path=$row['pdf_logo_path'];
}
}
$query = "select d.FDESCPN,d.FEXAMNAME,d.FEXAMDATE,st.FNAME,st.FPHOTOPATH,rm.FREGNO,concat(st.fcollcode,' - ',FCOLLNAME,',',ftown) as FCOLLNAME,if(FSUBSIDARY = 'T',concat(s.FSUBNAME,' **'),s.FSUBNAME) as FSUBNAME,
if(FTHUE='','-',FTHUE) as FTHUE ,
if(FPRUE='','-',FPRUE) as FPRUE ,
if(FTHVV='','-',FTHVV) as FTHVV ,
if(FPRVV='','-',FPRVV) as FPRVV,
if(FTHIA='','-',FTHIA) as FTHIA,
if(FPRIA='','-',FPRIA) as FPRIA,
if(FTHTOT='','-',FTHTOT) as FTHTOT,
if(FPRTOT='','-',FPRTOT) as FPRTOT,
if(FTHPASSMTH='','-',FTHPASSMTH) as FTHPASSMTH,
if(FPRPASSMTH='','-',FPRPASSMTH) as FPRPASSMTH,
FCREDITS,FGP,FCP,FGRADE,FSGPA,FCGPA,
FMAXMARKS,FTOTMARKS,FPREVMAX,FPREVTOT,FPERCENT,FCLASS,FMCNUMBER,FYEAR,FEXAMTYPE, FSCHEME
from vermarks rm inner join verdeg d on d.fdegree = rm.fdegree and d.fexamno = rm.fexamno
inner join verstud st on st.fregno = rm.fregno
inner join college c on st.fcollcode = c.fcollcode
inner join subject s on s.FDEGREE=rm.FDEGREE
and s.FEXAMNO=rm.FEXAMNO and s.FSUBCODE=rm.FSUBCODE
where rm.FREGNO='12PD005' and
rm.FEXAMNO='E' and FYEAR = '2017' and FEXAMTYPE = '1'
group by s.FSUBCODE";
$rst=$conn->query($query);
if (mysqli_num_rows($rst) > 0)
{
$arrydata = mysqli_fetch_assoc($rst);
$FMAXMARKS = $arrydata['FMAXMARKS'];
$FTOTMARKS = $arrydata['FTOTMARKS'];
$FPREVMAX = $arrydata['FPREVMAX'];
$FPREVTOT = $arrydata['FPREVTOT'];
$FPERCENT = $arrydata['FPERCENT'];
$FCLASS = $arrydata['FCLASS'];
$FMCNUMBER = $arrydata['FMCNUMBER'];
$FYEAR = $arrydata['FYEAR'];
$FEXAMTYPE = $arrydata['FEXAMTYPE'];
$FSCHEME = $arrydata['FSCHEME'];
$FDESCPN = $arrydata['FDESCPN'];
$FEXAMNAME = $arrydata['FEXAMNAME'];
$FEXAMDATE = $arrydata['FEXAMDATE'];
$FREGNO = $arrydata['FREGNO'];
$FNAME = $arrydata['FNAME'];
$PHOTOPATH = $arrydata['FPHOTOPATH'];
$FCOLLNAME = $arrydata['FCOLLNAME'];
$sl_no = 1;
while($row = mysqli_fetch_assoc($rst))
{
$FSUBNAME=$row['FSUBNAME'];
$FTHUE=$row['FTHUE'];
$FPRUE=$row['FPRUE'];
$FTHVV=$row['FTHVV'];
$FPRVV=$row['FPRVV'];
$FTHIA=$row['FTHIA'];
$FPRIA=$row['FPRIA'];
$FTHTOT=$row['FTHTOT'];
$FPRTOT=$row['FPRTOT'];
$FTHPASSMTH=trim($row['FTHPASSMTH']);
$FPRPASSMTH=trim($row['FPRPASSMTH']);
$FTHPASSMTH=preg_replace("/[^A-Za-z0-9+-]/","",$FTHPASSMTH);
$FPRPASSMTH=preg_replace("/[^A-Za-z0-9+-]/","",$FPRPASSMTH);
$FEXAMNO=$row[FEXAMNO];
$FEXAMNAME=$row[FEXAMNAME];
$FRESULTDATE=$row[FRESULTDATE];
$FRESULTSCHEME=$row[FRESULTSCHEME];
if($k%2==0)
$class='tbl_row1';
else
$class='tbl_row_alter1';
if($FTHUE!="-" && $FPRUE!="-")
{
$mthprue="Th. Pr.";
$uni_exam="{$FTHUE} {$FPRUE}";
$mthprue=GetTdData("Th.","Pr.");
$uni_exam=GetTdData($FTHUE,$FPRUE);
}
else if($FTHUE!="-")
{
$mthprue="Th.";
$uni_exam="{$FTHUE}";
$mthprue=GetTdData("Th.","");
$uni_exam=GetTdData($FTHUE,"");
}
else
{
$mthprue="Pr.";
$uni_exam="{$FPRUE}";
$mthprue=GetTdData("Pr.","");
$uni_exam=GetTdData($FPRUE,"");
}
if($univcode=='018')
{
$mthprue="-";
}
#########viva$########
if($FTHVV!="-" && $FPRVV!="-")
{
$viva_exam=GetTdData($FTHVV,$FPRVV);
}
else if($FTHVV!="-")
{
$viva_exam=GetTdData($FTHVV,"");
}
else
{
$viva_exam=GetTdData($FPRVV,"");
}
#########viva$########
#########IA########
if($FTHIA!="-" && $FPRIA!="-")
{
$ia_exam=GetTdData($FTHIA,$FPRIA);
}
else if($FTHIA!="-")
{
$ia_exam=GetTdData($FTHIA,"");
}
else
{
$ia_exam=GetTdData($FPRIA,"");
}
#########IA$########
#########TOTAl########
if($FTHTOT!="-" && $FPRTOT!="-")
{
$total=GetTdData($FTHTOT,$FPRTOT);
}
else if($FTHTOT!="-")
{
$total=GetTdData($FTHTOT,"");
}
else
{
$total=GetTdData($FPRTOT,"");
}
#########TOTAl$########
#########Remarks########
//echo strtolower($FTHPASSMTH).'--'.strtolower($FPRPASSMTH);
if($univcode=='018')
{
$FPRPASSMTH="";
}
$pass_color="green;";
if(strtolower($FTHPASSMTH)==strtolower($FPRPASSMTH))
{
$remarks= GetTdData1($FTHPASSMTH,"");
}
else if(strtolower($FTHPASSMTH)=="pass" && strtolower($FPRPASSMTH)=="pass")
{
$remarks= GetTdData1("Pass","");
}
else if(strtolower($FTHPASSMTH)=="fail" && strtolower($FPRPASSMTH)=="fail")
{
$pass_color="red;";
$remarks=GetTdData1("Fail","");
}
else if(strtolower($FTHPASSMTH)!="-" && strtolower($FPRPASSMTH)=="-")
{
$remarks= GetTdData1($FTHPASSMTH,"");
}
else if(strtolower($FTHPASSMTH)=="-" && strtolower($FPRPASSMTH)!="-")
{
$remarks= GetTdData1($FPRPASSMTH,"");
}
else
{
$remarks=GetTdData1($FTHPASSMTH,$FPRPASSMTH);
}
$html.="";
$html.="| {$sl_no} | ";
$html.="{$FSUBNAME} | ";
$html.="{$mthprue} | ";
$html.="{$uni_exam} | ";
$html.="{$viva_exam} | ";
$html.="{$ia_exam} | ";
$html.="{$total} | ";
$html.="{$remarks} | ";
$html.="
";
$sl_no++;
}
}
function GetTdData($div1,$div2)
{
$html="";
if(empty($div2))
$html="{$div1}";
else
$html="{$div1}
{$div2}
";
return $html;
}
function GetTdData1($div1,$div2)
{
$color1="color:green;";
$color2="color:green;";
if(trim(strtolower($div1)=="fail"))
$color1="color:red;";
if(trim(strtolower($div2)=="fail"))
$color2="color:red;";
$html="";
if(empty($div2))
$html="{$div1}
";
else
$html="{$div1}
{$div2}
";
return $html;
}
?>
| Sl. No. | Subject Name |
Th Pr |
Univ Exam |
Credits |
Credit Point |
Grade Point |
Grade |
Viva |
I.A. |
Total |
Remarks |