Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
connection.php	680 B	-rwxr-xr-x
createUser.php	1.1 KB	-rwxr-xr-x
dashboard.php	2.12 KB	-rwxr-xr-x
database.php	296 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	280 B	-rwxr-xr-x
getapps.php	832 B	-rwxr-xr-x
getautofill.php	738 B	-rwxr-xr-x
login.php	326 B	-rwxr-xr-x
logout.php	155 B	-rwxr-xr-x
profile.php	629 B	-rwxr-xr-x
results.php	640 B	-rwxr-xr-x
saveapps.php	541 B	-rwxr-xr-x
savestuddet.php	569 B	-rwxr-xr-x
studdet.php	2.79 KB	-rwxr-xr-x

Code Editor : examapp.php

<?php

include ("database.php");

$query = "SELECT s.fname as StudentName,s.fdegree,s.fcollcode,s.fexamno, d.fdescpn Degree,c.fcollname College,s.fcaste as Category,s.fregno RegNo from student s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno inner join college c on s.fcollcode = c.fcollcode where fregno = '{$_SESSION[REGNO]}'";

$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);
if($count > 0)
{
	$row = mysqli_fetch_assoc($result);
	$sub_summary_query = "select distinct cd.fexamno, dg.fexamname, dg.ftotsub, cs.ffreshexam from canddet cd inner join degree dg on cd.fdegree = dg.fdegree and cd.fexamno = dg.fexamno inner join candsum cs on cs.fdegree = cd.fdegree and cs.fcollcode = cd.fcollcode and cs.fregno = cd.fregno where cd.FREGNO='{$_SESSION[REGNO]}' order by cd.fexamno";
	$result = mysqli_query($conn,$sub_summary_query);
	$count = mysqli_num_rows($result);
	$i = 0;
	while($sem = mysqli_fetch_assoc($result)){
		$sub_sum[$i] = $sem;
		$row['subject_'.$sem['fexamno']] =  getSubjectDetl($row['fdegree'],$row['fcollcode'],$sem['fexamno'],$conn,$sem['ftotsub'],$row['Category'], $sem['ffreshexam']);
		$i++;
	}
	$row['sub_summary'] = $sub_sum;
	$row['status'] = 'success';
	echo json_encode($row);
}
else
{
	$data = array("status"=>"failure");
	echo json_encode($data);
}

}

${this.title}

Code Editor : examapp.php