Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
applyrvrt.php	2.23 KB	-rwxr-xr-x
attendance.php	3.22 KB	-rwxr-xr-x
caccesscontext.php	1.25 KB	-rwxr-xr-x
cappcontext.php	4.41 KB	-rwxr-xr-x
chngMobNum.php	3.78 KB	-rwxr-xr-x
commandb.php	505 B	-rwxr-xr-x
constants.php	818 B	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
createUser.php	5.78 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
database.php	595 B	-rwxr-xr-x
examapp.php	32.84 KB	-rwxr-xr-x
examapp_iframe.php	1.1 KB	-rwxr-xr-x
examtimetable.php	3.26 KB	-rwxr-xr-x
exceptionhandler.php	236 B	-rwxr-xr-x
getMenus.php	1.96 KB	-rwxr-xr-x
getPaymentTypes.php	945 B	-rwxr-xr-x
hallticket.php	5.19 KB	-rwxr-xr-x
helpDesk.php	1.22 KB	-rwxr-xr-x
iamarks.php	3.47 KB	-rwxr-xr-x
index.php	418 B	-rwxr-xr-x
json.php	33.2 KB	-rwxr-xr-x
jwt.php	13.16 KB	-rwxr-xr-x
login.php	748 B	-rwxr-xr-x
logout.php	212 B	-rwxr-xr-x
mregistry.php	1.29 KB	-rwxr-xr-x
notification.php	929 B	-rwxr-xr-x
oldQPDownload.php	2.73 KB	-rwxr-xr-x
onlineApp.php	469 B	-rwxr-xr-x
postExamAppDet.php	832 B	-rwxr-xr-x
practicaltimetable.php	3.38 KB	-rwxr-xr-x
printResult.php	31.21 KB	-rwxr-xr-x
profile.php	2.85 KB	-rwxr-xr-x
results.php	25.28 KB	-rwxr-xr-x
rvappstatus.php	2.04 KB	-rwxr-xr-x
rvrtapp.php	14.73 KB	-rwxr-xr-x
saveansbookno.php	1.07 KB	-rwxr-xr-x
sendGridMail.php	1.29 KB	-rwxr-xr-x
submitquery.php	2.49 KB	-rwxr-xr-x
uRevaluation.php	26.38 KB	-rwxr-xr-x
upload_file.php	1.52 KB	-rwxr-xr-x
yourAppsRVRT.php	5.81 KB	-rwxr-xr-x
yourExmAppList.php	1.26 KB	-rwxr-xr-x

Code Editor : applyrvrt.php

<?php
	
	include 'database.php';

include("commandb.php");

//session_start();
	$UNIVCODE  = $_SESSION['UNIVCODE'];

/*$query = "INSERT INTO menulog(funivcode,fdate,fresults)
	VALUES('{$UNIVCODE}',date_format(now(),'%Y-%m-%d'),1)
	ON DUPLICATE KEY UPDATE fresults = if(ifnull(fresults,'') = '', 1,fresults+1)";
	$results = mysqli_query($conndb,$query);*/
	
	$strUserLogQuery = "insert into userlog 
	(funivcode, fregno, fmobileno, fipadd, FREASONCODE, FDESCPN)
	values ('{$_SESSION['UNIVCODE']}', '{$_SESSION['REGNO']}', 
	'{$_SESSION['MOBILE']}', '{$_SERVER['REMOTE_ADDR']}', 
	'REMN', 'REMN - {$_SESSION['REGNO']} Viewed Results')";
	$result = mysqli_query($conndb,$strUserLogQuery);

$id = $_POST['id'];
	$reg_no = $_SESSION['REGNO'];
	$folder = $_SESSION['FOLDER'];
	
	/*$sql = "SELECT re.fexamno,dg.fexamname FROM res_fee re
	inner join degree dg on re.fdegree = dg.fdegree and re.fexamno = dg.fexamno
	where re.fregno = '{$reg_no}' order by fexamno"; */

$query = "select fregno, fdegree, fcaste, 
	if(fenroll='', fregno, ifnull(fenroll,fregno))  as enroll 
	from student where fregno = '{$reg_no}'"; 
	$result = mysqli_query($conn,$query);
	while ($studentrow = $result->fetch_assoc()) 
	{
		$fcaste = $studentrow['fcaste'];
		$fenroll = $studentrow['enroll'];
		
	}

if($_SESSION['UNIVCODE'] == '023')
		$cnd = " re.fregno in(select distinct fregno from student 
		where (fregno = '{$reg_no}' or ifnull(fenroll,'') = '{$fenroll}'))";
	else
		$cnd = "re.fregno = '{$reg_no}' ";

$sql = "SELECT re.fexamno,dg.fexamname,re.fregno,re.fdegree FROM res_fee re
		inner join degree dg on re.fdegree = dg.fdegree and re.fexamno = dg.fexamno
		where {$cnd}
		order by fexamno";

$result = mysqli_query($conn,$sql);
	$i=0;

while ($row1 = $result->fetch_assoc()) 
	{
		$row[$i] = $row1;
		$i++;
	}
	//var_dump(count($array));

if(mysqli_num_rows($result) > 0)
	{
		//$row['sem'] = $array;
		//$row['fregno'] = $reg_no;
		$row['folder'] = $folder;
		$row['resdet'] = $row;
		$row['fcaste'] = $fcaste;
		$row['UNIVCODE'] = $_SESSION['UNIVCODE'];
		$row['status'] = 'success';
		mysqli_close($conn);
		mysqli_close($conndb);
		echo json_encode($row);
	}
	else
	{
		$data = array("status"=>"failure");
		mysqli_close($conn);
		mysqli_close($conndb);
		echo json_encode($data);
	}
?>

${this.title}

Code Editor : applyrvrt.php