Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
candidate-entry.php	42.39 KB	-rwxr-xr-x
display_details_in_grid.php	98.69 KB	-rwxr-xr-x
getdata.php	19.94 KB	-rwxr-xr-x
mregistry.php	50.72 KB	-rwxr-xr-x

Code Editor : getdata.php

<?php
function getCollegeNames($aobj_context)
{
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $coll_code = $aobj_context->mobj_data["coll_code"]; 	
    $qry="select FCOLLCODE,concat(FCOLLNAME,', ',FTOWN) as FCOLLNAME from college where FCOLLCODE='{$coll_code}'";
    $lobj_rs = $aobj_context->mobj_db->GetRow($qry);     
	
	if($lobj_rs)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_rs,-1,"Failure");
    return;
}

}
 function getExamNo($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$exam_no=trim($aobj_context->mobj_data["ExamNo"]);
	$degree=trim($aobj_context->mobj_data["degree"]);
	$get_name_by_degree_code="select  distinct  fexamno,fexamname from degree 
					where fexamno='{$exam_no}' and FDEGREE='{$degree}'";
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	if($lobj_get_name)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure");
    return;
	 
}

function getNextRegisterNoName($aobj_context)
{

session_start();
	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$Regno=trim($aobj_context->mobj_data["Regno"]);
	//echo $Regno; die();
	$CollegeCode = $_SESSION['collcode'];
	
	$get_name_by_degree_code="select fregno,fname from student where fcollcode= '{$CollegeCode}'and fregno>'{$Regno}' order by 1 limit 1";
	//echo $get_name_by_degree_code; die();
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	if($lobj_get_name!= 0)	
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
    else
      echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,-1,"Failure");
    return;
}

function CheckEnteredstudentSubjectCode($aobj_context)
{
	session_start();	
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$college_code = $_SESSION['collcode'];
	$Degcode=trim($aobj_context->mobj_data["degcode"]);
	$examno=trim($aobj_context->mobj_data["exam_no"]);
	$category=trim($aobj_context->mobj_data["category"]);
	$Subcode=trim($aobj_context->mobj_data["subcode"]);
	$module=trim($aobj_context->mobj_data["module"]);
	$id=trim($aobj_context->mobj_data["id"]);
	$id_split=explode("_",$id);
	$id=$id_split[3];
	$cat_cond='';

$select_category_cond = "select Value from markentrycodition 
						  where FMODULE='{$module}' and Code='{$category}' and FDELETED='F'";
	$lobj_select_category_cond = $aobj_context->mobj_db->GetRow($select_category_cond);
	
	if($lobj_select_category_cond['Value']!='0' || $lobj_select_category_cond['Value']!=0) 
		$cat_cond=" and ".$lobj_select_category_cond['Value'];	
	
	$get_name_by_degree_code=" select '{$id}' as id, FCSUBCODE,FSUBNAME,FSSUBNAME,FSHORTNAME,FSMAXMARKS from 
								subject s inner join colldeg c on
								s.FDEGREE = c.FDEGREE 
								and s.fdegree = '{$Degcode}' and s.fexamno='{$examno}' 								
								where s.FCSUBCODE='{$Subcode}' and
								c.FCOLLCODE='{$college_code}' {$cat_cond} ";								
	$lobj_get_name = $aobj_context->mobj_db->GetRow($get_name_by_degree_code);
	
	if($lobj_get_name)	
	{
		$chk_fcsubcode =  "select count(*) as count from colldeg 
							where FMESTATUS{$examno} like '%{$Subcode}%' ";
		$lobj_chk_fcsubcode = $aobj_context->mobj_db->GetRow($chk_fcsubcode);					
		if($lobj_chk_fcsubcode['count']==0)
		{
			echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_name,0,"success"); 
		}
		else
		{
			$rs_data = "Subject Freezed By Admin";
			echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure");
		}
    }
	else
     {
			$rs_data =$id;
			echo $aobj_context->mobj_output->ToJSONEnvelope($rs_data,-1,"Failure");
	 }	
    return;	 
}

${this.title}

Code Editor : getdata.php