Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Tickets.php	7.03 KB	-rw-rw-r--
attendance.php	3.07 KB	-rwxr-xr-x
commandb.php	412 B	-rwxr-xr-x
database.php	476 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	1.1 KB	-rwxr-xr-x
examtimetable.php	2.85 KB	-rwxr-xr-x
hallticket.php	3.1 KB	-rwxr-xr-x
helpDesk.php	1.12 KB	-rwxr-xr-x
iamarks.php	3.12 KB	-rwxr-xr-x
login.php	703 B	-rwxr-xr-x
logout.php	212 B	-rwxr-xr-x
practicaltimetable.php	3.21 KB	-rwxr-xr-x
profile.php	2.19 KB	-rwxr-xr-x
results.php	1.58 KB	-rwxr-xr-x

Code Editor : profile.php

<?php

include ("database.php");

$query = "select distinct s.fname, s.ffatname, s.fmotname, s.fdegree, s.fcollcode,
d.fdescpn as degree, d.fexamname, concat(d.fexamdate,' Examination') as fexamdate,
concat(c.fcollname,', ',c.ftown, ' [', c.fcollcode, ']') as college,
s.fphotopath,
if(ifnull(fcaste,'') = '', 'GM',fcaste) as category, 
if(ifnull(fconstype,'') = '', 'Normal Fee', fconstype) as feetype,
ifnull(fexamappblk,0) as examblk
from student s 
inner join degree d 
on s.fdegree = d.fdegree
inner join college c 
on s.fcollcode = c.fcollcode 
where s.fregno = '{$_SESSION['REGNO']}'";

//var_dump($query);
$result = mysqli_query($conn,$query);
$count = mysqli_num_rows($result);
if($count > 0)
{
	$row = mysqli_fetch_assoc($result);
	//
	$path = "/home/logisys32/public_html/oasis/".$_SESSION['FOLDER'].'/'.$row['fphotopath'];

if(file_exists($path))
		$row['photopath'] = 'http://oasis.logisys.org/'.$_SESSION['FOLDER'].'/'.$row['fphotopath'];
	else
		$row['photopath'] = 'http://studentportal.universitysolutions.in/'.$_SESSION['FOLDER'].'/'.$row['fphotopath'];
	
	$_SESSION['CATEGORY'] = $row['category'];
	$_SESSION['FEETYPE'] = $row['feetype'];
	$_SESSION['EXAMBLK'] = $row['examblk'];
	$_SESSION['DEGREE'] = $row['fdegree'];
	$_SESSION['COLLCODE'] = $row['fcollcode'];
	$row['strRegno'] = $_SESSION['REGNO'];
	$row['strMobile'] = $_SESSION['MOBILE'];
	$row['strEmail'] = $_SESSION['EMAIL'];
	$row['strParentMob'] = $_SESSION['PARENTMOB'];
	$row['strSemester'] = $row['fexamname'];
	$row['strExamdate'] = $row['fexamdate'];

$get_subs_query = "select distinct cd.fsubcode, su.fsubname, 
	de.fexamname, cd.fexamno 
	from canddet cd
	inner join  subject su
	on cd.fdegree = su.fdegree
	and cd.fexamno = su.fexamno
	and cd.fsubcode = su.fsubcode
	inner join degree de
	on cd.fdegree = de.fdegree
	and cd.fexamno = de.fexamno 
	where cd.fregno = '{$_SESSION['REGNO']}'
	and ifnull(cd.fpassmth,'') = ''
	order by fsubcode";
	$sub_result = mysqli_query($conn,$get_subs_query);
	$i = 0;
	while($row1 = mysqli_fetch_assoc($sub_result))
	{
		$subject[$i] = $row1;
		$i++;
	}
	$row['subject'] = $subject;
	$row['status'] = 'success';
	echo json_encode($row);
}
else
{
	$data = array("status"=>"failure");
	echo json_encode($data);
}

${this.title}

Code Editor : profile.php