Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxr-xr-x
cManualMailer.php	3.68 KB	-rwxr-xr-x
cManualMailermohan.php	3.68 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
caccesscontextold.php	1.24 KB	-rwxr-xr-x
cappcontext.php	2.68 KB	-rwxr-xr-x
cappcontext_02032018.php	2.69 KB	-rwxr-xr-x
cconfig.php	1.08 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	518 B	-rwxr-xr-x
csessionsold.php	514 B	-rwxr-xr-x
curricular.php	4.41 KB	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.34 KB	-rwxr-xr-x
customappcontext_old.php	2.35 KB	-rwxr-xr-x
educationdet.php	19.85 KB	-rwxr-xr-x
eperience_det.php	23.08 KB	-rwxr-xr-x
eperience_det_old.php	23.69 KB	-rwxr-xr-x
foreigndetails.php	1.66 KB	-rwxr-xr-x
format.php	6.75 KB	-rwxr-xr-x
getdata.php	6.97 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	1.9 KB	-rwxr-xr-x
login_11102017.php	1.62 KB	-rwxr-xr-x
mregistry.php	9.76 KB	-rwxr-xr-x
orientiondet.php	1.82 KB	-rwxr-xr-x
other_det.php	2.93 KB	-rwxr-xr-x
otherexpdetails.php	821 B	-rwxr-xr-x
payment_det.php	11.42 KB	-rwxr-xr-x
payment_det1.php	11.27 KB	-rwxr-xr-x
personaldet.php	8.11 KB	-rwxr-xr-x
post.php	8.39 KB	-rwxr-xr-x
post_22.php	7.12 KB	-rwxr-xr-x
postdetails.php	1.57 KB	-rwxr-xr-x
preview_det.php	75.63 KB	-rwxr-xr-x
preview_det_22.php	55.56 KB	-rwxr-xr-x
preview_det_old.php	55.89 KB	-rwxr-xr-x
preview_det_raghu.php	60.1 KB	-rwxr-xr-x
printapp_det.php	69.18 KB	-rwxr-xr-x
printapp_det.php1	69.09 KB	-rwxr-xr-x
publicationdet.php	2.09 KB	-rwxr-xr-x
referencesdet.php	1.82 KB	-rwxr-xr-x
registration.php	5.37 KB	-rwxr-xr-x
registration_11102017.php	3.3 KB	-rwxr-xr-x
research_det.php	53.96 KB	-rwxr-xr-x
research_det2.php	112.53 KB	-rwxr-xr-x
researchdetails.php	1.77 KB	-rwxr-xr-x
sendGridMail.php	1.17 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
upload_det.php	1.91 KB	-rwxr-xr-x
upload_file.php	585 B	-rwxr-xr-x
uploaddocuments.php	3.98 KB	-rwxr-xr-x
workexpdetails.php	1.53 KB	-rwxr-xr-x

Code Editor : eperience_det.php

<?php
function saveexperiencedetails($aobj_context)
{
	//session_start();
	$userid = $_SESSION['userid'];
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	
	$appno = stripslashes($aobj_context->mobj_data["appno"]);
	$funivname = stripslashes($aobj_context->mobj_data["funivname"]);
	$fdegncode = stripslashes($aobj_context->mobj_data["fdegncode"]);
	$ffromdate = stripslashes($aobj_context->mobj_data["ffromdate"]);
	$fstatus = stripslashes($aobj_context->mobj_data["fstatus"]);
		
	
	$query = "delete from expdetl
	where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'present'";
	$results =$aobj_context->mobj_db->Execute($query);
	
	$funivname = str_replace("'","`",$funivname);
	$fdegncode = str_replace("'","`",$fdegncode);
	
	
	$query = "insert ignore into expdetl(fuserid,fappno,funivname,fdegncode,fstatus,ffromdate,fenttype) 
		values('{$userid}','{$appno}','{$funivname}','{$fdegncode}','{$fstatus}',DATE_FORMAT(str_to_date('{$ffromdate}','%d/%m/%Y'),'%Y-%m-%d'),'present')";
	$results = $aobj_context->mobj_db->Execute($query);	
		
	
	if($results)  
	{
			$query = "select funivname, fdegncode, fstatus, date_format(ffromdate,'%d/%m/%Y') as ffromdate from expdetl
					where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'present'";
			$results = $aobj_context->mobj_db->getRow($query);	
			$arr=$results;
			echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
			return;
	}	
	else
	{
		$arr='Insertion Failed';					 
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		return;
	}
}

$query = "select fslno,fuserid,fappno,funivname,fdegncode,fstatus,fpayscale,date_format(ffromdate,'%d/%m/%Y') as ffromdate,date_format(ftodate,'%d/%m/%Y') as ftodate,fexp,fpoints,fenclosureno,fenttype from expdetl
		where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'phd'";
		$results  = $aobj_context->mobj_db->getAll($query);
		
		$i = 2;
		$table2 ='';
		foreach($results as $value)
		{
			$slno = $value['fslno'];
			
			$table2.="<tr>";  
			$table2.="<td>";
			$table2.="<input type = 'hidden'  value = '{$value['fslno']}' disabled id='postid1_{$i}'/>";
			$table2.="<input type='text' style='width:90%;' disabled id = '{$i}BT10'  name='fulltimeexp' value = '{$value['funivname']}' />";
			$table2.="</td>"; 
			$table2.="<td>";
			$table2.="<textarea type='text' style='width:90%;' disabled id = '{$i}BT11'  >{$value['fdegncode']}</textarea>";
			$table2.="</td>"; 
			$table2.="<td><textarea type='text' style='width:90%;' disabled id = '{$i}BT12' >{$value['fpayscale']}</textarea></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT13' value = '{$value['ffromdate']}' /></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT14' value = '{$value['ftodate']}'  /></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT15'  value = '{$value['fexp']}' /></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT23' value = '{$value['fenclosureno']}' /></td>";
			$table2.="<td><input type='submit' class='btn btn_3 btn btn-danger' value = 'delete' onclick = 'deleteexperience2(\"$slno\",\"$i\")' id='{$i}BT10' style='width:90%;' ></td>";
			$table2.="</tr>";
			$i++;
		}

