ERROR!! Couldn't connect to server!");
}
}
?>
PLEASE SELECT DISTRICT";
while(OCIFetchInto($rsdistrict,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["GR_DISTRICT_ID"];
$tableShow = $mod_row["GR_DISTRICT"];
if ($tableValue == $oldvalue)
$Select_district = $Select_district . "\n";
else
$Select_district = $Select_district . "\n";
} // end for
return $Select_district;
} // end function
function DomicileList ($oldvalue,$conn)
{
$selDomicile = "select DOMICILE_NAME, DOMICILE_CODE from DOMICILE where CSS_FLAG=1 ORDER BY DOMICILE_NAME";
$rsDomicile = OCIParse($conn,$selDomicile);
OCIExecute($rsDomicile);
$Select_Domicile = "";
while(OCIFetchInto($rsDomicile,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["DOMICILE_CODE"];
$tableShow = $mod_row["DOMICILE_NAME"];
if ($tableValue == $oldvalue)
$Select_Domicile = $Select_Domicile . "\n";
else
$Select_Domicile = $Select_Domicile . "\n";
} // end for
return $Select_Domicile;
} // end function
function CenterList ($oldvalue,$conn)
{
$selCenter = "select CENTER_NAME, CENTER_CODE from CENTER ORDER BY Center_NAME";
$rsCenter = OCIParse($conn,$selCenter);
OCIExecute($rsCenter);
$Select_Center = "";
while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) {
$tableValue = $mod_row["CENTER_CODE"];
$tableShow = $mod_row["CENTER_NAME"];
if ($tableValue == $oldvalue)
$Select_Center = $Select_Center . "\n";
else
$Select_Center = $Select_Center . "\n";
} // end for
return $Select_Center;
} // end function
function UniversityList ($oldvalue,$conn)
{
$selUniversity = "select GR_UNIVERSITY_NAME , GR_UNIVERSITY_ID from GR_BOARD_UNIVERSITY ORDER BY GR_UNIVERSITY_NAME";
$rsUniversity = OCIParse($conn,$selUniversity);
OCIExecute($rsUniversity);
$Select_University = "";
$rowcount = 0;
while(OCIFetchInto($rsUniversity,$mod_row, OCI_ASSOC)) {
if ($rowcount == 0 )
$Select_University = $Select_University . "\n";
$rowcount++;
$tableValue = $mod_row["GR_UNIVERSITY_ID"];
$tableShow = $mod_row["GR_UNIVERSITY_NAME"];
if ($tableValue == $oldvalue)
$Select_University = $Select_University . "\n";
else
$Select_University = $Select_University . "\n";
} // end for
return $Select_University;
} // end function
function JobStatus ($oldvalue)
{
$arrJobStatus[114] = "Federal Govt.";
$arrJobStatus[115] = "Provincial Govt.";
$arrJobStatus[116] = "Armed Forces";
$arrJobStatus[117] = "Semi Govt.";
$arrJobStatus[118] = "Private";
$arrJobStatus[119] = "Pvt. Practice/ Self Employed";
$Select_JobStatus = "";
foreach($arrJobStatus as $key => $value) {
$tablekey = $key;
$tableValue = $value;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_JobStatus = $Select_JobStatus . "\n";
else
$Select_JobStatus = $Select_JobStatus . "\n";
} // end for
return $Select_JobStatus;
} // end function
function JobNature ($oldvalue)
{
$arrJobNature[121] = "Permanent";
$arrJobNature[122] = "Temporary";
$arrJobNature[123] = "Officiating";
$arrJobNature[124] = "Contract/Ad-Hoc";
$Select_JobNature = "";
foreach ($arrJobNature as $key => $value) {
$tableValue = $value;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_JobNature = $Select_JobNature . "\n";
else
$Select_JobNature = $Select_JobNature . "\n";
} // end for
return $Select_JobNature;
} // end function
function GradeList ($oldvalue)
{
$arrGrade[] = "A";
$arrGrade[] = "B";
$arrGrade[] = "C";
$arrGrade[] = "D";
$arrGrade[] = "E";
$arrGrade[] = "F";
$Select_Grade = "";
$rowcount = 0;
foreach ($arrGrade as $key => $value) {
if ($rowcount == 0)
$Select_Grade = $Select_Grade . "\n";
$rowcount++;
$tableValue = $value;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_Grade = $Select_Grade . "\n";
else
$Select_Grade = $Select_Grade . "\n";
} // end for
return $Select_Grade;
} // end function
function WeekList ($oldvalue)
{
$arrWeek[] = "1";
$arrWeek[] = "2";
$arrWeek[] = "3";
$arrWeek[] = "4";
$arrWeek[] = "5";
$arrWeek[] = "6";
$Select_Week = "";
foreach ($arrWeek as $key => $value) {
$tableValue = $value;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_Grade = $Select_Grade . "\n";
else
$Select_Week = $Select_Week . "\n";
} // end for
return $Select_Week;
} // end function
function AgeList($oldvalue)
{
$arrAge[]=array();
for($i=1;$i<=60;$i++)
{
array_push($arrAge,$i);
}
$Select_Age = "";
foreach ($arrAge as $key => $value) {
$tableValue = $value;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_Age = $Select_Age . "\n";
else
$Select_Age = $Select_Age . "\n";
} // end for
return $Select_Age;
} // end function
function DivisionList ($oldvalue)
{
echo $oldvalue;
$arrDivision[] = "First";
$arrDivision[] = "Second";
$arrDivision[] = "Third";
$Select_Division = "";
$rowcount = 0;
foreach ($arrDivision as $key => $value) {
if ($rowcount == 0 )
$Select_Division = $Select_Division . "\n";
$rowcount++;
$tableValue = $value;
$tableShow = $value;
if ($tableValue == $oldvalue)
$Select_Division = $Select_Division . "\n";
else
$Select_Division = $Select_Division . "\n";
} // end for
return $Select_Division;
} // end function
function BoardUniversityList ($oldvalue)
{
echo $oldvalue;
$arrBoardUniversity[] = "quaid - azam";
$arrBoardUniversity[] = "allam iqbal";
$arrBoardUniversity[] = "NED university";
$arrBoardId[]="1";
$arrBoardId[]="2";
$arrBoardId[]="3";
$Select_BoardUniversity = "";
$rowcount = 0;
$rowthis=0;
foreach ($arrBoardUniversity as $key => $value) {
if ($rowcount == 0 )
$Select_BoardUniversity = $Select_BoardUniversity . "\n";
$rowcount++;
$tableValue = $value;
$tableShow = $value;
if ($arrBoardId[$rowthis] == $oldvalue)
$Select_BoardUniversity = $Select_BoardUniversity . "\n";
else
$Select_BoardUniversity = $Select_BoardUniversity . "\n";
$rowthis++;
} // end for
return $Select_BoardUniversity;
} // end function
?>