Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
includes	[ DIR ]	drwxr-xr-x
getStudentProfileAPI.php	1.46 KB	-rwxr-xr-x
jscript.js	11.9 KB	-rwxr-xr-x

Code Editor : getStudentProfileAPI.php

<?php

require('includes/dbconnect.php'); //include database connection
//require('includes/functions.php'); //include functions
$appno = str_replace(chr(34),"",stripslashes(nl2br($_GET['appno'])));
$apiKey = str_replace(chr(34),"",stripslashes(nl2br($_GET['apiKey'])));
//$deviceDate = str_replace(chr(34),"",stripslashes(nl2br($_GET['deviceDate'])));
//$instCode = str_replace(chr(34),"",stripslashes(nl2br($_GET['instCode'])));
//$branchCode = str_replace(chr(34),"",stripslashes(nl2br($_GET['branchCode'])));
//$userName = str_replace(chr(34),"",stripslashes(nl2br($_GET['userName'])));

$studQuery = "SELECT FNAME,FROLLNO,FAPPNO,FAMOUNT FROM studadm 
				where FAPPNO='{$appno}'";

$studResult =  $conn->query($studQuery);

if(mysqli_num_rows($studResult) != 1)
	{
		$statusCode = '0';
		$statusMessage = "INVALID admission number.. Please try again";
		
		$jsonLoginArray = array("statusCode" => $statusCode, "statusMessage" => $statusMessage);
		$returnString = json_encode($jsonLoginArray);
		print $returnString;
		exit;
	}
	else 
	{	
		$row1 = mysqli_fetch_array($studResult,MYSQLI_ASSOC);

$returnArray = array(
		  "studentName" => $row1['FNAME'],       
		  "regNum" =>  $row1['FROLLNO'],
		  "appNo" =>  $row1['FAPPNO'],   
		  "amount" =>  $row1['FAMOUNT']
		);

$jsonLoginArray = array("statusCode" => "1", "statusMessage" => "Success", "studentDetails" => $returnArray);
		$returnString = json_encode($jsonLoginArray);
		print $returnString;

}
  ?>

${this.title}

Code Editor : getStudentProfileAPI.php