Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
abcolleges.php	2.25 KB	-rwxr-xr-x
changeStudyCentre.php	3.84 KB	-rwxr-xr-x
connection.php	680 B	-rwxr-xr-x
createUser.php	1.1 KB	-rwxr-xr-x
dashboard.php	2.11 KB	-rwxr-xr-x
database.php	294 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	280 B	-rwxr-xr-x
getapprapps.php	2.56 KB	-rwxr-xr-x
getassignapps.php	2.05 KB	-rwxr-xr-x
getautofill.php	738 B	-rwxr-xr-x
getgapstudent.php	1.92 KB	-rwxr-xr-x
getgapstudent_22062018.php	1.89 KB	-rwxr-xr-x
login.php	326 B	-rwxr-xr-x
logout.php	155 B	-rwxr-xr-x
pgRedirect.php	2.73 KB	-rwxr-xr-x
profile.php	629 B	-rwxr-xr-x
report_admission_ticket.php	46.94 KB	-rwxr-xr-x
results.php	640 B	-rwxr-xr-x
saveapps.php	541 B	-rwxr-xr-x
savestuddet.php	1.58 KB	-rwxr-xr-x
savestuddet_23072018.php	1.58 KB	-rwxr-xr-x
studdet.php	2.85 KB	-rwxr-xr-x

Code Editor : getgapstudent_22062018.php

<?php

include ("database.php");

$strAction =$_POST['pAction'];
//check weather user exist
if($strAction == 'display')
{
	$strRegno = trim($_POST['pRegno']);
	
	$strCheckQuery = "select fregno, fcollcode, fdegree, fexamno 
	from regcandsum where fregno = '{$strRegno}'";

$result = mysqli_query($conn,$strCheckQuery);
	$count  = mysqli_num_rows($result);
	
	if($count > 0)
	{
		$response['status'] = "failure";
		$response['msg'] = "Register number already moved";
		echo json_encode($response);
		die();
	}

$strDispQuery = "select s.fname, concat('[',r.fdegree ,'] ', d.fdescpn) as degree, 
	concat(r.fexamno,' - ', d.fexamname) as examno,
	concat('[', c.fcollcode,'] ', c.fcollname,', ',c.ftown) as college
	from student s inner join 
	candsum r on s.fregno = r.fregno
	inner join college c on s.fcollcode = c.fcollcode
    inner join degree d on d.fdegree = r.fdegree and d.fexamno = r.fexamno
	where s.fregno = '{$strRegno}'";

$result = mysqli_query($conn,$strDispQuery);
	$count  = mysqli_num_rows($result);
	
	if($count > 0)
	{
		$row = mysqli_fetch_assoc($result);
		$response['status'] = "success";
		$response['data'] = $row;
		echo json_encode($response);
	}
	else
	{
		$response['status'] = "error";
		$response['msg'] = "Invalid Register Number";
		echo json_encode($response);
	}
}
else if($strAction == 'save')
{
	$regno =$_POST['regno'];
	$fee =$_POST['fee'];
	$year =$_POST['year'];
	$query = "insert into regcandsum select *,'{$fee}'from candsum where fregno ='{$regno}'";
	$result = mysqli_query($conn,$query);
	
	$query = "insert into regcanddet
	select * from canddet where fregno ='{$regno}';";
	$result = mysqli_query($conn,$query);
	$count2  = mysqli_num_rows($result);

if($result)
	{
		$response['status'] = "success";
		$response['msg'] = "";
		echo json_encode($response);
	}
	else
	{
		$response['status'] = "error";
		$response['msg'] = "Invalid Register Number";
		echo json_encode($response);
	}

}

${this.title}

Code Editor : getgapstudent_22062018.php