$query = "select ifnull(funivname,'') as funivname,ifnull(fdegncode,'') as fdegncode,ifnull(fstatus,'') as fstatus,ifnull(date_format(ffromdate,'%d/%m/%Y'),'DD/MM/YYYY') as ffromdate from expdetl
				  where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'present'";
		$results  = $aobj_context->mobj_db->getRow($query);
		$rst['table'] = $table;
		$rst['table2'] = $table2;
		$rst['table3'] = $results;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
}

$rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");

/* $rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success"); */
	}
}

$rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
			
	}else
	{
		$query = "select fslno,fuserid,fappno,funivname,fdegncode,fstatus,fpayscale,date_format(ffromdate,'%d/%m/%Y') as ffromdate,date_format(ftodate,'%d/%m/%Y') as ftodate,fexp,fpoints,fenclosureno,fenttype from expdetl
		where fuserid = '{$userid}' and fappno = '{$appno}' and fenttype = 'teach'";
		$results  = $aobj_context->mobj_db->getAll($query);
		//var_dump($query);
		
		$i = 2;
		$table ='';
		foreach($results as $value)
		{
			$slno = $value['fslno'];
			
			$table.="<tr style = 'width:90%'>";  
			$table.="<td>";
			$table.="<input type = 'hidden'  value = '{$value['fslno']}' id='postid_{$i}'/><textarea type='text' style='width:90%;' disabled id = '{$i}BT1'  name='fulltimeexp'  >{$value['funivname']}</textarea>";
			$table.="</td>"; 
			$table.="<td>";
			$table.="<textarea type='text' style='width:90%;' disabled id = '{$i}BT2'  >{$value['fdegncode']}</textarea>";
			$table.="</td>"; 
			$table.="<td>";
			$table.="<input type='text'   style='width:90%;' disabled id = '{$i}BT3' value = '{$value['fstatus']}' />";
			/* $table.="<select style='width:90%;' id = '{$i}BT3' disabled value = '{$value['fstatus']}' >";
			$table.="<option value = '' >Select</option>";
			$table.="<option value = 'Permanent'>Permanent</option>";
			$table.="<option value = 'Ad-hoc'>Ad-hoc</option>";
			$table.="<option value = 'Temporay'>Temporay</option>";
			$table.="<option value = 'Contractual'>Contractual</option>";
			$table.="</select>"; */
			$table.="</td>"; 
			$table.="<td><textarea type='text' style='width:90%;' disabled id = '{$i}BT4' >{$value['fpayscale']}</textarea></td>";
			$table.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT5' value = '{$value['ffromdate']}' /></td>";
			$table.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT6' value = '{$value['ftodate']}'  /></td>";
			$table.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT7'  value = '{$value['fexp']}' /></td>";
			//$table.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT8' value = '{$value[fpoints]}' /></td>";
			$table.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT22' value = '{$value['fenclosureno']}' /></td>";
			$table.="<td><input type='submit' class='btn btn_3 btn btn-info' value = 'Edit' onclick = 'editexperience(\"$slno\",\"$i\")' id='{$i}BT9' style='width:90%;' ><br><br><input type='submit' value = 'delete' class='btn btn_3 btn btn-danger' onclick = 'deleteexperience(\"$slno\",\"$i\")' id='{$i}BT10' style='width:90%;' ></td>";
			$table.="</tr>";
			$i++;
		}

$rst['table'] = $table;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
		
	}		
	
}

$rst['table'] = $table2;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
	}
}

$table2.="<td><textarea type='text' style='width:90%;' disabled id = '{$i}BT11'  >{$value['fdegncode']}</textarea></td>";			
			$table2.="<td><textarea type='text' style='width:90%;' disabled id = '{$i}BT12' >{$value['fpayscale']}</textarea></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT13' value = '{$value['ffromdate']}' /></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT14' value = '{$value['ftodate']}'  /></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT15'  value = '{$value['fexp']}' /></td>";
			$table2.="<td><input type='text'   style='width:90%;' disabled id = '{$i}BT23' value = '{$value['fenclosureno']}' /></td>";
			$table2.="<td><input type='submit' class='btn btn_3 btn btn-danger' value = 'delete' onclick = 'deleteexperience2(\"$slno\",\"$i\")' id='{$i}BT10' style='width:90%;' ></td>";
			$table2.="</tr>";
			$i++;
		}
		
		$rst['table'] = $table2;
		echo $aobj_context->mobj_output->ToJSONEnvelope($rst,0,"success");
		
	}		
	
}
?>

${this.title}

Code Editor : eperience_det.php