Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
apitest.php	1.61 KB	-rw-r--r--
caccesscontext.php	1.28 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
downloadStudHalltiket.php	2.47 KB	-rw-r--r--
downloadStudPhoto.php	416 B	-rw-r--r--
genToken.php	717 B	-rw-r--r--
getAttDet.php	3.95 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
mregistry.php	1.1 KB	-rwxr-xr-x
profile.php	938 B	-rwxr-xr-x
sduvaldata.php	2.55 KB	-rw-r--r--
studentExamFee.php	3.83 KB	-rw-r--r--
studentResults.php	5.08 KB	-rw-r--r--
studentia.php	8.14 KB	-rw-r--r--
studentprofile.php	6.86 KB	-rw-r--r--
studentsubject.php	5.14 KB	-rw-r--r--

Code Editor : studentia.php

<?php

function getStudSubIa($aobj_context)
{ 
	$data_json = file_get_contents("php://input");
	$data = json_decode($data_json,true);
    
	if($_SERVER['PHP_AUTH_USER'] == 'revaapiuser' && $_SERVER['PHP_AUTH_PW'] == 'reva@124')
	{

}else
	{
		$arry='Unauthorized User';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

if(count($data) <=0)	
	{
		$arry='Kindaly Pass Data';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

$i = 0;
	$resrayy = [];
	$error = 0;
	$succes = 0;
	$res = [];
	$sem=["1"=>"A","2"=>"B","3"=>"C","4"=>"D","5"=>"E","6"=>"F","7"=>"G","8"=>"H","9"=>"I","10"=>"J"];

foreach($data as $val)
    {
		
		$query = "select fdegree,FMEYEAR,FMEEXAMTYP from degree where fedegcode = '{$val['degcode']}' 
		and fexamno = 'A'";
		$res1 = $aobj_context->mobj_db->getRow($query);
		$fdegree = $res1['fdegree'];
		$year = $res1['FMEYEAR'];
		$examtype = $res1['FMEEXAMTYP'];
		if($res1)
		{
			$semvalue = $sem[$val['sem']];
			$query = "select fcollcode from college where fecollcode = '{$val['collcode']}'";
			$res2 = $aobj_context->mobj_db->getRow($query);
			$collcode = $res2['fcollcode'];
			if($res2)
			{
				$query = "select fsubcode from subject where fdegree = '{$fdegree}'
				and fexamno = '{$semvalue}'
				and fesubcode = '{$val['subcode']}'";
				// var_dump($query);
				// die();
				$res3 = $aobj_context->mobj_db->getRow($query);
				$fsubcode = $res3['fsubcode'];
				if($res3)
				{
					if($val['rtype'] == 'I')
					{
						$query = "INSERT INTO estudia (fregno, fcollcode, fecollcode, fdegree, fedegree, fdegname, 
						fsem, fsubcode, fesubcode, fsubname, fmaxtheorymarks, fsectheorymarks, 
						fmaxquizmarks, fsecquizmarks, fmaxseminarmarks, fsecseminarmarks, fmaxseloftopicmarks, 
						fsecseloftopicmarks, fmaxanaandsyntmarks, fsecanaandsyntmarks, fmaxlitandsvymarks, 
						fseclitandsvymarks, fmaxethicattmarks, fsecethicattmarks, fmaxindlearnmarks, 
						fsecindlearnmarks, fmaxoralmarks, fsecoralmarks, fmaxrepwritemarks, fsecrepwritemarks, 
						fmaxcontlearnmarks, fseccontlearnmarks, fmaxknowexermarks, fsecknowexercisemarks, 
						fmaxexecexercisemarks, fsecexecexercisemarks, fmaxdescexpmarks, fsecdescexpmarks, 
						fmaxvivamarks, fsecvivamarks, fmaxpunctualmarks, fsecpunctualmarks, fmaxpracresultsmarks, 
						fsecpracresultsmarks, fsubtype, fiatype, frtype, fcreateddate)
						VALUES ('{$val['regno']}','{$collcode}','{$val['collcode']}','{$fdegree}','{$val['degcode']}','{$val['degname']}',
						'{$semvalue}','{$fsubcode}','{$val['subcode']}','{$val['subname']}','{$val['maxTheorymarks']}',
						'{$val['secTheorymarks']}','{$val['maxQuizmarks']}','{$val['secQuizmarks']}','{$val['maxSeminarmarks']}',
						'{$val['secSeminarmarks']}','{$val['maxSelofTopicmarks']}','{$val['secSelofTopicmarks']}',
						'{$val['maxAnaandSyntmarks']}','{$val['secAnaandSyntmarks']}','{$val['maxLitandSvymarks']}',
						'{$val['secLitandSvymarks']}','{$val['maxEthicAttmarks']}','{$val['secEthicAttmarks']}',
						'{$val['maxIndLearnmarks']}','{$val['secIndLearnmarks']}','{$val['maxOralmarks']}','{$val['secOralmarks']}',
						'{$val['maxRepwritemarks']}','{$val['secRepwritemarks']}','{$val['maxContLearnmarks']}','{$val['secContLearnmarks']}',
						'{$val['maxKnowExermarks']}','{$val['secKnowExercisemarks']}','{$val['maxExecExercisemarks']}',
						'{$val['secExecExercisemarks']}','{$val['maxDescExpmarks']}','{$val['secDescExpmarks']}',
						'{$val['maxVivamarks']}','{$val['secVivamarks']}','{$val['maxPunctualmarks']}',
						'{$val['secPunctualmarks']}','{$val['maxPracResultsmarks']}','{$val['secPracResultsmarks']}',
						'{$val['subtype']}','{$val['iatype']}','{$val['rtype']}',now()
						)";
				
						$result = $aobj_context->mobj_db->Execute($query);

if($result)
						{
							$res['status'] = "T";
							$res['regno'] = $val['regno'];
							$res['degcode'] = $val['degcode'];
							$res['subcode'] = $val['subcode'];
							$res['iatype'] = $val['iatype'];
							$res['msg'] = "Inserted Successfully";
							$succes++;
						}else
						{
							$res['status'] = "F";
							$res['regno'] = $val['regno'];
							$res['degcode'] = $val['degcode'];
							$res['subcode'] = $val['subcode'];
							$res['iatype'] = $val['iatype'];
							$res['msg'] = "Insertion Failed";
							$error++;
						}

}
					else if($val['rtype'] == 'U')
					{
						$query = "update estudia set 
						fmaxtheorymarks = '{$val['maxTheorymarks']}', 
						fsectheorymarks = '{$val['secTheorymarks']}', 
						fmaxquizmarks = '{$val['maxQuizmarks']}', 
						fsecquizmarks = '{$val['secQuizmarks']}', 
						fmaxseminarmarks = '{$val['maxSeminarmarks']}', 
						fsecseminarmarks = '{$val['secSeminarmarks']}', 
						fmaxseloftopicmarks = '{$val['maxSelofTopicmarks']}', 
						fsecseloftopicmarks = '{$val['secSelofTopicmarks']}', 
						fmaxanaandsyntmarks = '{$val['maxAnaandSyntmarks']}', 
						fsecanaandsyntmarks = '{$val['secAnaandSyntmarks']}', 
						fmaxlitandsvymarks = '{$val['maxLitandSvymarks']}', 
						fseclitandsvymarks = '{$val['secLitandSvymarks']}', 
						fmaxethicattmarks = '{$val['maxEthicAttmarks']}', 
						fsecethicattmarks = '{$val['secEthicAttmarks']}', 
						fmaxindlearnmarks = '{$val['maxIndLearnmarks']}', 
						fsecindlearnmarks = '{$val['secIndLearnmarks']}', 
						fmaxoralmarks = '{$val['maxOralmarks']}', 
						fsecoralmarks = '{$val['secOralmarks']}', 
						fmaxrepwritemarks = '{$val['maxRepwritemarks']}', 
						fsecrepwritemarks = '{$val['secRepwritemarks']}', 
						fmaxcontlearnmarks = '{$val['maxContLearnmarks']}', 
						fseccontlearnmarks = '{$val['secContLearnmarks']}', 
						fmaxknowexermarks = '{$val['maxKnowExermarks']}', 
						fsecknowexercisemarks = '{$val['secKnowExercisemarks']}', 
						fmaxexecexercisemarks = '{$val['maxExecExercisemarks']}', 
						fsecexecexercisemarks = '{$val['secExecExercisemarks']}', 
						fmaxdescexpmarks = '{$val['maxDescExpmarks']}', 
						fsecdescexpmarks = '{$val['secDescExpmarks']}', 
						fmaxvivamarks = '{$val['maxVivamarks']}', 
						fsecvivamarks = '{$val['secVivamarks']}', 
						fmaxpunctualmarks = '{$val['maxPunctualmarks']}', 
						fsecpunctualmarks = '{$val['secPunctualmarks']}', 
						fmaxpracresultsmarks = '{$val['maxPracResultsmarks']}', 
						fsecpracresultsmarks = '{$val['secPracResultsmarks']}',
						frtype = '{$val['rtype']}',
						fupdateddate = now()
						where fregno = '{$val['regno']}' 
						and fsubcode = '{$fsubcode}'
						and fiatype = '{$val['iatype']}'";
						//var_dump($query);
						$result = $aobj_context->mobj_db->Execute($query);

if($result)
						{
							$res['status'] = "T";
							$res['regno'] = $val['regno'];
							$res['degcode'] = $val['degcode'];
							$res['subcode'] = $val['subcode'];
							$res['iatype'] = $val['iatype'];
							$res['msg'] = "Updated Successfully";
							$succes++;
						}else
						{
							$res['status'] = "F";
							$res['regno'] = $val['regno'];
							$res['degcode'] = $val['degcode'];
							$res['subcode'] = $val['subcode'];
							$res['iatype'] = $val['iatype'];
							$res['msg'] = "Updatedtion Failed";
							$error++;
						}
					}

}else
				{
					$res['status'] = "F";
					$res['regno'] = $val['regno'];
					$res['degcode'] = $val['degcode'];
					$res['subcode'] = $val['subcode'];
					$res['iatype'] = $val['iatype'];
					$res['msg'] = "Subject Master Not Mached";
					$error++;
				}
			}
			else
			{
				$res['status'] = "F";
				$res['regno'] = $val['regno'];
				$res['degcode'] = $val['degcode'];
				$res['subcode'] = $val['subcode'];
				$res['iatype'] = $val['iatype'];
				$res['msg'] = "College Master Not Mached";
				$error++;
			}
		}else
		{
			$res['status'] = "F";
			$res['regno'] = $val['regno'];
			$res['degcode'] = $val['degcode'];
			$res['subcode'] = $val['subcode'];
			$res['iatype'] = $val['iatype'];
			$res['msg'] = "Degree Master Not Mached";
			$error++;
		}
		$i++;
		array_push($resrayy,$res);

}
	
	$msg = "success";
	if($succes >'0' && $error == '0')
	{
		$msg = "success";
	}else if($error>'0' && $succes == '0')
	{
		$msg  = "Failure";
	}else if($succes >'0' && $error>'0')
	{
		$msg = "Partial";
	}

$arry['resdata'] = $resrayy;
	echo $aobj_context->mobj_output->ToJSONEnvelope($arry,0,$msg);
	return;

}

${this.title}

Code Editor : studentia.php