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 : changeStudyCentre.php

<?php

include ("database.php");

$strAction = trim($_POST['pAction']);

//check weather user exist
if($strAction == 'display')
{
	$strRegno = trim($_POST['pRegno']);
	if(strlen($strRegno) == 8)
	{
		$strQuery = "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 
		regcandsum 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}'";
	}
	else
	{
		$strQuery = "select s.fname, concat('[',s.fdegree ,'] ', d.fdescpn) as degree, 
		concat(s.fexamno,' - ', d.fexamname) as examno,
		concat('[', c.fcollcode,'] ', c.fcollname,', ',c.ftown) as college
		from studadm s inner join 
		college c on s.fcollcode = c.fcollcode
	    inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
		where s.fappno =  '{$strRegno}'";
	}
	//AD546302
	$rgResult = mysqli_query($conn,$strQuery);
	$count  = mysqli_num_rows($rgResult);
	$rgRow = mysqli_fetch_assoc($rgResult);
	if($count > 0)
	{
		$response['status'] = "success";
		$response['data'] = $rgRow;

$collcode_query = "select distinct concat(cl.fcollcode,'-',fcollname) as college 
		from studadm sa inner join college cl on sa.fcollcode = cl.fcollcode";
		$result = mysqli_query($conn,$collcode_query);
		$i=0;
		while($coll = mysqli_fetch_array($result,MYSQLI_NUM)) 
		{
			$college[$i] = $coll[0];
			$i++;
		}
		$response['college'] = $college;
		echo json_encode($response);
	}
	else
	{
		$response['status'] = "error";
		$response['msg'] = "Invalid Register Number";
		echo json_encode($response);
	}
}
else if($strAction == 'change')
{
	$strCollcode = trim($_POST['pCollcode']);
	$strRegno = trim($_POST['pRegno']);
	$strCollExistQuery = "select * from college where fcollcode = '{$strCollcode}'";
	$result1 = mysqli_query($conn,$strCollExistQuery);
	if($result1)
	{
		if(strlen($strRegno) == 8)
		{
			$updateStudentQuery = "update student set fcollcode = '{$strCollcode}' 
			where fregno = '{$strRegno}'";
			$result = mysqli_query($conn,$updateStudentQuery);
			
			$updateRegcandsumQuery = "update regcandsum set fcollcode = '{$strCollcode}' 
			where fregno = '{$strRegno}'";
			$result = mysqli_query($conn,$updateRegcandsumQuery);
			$updateRegcanddetQuery = "update regcanddet set fcollcode = '{$strCollcode}' 
			where fregno = '{$strRegno}'";
			$result = mysqli_query($conn,$updateRegcanddetQuery);
			
			/*$updateStudadmQuery = "update studadm set fcollcode = '{$strCollcode}' 
			where fregno = '{$strRegno}'";
			$result = mysqli_query($conn,$updateStudadmQuery);
			$updateOptionsQuery = "update options set fcollcode = '{$strCollcode}' 
			where fregno = '{$strRegno}'";
			$result = mysqli_query($conn,$updateOptionsQuery);*/
		}
		else
		{
			$query = "SELECT MAX(fslno)+1 AS fslno FROM studadm 
			WHERE fcollcode = '{$strCollcode}'";
			$result1 = mysqli_query($conn,$query);
			$rgRow = mysqli_fetch_assoc($result1);
			$fslno = $rgRow['fslno'];
			$updateStudadmQuery = "update studadm set fslno = '{$fslno}', 
			fcollcode = '{$strCollcode}' 
			where fappno = '{$strRegno}'";
			$result = mysqli_query($conn,$updateStudadmQuery);
			if($result)
			{
				$updateOptionsQuery = "update options set fslno = '{$fslno}', 
				fcollcode = '{$strCollcode}' 
				where fappno = '{$strRegno}'";
				$result = mysqli_query($conn,$updateOptionsQuery);
			}
		}

if($result)
		{
			$response['status'] = "success";
			$response['msg'] = "Study Centre changed";
			echo json_encode($response);
		}
		else
		{
			$response['status'] = "error";
			$response['msg'] = "Error while updating";
			echo json_encode($response);
		}
	}
	else
	{
		$response['status'] = "error";
		$response['msg'] = "Invalid college / centre code";
		echo json_encode($response);
	}
}

${this.title}

Code Editor : changeStudyCentre.php