Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
connection.php	680 B	-rwxr-xr-x
createUser.php	1.1 KB	-rwxr-xr-x
dashboard.php	2.12 KB	-rwxr-xr-x
database.php	296 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	280 B	-rwxr-xr-x
getapps.php	832 B	-rwxr-xr-x
getautofill.php	738 B	-rwxr-xr-x
login.php	326 B	-rwxr-xr-x
logout.php	155 B	-rwxr-xr-x
profile.php	629 B	-rwxr-xr-x
results.php	640 B	-rwxr-xr-x
saveapps.php	541 B	-rwxr-xr-x
savestuddet.php	569 B	-rwxr-xr-x
studdet.php	2.79 KB	-rwxr-xr-x

Code Editor : studdet.php

<?php
	include ("database.php");
	$appno = $_POST['appno'];
	
	$user = $_SESSION['USERTYPE'];

$query = "SELECT  DISTINCT studadm.FNAME as name, studadm.FFATNAME,ifnull(studadm.fregno,'') as fregno, '{$user}' as user,'{$appno}' as fappno,
					studadm.FFAT_OCC, studadm.FCASTE, if(studadm.FSEX = 'M','Male','Female') as  FSEX,
					ifnull(studadm.FHANDICAP,'None') as FHANDICAP,studadm.FNATIONAL,
					studadm.FPAYMENTREMARKS,
					studadm.fphotopath,studadm.fsignpath,studadm.FPAYMENTDATE,
					ifnull(fapprstatus,'') as fapprstatus,
					ifnull(fremarks,'') as fremarks,
					date_format(studadm.FDOB,'%d/%m/%Y') as fdob, 
					studadm.FAADHARNO,
					ifnull(studadm.FCURRADD1,'') as FCURRADD1,
					ifnull(studadm.FCURRADD2,'') as FCURRADD2,
					ifnull(studadm.FCURRADD3,'') as FCURRADD3,
					ifnull(studadm.FCURDISTRICT,'') as FCURDISTRICT,
					ifnull(studadm.FCURSTATE,'')    as FCURSTATE, 
					ifnull(studadm.FCURPINCODE,'')  as FCURPINCODE, 
					ifnull(studadm.FPERMADD1,'')    as FPERMADD1,
					ifnull(studadm.FPERMADD2,'')    as FPERMADD2,
					ifnull(studadm.FPERMADD3,'')    as FPERMADD3,
					ifnull(studadm.FPERDISTRICT,'') as FPERDISTRICT ,
					ifnull(studadm.FPERSTATE,'')    as FPERSTATE, 
					ifnull(studadm.FPERPINCODE,'')  as FPERPINCODE,studadm.FCONTACT_NO, 
					studadm.FEMAIL,ifnull(studadm.FLANDLINE,' - ') as FLANDLINE,
					studadm.FINCOME, studadm.FDEGREE, studadm.FENGLISH,  
					studadm.FCOMBCODE, studadm.FBASICQAL,studadm.FCENSTATE, 
					studadm.FCENDISTRICT, studadm.FCOLLCODE, 
					studadm.FPREVREGNO,studadm.FPREVCOMB, studadm.FPREVCOLLEGE,
					studadm.FPREVELECTIVE, studadm.FPASSMTHYEAR,
					GROUP_CONCAT(distinct subject.FSUBSHORT,'->',
					subject.FSUBNAME ORDER BY subject.FSUBCODE 
					SEPARATOR '~') AS subjdet,studadm.FPAYMENTTYPE,studadm.FTOTFEE,
					options.FEXAMNO,degree.fdescpn as fdegname,degree.fexamname as fexamname,
					CONCAT(college.FCOLLNAME,', ',college.FTOWN) as FCOLLNAME
					FROM studadm ,options,subject,college,degree,category
					WHERE subject.FSUBCODE = options.FSUBCODE 
					AND subject.FDEGREE = options.FDEGREE
					AND options.FDEGREE = degree.FDEGREE 
					AND subject.FDEGREE = degree.FDEGREE
					and studadm.fexamno = degree.fexamno
					AND college.FCOLLCODE = studadm.FCOLLCODE 
					AND college.FCOLLCODE = options.FCOLLCODE 
					AND options.FCOLLCODE=studadm.FCOLLCODE 
					AND studadm.FEXAMNO= options.FEXAMNO 
					AND studadm.FDEGREE = options.FDEGREE 
					AND studadm.FSLNO = options.FSLNO 
					AND category.fcategory = studadm.fcaste
					AND options.FAPPNO = '{$appno}' 
					AND ifnull(studadm.fdeleted,'') <> 'T'
					AND studadm.FAPPNO = '{$appno}'
					GROUP BY options.FSLNO";

$result = mysqli_query($conn,$query);

//$results['fdegname'].' '.$results['fexamname']

$app = mysqli_fetch_array($result,MYSQLI_ASSOC);

echo json_encode($app);

${this.title}

Code Editor : studdet.php