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

<?php

include ("database.php");

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

if($strAction == 'display')
{
	$strFromcoll = trim($_POST['pFromcoll']);
	$strTocoll = trim($_POST['pTocoll']);
	$boolType = trim($_POST['pType']);

if($boolType == 'T')
	{
		$strBlockCondition = "and fadmallow = 'T'";
	}
	else if($boolType == 'F')
	{
		$strBlockCondition = "and fadmallow is null";
	}
	else
	{
		$strBlockCondition = "";
	}
	
	$strDispCentre = "select fcollcode, fcollname, ftown, 
	ifnull(fadmallow,'F') as permission, fcollcode
	from college
	where fcollcode like '5%'
	and fcollcode between '{$strFromcoll}' and '{$strTocoll}' {$strBlockCondition}";
	$result = mysqli_query($conn,$strDispCentre);
	$i=0;
	$count = mysqli_num_rows($result);
	if($count > 0)
	{
		while($rowCollege = mysqli_fetch_array($result,MYSQLI_NUM)) 
		{
			if($rowCollege[3] == 'T')
				$rowCollege[3] = 'ALLOWED';
			else
				$rowCollege[3] = 'BLOCKED';
			$rowsCollege[$i] = $rowCollege;
			$i++;
		}
		$row['colleges'] = $rowsCollege;
		$row['status'] = 'success';
	}
	else
	{
		$row['msg'] = "No collges Found";
		$row['status'] = 'error';
	}
	echo json_encode($row);
}
else if($strAction == 'save')
{
	$strcolls = trim($_POST['pColls']);
	$rgColls = explode(',',$strcolls);
	if(count($rgColls)>1)
		$strcolls = implode("','",$rgColls);

$strPerm = trim($_POST['pPerm']);
	if($strPerm == 'allow')
	{
		$updateCollegeQuery = "update college set fadmallow = 'T' 
		where fcollcode in ('{$strcolls}')";
		//var_dump($updateCollegeQuery);
		$result = mysqli_query($conn,$updateCollegeQuery);

if($result)
		{
			$response['status'] = "success";
			$response['msg'] = "Admission Allowed for centres";
			echo json_encode($response);
		}
		else
		{
			$response['status'] = "error";
			$response['msg'] = "Error while updating";
			echo json_encode($response);
		}
	}
	else if($strPerm == 'block')
	{
		$updateCollegeQuery = "update college set fadmallow = null 
		where fcollcode in ('{$strcolls}')";
		$result = mysqli_query($conn,$updateCollegeQuery);

if($result)
		{
			$response['status'] = "success";
			$response['msg'] = "Admission Blocked for centres";
			echo json_encode($response);
		}
		else
		{
			$response['status'] = "error";
			$response['msg'] = "Error while updating";
			echo json_encode($response);
		}
	}
}

${this.title}

Code Editor : abcolleges.php