$value) { // if ($rowcount == 0) // $Select_Years = $Select_Years . "Select\n"; // $rowcount++; $tableValue = $key; $tableShow = $value; if ($tableValue == $oldvalue) $Select_Years = $Select_Years . "$tableShow\n"; else $Select_Years = $Select_Years . "$tableShow\n"; } // end for return $Select_Years; } // end function function AgeRelaxGovt($oldvalue) { $arrYears[0]="Less than 2 year"; $arrYears[10]="2 years or above"; //print_r($arrYears); $Select_Years = ""; // $rowcount = 0; foreach ($arrYears as $key => $value) { // if ($rowcount == 0) // $Select_Years = $Select_Years . "Select\n"; // $rowcount++; $tableValue = $key; $tableShow = $value; if ($tableValue == $oldvalue) $Select_Years = $Select_Years . "$tableShow\n"; else $Select_Years = $Select_Years . "$tableShow\n"; } // end for return $Select_Years; } // end function function districtList ($oldvalue,$conn) { $seldistrict = "select GR_DOMICILE_ID,GR_DISTRICT_ID, GR_DISTRICT from DISTRICT ORDER BY GR_DISTRICT"; $rsdistrict = OCIParse($conn,$seldistrict); OCIExecute($rsdistrict); $Select_district = ""; while(OCIFetchInto($rsdistrict,$mod_row, OCI_ASSOC)) { $tableValue = $mod_row["GR_DISTRICT_ID"]; $tableShow = $mod_row["GR_DISTRICT"]; $tableClass = $mod_row["GR_DOMICILE_ID"]; if ($tableValue == $oldvalue) $Select_district = $Select_district . "$tableShow"; else $Select_district = $Select_district . "$tableShow"; } // end for return $Select_district; } // end function function DegreeList ($oldvalue,$conn) { $selDegree = "select EIS_DEGREE_ID , EIS_NAME from EIS_DEGREE ORDER BY EIS_DEGREE_ID"; $rsDegree = OCIParse($conn,$selDegree); OCIExecute($rsDegree); $Select_Degree = ""; $rowcount = 0; while(OCIFetchInto($rsDegree,$mod_row, OCI_ASSOC)) { if ($rowcount == 0 ) $Select_Degree = $Select_Degree . "Select"; $rowcount++; $tableValue = $mod_row["EIS_DEGREE_ID"]; $tableShow = $mod_row["EIS_NAME"]; if ($tableValue == $oldvalue) $Select_Degree = $Select_Degree . "$tableShow"; else $Select_Degree = $Select_Degree . "$tableShow"; } // end for return $Select_Degree; } // end function function DomicileList ($oldvalue,$conn) { $selDomicile = "select DOMICILE_NAME, DOMICILE_CODE from DOMICILE 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 . "$tableShow"; else $Select_Domicile = $Select_Domicile . "$tableShow"; } // end for return $Select_Domicile; } // end function function AgeRelaxList ($oldvalue,$conn) { $selDomicile = "select t.gr_age_relax_id, t.gr_age_relax_desc from gr_age_relax t where t.gr_age_relax_active=1 order by t.gr_age_relax_id"; $rsDomicile = OCIParse($conn,$selDomicile); OCIExecute($rsDomicile); $Select_Domicile = ""; while(OCIFetchInto($rsDomicile,$mod_row, OCI_ASSOC)) { $tableValue = $mod_row["gr_age_relax_id"]; $tableShow = $mod_row["gr_age_relax_desc"]; if ($tableValue == $oldvalue) $Select_Domicile = $Select_Domicile . "$tableShow\n"; else $Select_Domicile = $Select_Domicile . "$tableShow\n"; } // end for return $Select_Domicile; } // end function function AgeRelaxListnew ($oldvalue,$conn) { $selCenter = "select GR_AGE_RELAX_DESC, GR_AGE_RELAX_ID from GR_AGE_RELAX ORDER BY GR_AGE_RELAX_ID"; $rsCenter = OCIParse($conn,$selCenter); OCIExecute($rsCenter); $Select_Center = ""; while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) { $tableValue = $mod_row["GR_AGE_RELAX_ID"]; $tableShow = $mod_row["GR_AGE_RELAX_DESC"]; if ($tableValue == $oldvalue) $Select_Center = $Select_Center . "$tableShow\n"; else $Select_Center = $Select_Center . "$tableShow\n"; } // end for return $Select_Center; } // end function function CenterListnew ($oldvalue,$conn) { $selCenter = "select CENTER_NAME, CENTER_CODE,CENTER_ID from CENTER where GR_CENTER = 1 ORDER BY Center_NAME"; $rsCenter = OCIParse($conn,$selCenter); OCIExecute($rsCenter); $Select_Center = ""; while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) { $tableValue = $mod_row["CENTER_ID"]; $tableShow = $mod_row["CENTER_NAME"]; if ($tableValue == $oldvalue) $Select_Center = $Select_Center . "$tableShow\n"; else $Select_Center = $Select_Center . "$tableShow\n"; } // end for return $Select_Center; } function InterviewListnew ($oldvalue,$conn) { $selCenter = "select CENTER_NAME, CENTER_CODE,CENTER_ID from CENTER where INTERVIEW_CENTER = 1 ORDER BY Center_NAME"; $rsCenter = OCIParse($conn,$selCenter); OCIExecute($rsCenter); $Select_Center = ""; while(OCIFetchInto($rsCenter,$mod_row, OCI_ASSOC)) { $tableValue = $mod_row["CENTER_ID"]; $tableShow = $mod_row["CENTER_NAME"]; if ($tableValue == $oldvalue) $Select_Center = $Select_Center . "$tableShow\n"; else $Select_Center = $Select_Center . "$tableShow\n"; } // end for return $Select_Center; } function CenterList ($oldvalue,$conn) { $selCenter = "select CENTER_NAME, CENTER_CODE,CENTER_ID 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_ID"]; $tableShow = $mod_row["CENTER_NAME"]; if ($tableValue == $oldvalue) $Select_Center = $Select_Center . "$tableShow\n"; else $Select_Center = $Select_Center . "$tableShow\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 . "Select"; $rowcount++; $tableValue = $mod_row["GR_UNIVERSITY_ID"]; $tableShow = $mod_row["GR_UNIVERSITY_NAME"]; if ($tableValue == $oldvalue) $Select_University = $Select_University . "$tableShow"; else $Select_University = $Select_University . "$tableShow"; } // end for return $Select_University; } // end function function JobStatus ($oldvalue) { $arrJobStatus[] = "Federal Government"; $arrJobStatus[] = "Provincial Government"; $arrJobStatus[] = "Armed Forces"; $arrJobStatus[] = "Semi Government"; $arrJobStatus[] = "Private"; $Select_JobStatus = ""; foreach($arrJobStatus as $key => $value) { $tableValue = $value; $tableShow = $value; if ($tableValue == $oldvalue) $Select_JobStatus = $Select_JobStatus . "$tableShow"; else $Select_JobStatus = $Select_JobStatus . "$tableShow"; } // end for return $Select_JobStatus; } // end function function JobNature ($oldvalue) { $arrJobNature[] = "Permanent"; $arrJobNature[] = "Temporary"; $arrJobNature[] = "Officiating"; $arrJobNature[] = "Contract"; $arrJobNature[] = "Adhoc"; $arrJobNature[] = "Daily Wages"; $arrJobNature[] = "Honorary"; $arrJobNature[] = "Part Time"; $arrJobNature[] = "Apprentice"; $Select_JobNature = ""; foreach ($arrJobNature as $key => $value) { $tableValue = $value; $tableShow = $value; if ($tableValue == $oldvalue) $Select_JobNature = $Select_JobNature . "$tableShow"; else $Select_JobNature = $Select_JobNature . "$tableShow"; } // 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 . "Select"; //$rowcount++; $tableValue = $value; $tableShow = $value; if ($tableValue == $oldvalue) $Select_Grade = $Select_Grade . "$tableShow"; else $Select_Grade = $Select_Grade . "$tableShow"; } // end for return $Select_Grade; } // end function function NatureList ($oldvalue) { $arrNature[]="Internee"; $arrNature[]="On Job"; //print_r($arrYears); $Select_Years = ""; $rowcount = 0; foreach ($arrNature as $key => $value) { if ($rowcount == 0) $Select_Years = $Select_Years . "Select"; $rowcount++; $tableValue = $value; $tableShow = $value; if ($tableValue == $oldvalue) $Select_Years = $Select_Years . "$tableShow"; else $Select_Years = $Select_Years . "$tableShow"; } // end for return $Select_Years; } // end function function WeekList ($oldvalue) { for ($i=1;$i<=60;$i++){ $arrWeek[] = $i; } $Select_Week = ""; foreach ($arrWeek as $key => $value) { $tableValue = $value; $tableShow = $value; if ($tableValue == $oldvalue) $Select_Week = $Select_Week . "$tableShow"; else $Select_Week = $Select_Week . "$tableShow"; } // 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 . "$tableShow\n"; else $Select_Age = $Select_Age . "$tableShow\n"; } // end for return $Select_Age; } // end function function DivisionList ($oldvalue) { echo $oldvalue; $arrDivision[] = "First"; $arrDivision[] = "Second"; $arrDivision[] = "Third"; //$arrDivision[] = "Fourth"; $Select_Division = ""; $rowcount = 0; foreach ($arrDivision as $key => $value) { if ($rowcount == 0 ) $Select_Division = $Select_Division . "Select"; $rowcount++; $tableValue = $value; $tableShow = $value; if ($tableValue == $oldvalue) $Select_Division = $Select_Division . "$tableShow"; else $Select_Division = $Select_Division . "$tableShow"; } // 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 . "Select\n"; $rowcount++; $tableValue = $value; $tableShow = $value; if ($arrBoardId[$rowthis] == $oldvalue) $Select_BoardUniversity = $Select_BoardUniversity . "".$arrBoardUniversity[$rowthis]."\n"; else $Select_BoardUniversity = $Select_BoardUniversity . "".$arrBoardUniversity[$rowthis]."\n"; $rowthis++; } // end for return $Select_BoardUniversity; } // end function function validjobs ($conn) { $query = "select jp.GR_JOB_ID, 'F.4-'||jp.gr_case_no||'/'||trim(to_char(jp.GR_JOB_POST_DATE,'YYYY'))||'-R ['||jp.gr_job_title||']'||js.gr_sub_name as GR_JOB_TITLE from GR_JOB_POST jp, gr_job_subs js, gr_job_sub_depend jsd where jp.gr_job_id = jsd.gr_dep_job_id(+) and jsd.gr_sub_id = js.gr_sub_id(+) and jp.gr_job_grade > 16 and GR_ADVERT_ID in( select GR_ADVERTISEMENT_ID from GR_POST_ADVERTISEMENT where (trunc(SYSDATE) - trunc(CLOSE_DATE)) <= 0) order by to_number(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(jp.gr_case_no,'A',''),'B',''),'C',''),'D',''),'E',''),'F',''),'G',''),'H',''),'I',''),'J',''),'K',''),'L',''),'M',''),'N',''),'O',''),'P',''),'Q',''),'R',''),'S',''),'T',''),'U',''),'V',''),'W',''),'X',''),'Y',''),'Z','')) "; $rjobs = OCIParse($conn,$query); OCIExecute($rjobs); $Select_jobs = "Please Select"; while(OCIFetchInto($rjobs,$mod_row, OCI_ASSOC)) { $tableValue = $mod_row["GR_JOB_ID"]; $tableShow = $mod_row["GR_JOB_TITLE"]; $Select_jobs = $Select_jobs . "$tableShow"; } // end for return $Select_jobs; } // end function function validgender ($job_id,$conn) { $query = "select t.gr_eligible_gender from gr_job_post t where gr_job_id=" . $job_id; $rgender = OCIParse($conn,$query); OCIExecute($rgender); $select_genders=""; OCIFetchInto($rgender,$mod_row, OCI_ASSOC); $tableValue = $mod_row["GR_ELIGIBLE_GENDER"]; //print_r($mod_row); if($tableValue=="BOTH"){ $select_genders = "MALEFEMALE"; } if($tableValue=="MALE"){ $select_genders = "MALE"; } if($tableValue=="FEMALE"){ $select_genders = "FEMALE"; } $select_genders = '' . $select_genders . ""; return $select_genders; } // end function function validdomicile ($job_id,$conn) { $query = "select d.domicile_code, pr.gr_province_name, t.gr_province_id from domicile d, gr_post_calculation t, gr_province pr where d.prov_id(+)=pr.gr_province_id and pr.gr_province_id!=3 and pr.gr_province_id=t.gr_province_id and t.gr_post_id in(select nvl(parent_id,gr_job_id) from gr_job_post p where gr_post_allocation>0 and p.gr_job_id=" . $job_id . ") order by t.gr_province_id"; $rprovinces = OCIParse($conn,$query); OCIExecute($rprovinces); $Select_provinces = ""; while(OCIFetchInto($rprovinces,$mod_row, OCI_ASSOC)) { if($mod_row["GR_PROVINCE_ID"]==1){ return DomicileList('',$conn); } $tableValue = $mod_row["DOMICILE_CODE"]; $tableShow = $mod_row["GR_PROVINCE_NAME"]; $Select_provinces = $Select_provinces . "$tableShow"; } // end for return $Select_provinces; } // end function function new_application($data,$conn){ /* $sql= "INSERT INTO NEW_GR_APP_PER_EDU ( GR_APPLICANT_ID, GR_APPLICANT_NAME, GR_JOB_ID, GR_DOB, GR_NEW_NIC, GR_APPLICANT_EMAIL, GR_APP_MOBILE ) VALUES( SQ_GR_LOGIN_INFORMATION.NEXTVAL, '$data->gr_applicant_name', '$data->gr_job_id', to_date('$data->gr_dob','dd-mm-yyyy'), '$data->gr_cnic', '$data->gr_email', '923335556444')"; //return $sql; $sql_ins_stmt = OCIParse($conn, $sql); if (OCIExecute($sql_ins_stmt)) { return "1"; }else{ return OCIError(); } */ $sql= "INSERT INTO NEW_GR_APP ( GR_APPLICANT_ID, GR_APPLICANT_NAME, GR_FATHER_NAME, GR_DOB, GR_NEW_NIC, GR_GENDER, GR_RELIGION, GR_POSTAL_ADD, GR_PARMANENT_ADD, GR_APPLICANT_EMAIL, GR_APPLICANT_PHONE_OFF, GR_APPLICANT_PHONE_RES, GR_APPLICANT_FAX, GR_APP_MOBILE, GR_AGEREX1, GR_RELAX_YEARS, GR_DOMICILE, GR_DISTRICT_DOMICILE, GR_DISABILITY, GR_HELPER, GR_AMOUNT, GR_JOB_ID, GR_BANK_NAME, DATE_APPLIED, GR_CENTER_ID, GR_CENTER_NAME, GR_INTERVIEW_ID, GR_INTERVIEW_NAME, GR_EXAMINATION_ID1, GR_EXAMINATION_NAME1, GR_RESULT_DATE1, GR_UNIVERSITY_ID1, GR_UNIVERSITY_NAME1, GR_BOARD_OTHER1, GR_GRADE1, GR_DIVISION1, GR_CGP1, GR_MAJOR_COURSE_WORKS1, GR_EXAMINATION_ID2, GR_EXAMINATION_NAME2, GR_RESULT_DATE2, GR_UNIVERSITY_ID2, GR_UNIVERSITY_NAME2, GR_BOARD_OTHER2, GR_GRADE2, GR_DIVISION2, GR_CGP2, GR_MAJOR_COURSE_WORKS2, GR_EXAMINATION_ID3, GR_EXAMINATION_NAME3, GR_RESULT_DATE3, GR_UNIVERSITY_ID3, GR_UNIVERSITY_NAME3, GR_BOARD_OTHER3, GR_GRADE3, GR_DIVISION3, GR_CGP3, GR_MAJOR_COURSE_WORKS3, GR_EXAMINATION_ID4, GR_EXAMINATION_NAME4, GR_RESULT_DATE4, GR_UNIVERSITY_ID4, GR_UNIVERSITY_NAME4, GR_BOARD_OTHER4, GR_GRADE4, GR_DIVISION4, GR_CGP4, GR_MAJOR_COURSE_WORKS4, GR_EXAMINATION_ID5, GR_EXAMINATION_NAME5, GR_RESULT_DATE5, GR_UNIVERSITY_ID5, GR_UNIVERSITY_NAME5, GR_BOARD_OTHER5, GR_GRADE5, GR_DIVISION5, GR_CGP5, GR_MAJOR_COURSE_WORKS5, GR_EXAMINATION_ID6, GR_EXAMINATION_NAME6, GR_RESULT_DATE6, GR_UNIVERSITY_ID6, GR_UNIVERSITY_NAME6, GR_BOARD_OTHER6, GR_GRADE6, GR_DIVISION6, GR_CGP6, GR_MAJOR_COURSE_WORKS6, GR_EXAMINATION_ID7, GR_EXAMINATION_NAME7, GR_RESULT_DATE7, GR_UNIVERSITY_ID7, GR_UNIVERSITY_NAME7, GR_BOARD_OTHER7, GR_GRADE7, GR_DIVISION7, GR_CGP7, GR_MAJOR_COURSE_WORKS7, GR_COURSE_NAME1, GR_INSTITUTION_NAME1, GR_INSTITUTE_LOCATION1, GR_COURSE_GRADE1, GR_WEEK1, GR_COURSE_FROM_DATE1, GR_COURSE_TO_DATE1, GR_TRAINING_NATURE1, GR_COURSE_NAME2, GR_INSTITUTION_NAME2, GR_INSTITUTE_LOCATION2, GR_COURSE_GRADE2, GR_WEEK2, GR_COURSE_FROM_DATE2, GR_COURSE_TO_DATE2, GR_TRAINING_NATURE2, GR_COURSE_NAME3, GR_INSTITUTION_NAME3, GR_INSTITUTE_LOCATION3, GR_COURSE_GRADE3, GR_WEEK3, GR_COURSE_FROM_DATE3, GR_COURSE_TO_DATE3, GR_TRAINING_NATURE3, GR_COURSE_NAME4, GR_INSTITUTION_NAME4, GR_INSTITUTE_LOCATION4, GR_COURSE_GRADE4, GR_WEEK4, GR_COURSE_FROM_DATE4, GR_COURSE_TO_DATE4, GR_TRAINING_NATURE4, GR_COURSE_NAME5, GR_INSTITUTION_NAME5, GR_INSTITUTE_LOCATION5, GR_COURSE_GRADE5, GR_WEEK5, GR_COURSE_FROM_DATE5, GR_COURSE_TO_DATE5, GR_TRAINING_NATURE5, GR_TITLE1, GR_CONFERENCE1, GR_PUBLISHER1, GR_PUBLISHER_DATE1, GR_REQ_ADVERTISEMENT1, GR_TITLE2, GR_CONFERENCE2, GR_PUBLISHER2, GR_PUBLISHER_DATE2, GR_REQ_ADVERTISEMENT2, GR_TITLE3, GR_CONFERENCE3, GR_PUBLISHER3, GR_PUBLISHER_DATE3, GR_REQ_ADVERTISEMENT3, GR_TITLE4, GR_CONFERENCE4, GR_PUBLISHER4, GR_PUBLISHER_DATE4, GR_REQ_ADVERTISEMENT4, GR_TITLE5, GR_CONFERENCE5, GR_PUBLISHER5, GR_PUBLISHER_DATE5, GR_REQ_ADVERTISEMENT5, GR_POST_NAME1, GR_BS1, GR_ORGANIZATION_NAME1, GR_EXP_FROM_DATE1, GR_EXP_TO_DATE1, GR_JOB_STATUS1, GR_JOB_NATURE1, GR_MAIN_DUTIES1, GR_POST_NAME2, GR_BS2, GR_ORGANIZATION_NAME2, GR_EXP_FROM_DATE2, GR_EXP_TO_DATE2, GR_JOB_STATUS2, GR_JOB_NATURE2, GR_MAIN_DUTIES2, GR_POST_NAME3, GR_BS3, GR_ORGANIZATION_NAME3, GR_EXP_FROM_DATE3, GR_EXP_TO_DATE3, GR_JOB_STATUS3, GR_JOB_NATURE3, GR_MAIN_DUTIES3, GR_POST_NAME4, GR_BS4, GR_ORGANIZATION_NAME4, GR_EXP_FROM_DATE4, GR_EXP_TO_DATE4, GR_JOB_STATUS4, GR_JOB_NATURE4, GR_MAIN_DUTIES4, GR_POST_NAME5, GR_BS5, GR_ORGANIZATION_NAME5, GR_EXP_FROM_DATE5, GR_EXP_TO_DATE5, GR_JOB_STATUS5, GR_JOB_NATURE5, GR_MAIN_DUTIES5, GR_POST_NAME6, GR_BS6, GR_ORGANIZATION_NAME6, GR_EXP_FROM_DATE6, GR_EXP_TO_DATE6, GR_JOB_STATUS6, GR_JOB_NATURE6, GR_MAIN_DUTIES6, GR_POST_NAME7, GR_BS7, GR_ORGANIZATION_NAME7, GR_EXP_FROM_DATE7, GR_EXP_TO_DATE7, GR_JOB_STATUS7, GR_JOB_NATURE7, GR_MAIN_DUTIES7, GR_POST_NAME8, GR_BS8, GR_ORGANIZATION_NAME8, GR_EXP_FROM_DATE8, GR_EXP_TO_DATE8, GR_JOB_STATUS8, GR_JOB_NATURE8, GR_MAIN_DUTIES8, GR_POST_NAME9, GR_BS9, GR_ORGANIZATION_NAME9, GR_EXP_FROM_DATE9, GR_EXP_TO_DATE9, GR_JOB_STATUS9, GR_JOB_NATURE9, GR_MAIN_DUTIES9, GR_POST_NAME10, GR_BS10, GR_ORGANIZATION_NAME10, GR_EXP_FROM_DATE10, GR_EXP_TO_DATE10, GR_JOB_STATUS10, GR_JOB_NATURE10, GR_MAIN_DUTIES10 ) VALUES( SQ_GR_LOGIN_INFORMATION.NEXTVAL, :GR_APPLICANT_NAME, :GR_FATHER_NAME, to_date(:GR_DOB,'dd-mm-yyyy'), :GR_NEW_NIC, :GR_GENDER, :GR_RELIGION, :GR_POSTAL_ADD1||', '||:GR_POSTAL_ADD2, :GR_PARMANENT_ADD1||', '||:GR_PARMANENT_ADD2, :GR_APPLICANT_EMAIL, :GR_APPLICANT_PHONE_OFF, :GR_APPLICANT_PHONE_RES, :GR_APPLICANT_FAX, :GR_APP_MOBILE, :GR_AGEREX1, :GR_RELAX_YEARS, :GR_DOMICILE, :GR_DISTRICT_DOMICILE, :GR_DISABILITY, :GR_HELPER, :GR_AMOUNT, :GR_JOB_ID, :GR_BANK_NAME, to_date(:DATE_APPLIED,'dd-mm-yyyy hh:mi:ss AM'), :GR_CENTER_ID, :GR_CENTER_NAME, :GR_INTERVIEW_ID, :GR_INTERVIEW_NAME, :GR_EXAMINATION_ID1, :GR_EXAMINATION_NAME1, to_date(:GR_RESULT_DATE1,'dd-mm-yyyy'), :GR_UNIVERSITY_ID1, :GR_UNIVERSITY_NAME1, :GR_BOARD_OTHER1, :GR_GRADE1, :GR_DIVISION1, :GR_CGP1, :GR_MAJOR_COURSE_WORKS1, :GR_EXAMINATION_ID2, :GR_EXAMINATION_NAME2, to_date(:GR_RESULT_DATE2,'dd-mm-yyyy'), :GR_UNIVERSITY_ID2, :GR_UNIVERSITY_NAME2, :GR_BOARD_OTHER2, :GR_GRADE2, :GR_DIVISION2, :GR_CGP2, :GR_MAJOR_COURSE_WORKS2, :GR_EXAMINATION_ID3, :GR_EXAMINATION_NAME3, to_date(:GR_RESULT_DATE3,'dd-mm-yyyy'), :GR_UNIVERSITY_ID3, :GR_UNIVERSITY_NAME3, :GR_BOARD_OTHER3, :GR_GRADE3, :GR_DIVISION3, :GR_CGP3, :GR_MAJOR_COURSE_WORKS3, :GR_EXAMINATION_ID4, :GR_EXAMINATION_NAME4, to_date(:GR_RESULT_DATE4,'dd-mm-yyyy'), :GR_UNIVERSITY_ID4, :GR_UNIVERSITY_NAME4, :GR_BOARD_OTHER4, :GR_GRADE4, :GR_DIVISION4, :GR_CGP4, :GR_MAJOR_COURSE_WORKS4, :GR_EXAMINATION_ID5, :GR_EXAMINATION_NAME5, to_date(:GR_RESULT_DATE5,'dd-mm-yyyy'), :GR_UNIVERSITY_ID5, :GR_UNIVERSITY_NAME5, :GR_BOARD_OTHER5, :GR_GRADE5, :GR_DIVISION5, :GR_CGP5, :GR_MAJOR_COURSE_WORKS5, :GR_EXAMINATION_ID6, :GR_EXAMINATION_NAME6, to_date(:GR_RESULT_DATE6,'dd-mm-yyyy'), :GR_UNIVERSITY_ID6, :GR_UNIVERSITY_NAME6, :GR_BOARD_OTHER6, :GR_GRADE6, :GR_DIVISION6, :GR_CGP6, :GR_MAJOR_COURSE_WORKS6, :GR_EXAMINATION_ID7, :GR_EXAMINATION_NAME7, to_date(:GR_RESULT_DATE7,'dd-mm-yyyy'), :GR_UNIVERSITY_ID7, :GR_UNIVERSITY_NAME7, :GR_BOARD_OTHER7, :GR_GRADE7, :GR_DIVISION7, :GR_CGP7, :GR_MAJOR_COURSE_WORKS7, :GR_COURSE_NAME1, :GR_INSTITUTION_NAME1, :GR_INSTITUTE_LOCATION1, :GR_COURSE_GRADE1, :GR_WEEK1, to_date(:GR_COURSE_FROM_DATE1,'dd-mm-yyyy'), to_date(:GR_COURSE_TO_DATE1,'dd-mm-yyyy'), :GR_TRAINING_NATURE1, :GR_COURSE_NAME2, :GR_INSTITUTION_NAME2, :GR_INSTITUTE_LOCATION2, :GR_COURSE_GRADE2, :GR_WEEK2, to_date(:GR_COURSE_FROM_DATE2,'dd-mm-yyyy'), to_date(:GR_COURSE_TO_DATE2,'dd-mm-yyyy'), :GR_TRAINING_NATURE2, :GR_COURSE_NAME3, :GR_INSTITUTION_NAME3, :GR_INSTITUTE_LOCATION3, :GR_COURSE_GRADE3, :GR_WEEK3, to_date(:GR_COURSE_FROM_DATE3,'dd-mm-yyyy'), to_date(:GR_COURSE_TO_DATE3,'dd-mm-yyyy'), :GR_TRAINING_NATURE3, :GR_COURSE_NAME4, :GR_INSTITUTION_NAME4, :GR_INSTITUTE_LOCATION4, :GR_COURSE_GRADE4, :GR_WEEK4, to_date(:GR_COURSE_FROM_DATE4,'dd-mm-yyyy'), to_date(:GR_COURSE_TO_DATE4,'dd-mm-yyyy'), :GR_TRAINING_NATURE4, :GR_COURSE_NAME5, :GR_INSTITUTION_NAME5, :GR_INSTITUTE_LOCATION5, :GR_COURSE_GRADE5, :GR_WEEK5, to_date(:GR_COURSE_FROM_DATE5,'dd-mm-yyyy'), to_date(:GR_COURSE_TO_DATE5,'dd-mm-yyyy'), :GR_TRAINING_NATURE5, :GR_TITLE1, :GR_CONFERENCE1, :GR_PUBLISHER1, to_date(:GR_PUBLISHER_DATE1,'dd-mm-yyyy'), :GR_REQ_ADVERTISEMENT1, :GR_TITLE2, :GR_CONFERENCE2, :GR_PUBLISHER2, to_date(:GR_PUBLISHER_DATE2,'dd-mm-yyyy'), :GR_REQ_ADVERTISEMENT2, :GR_TITLE3, :GR_CONFERENCE3, :GR_PUBLISHER3, to_date(:GR_PUBLISHER_DATE3,'dd-mm-yyyy'), :GR_REQ_ADVERTISEMENT3, :GR_TITLE4, :GR_CONFERENCE4, :GR_PUBLISHER4, to_date(:GR_PUBLISHER_DATE4,'dd-mm-yyyy'), :GR_REQ_ADVERTISEMENT4, :GR_TITLE5, :GR_CONFERENCE5, :GR_PUBLISHER5, to_date(:GR_PUBLISHER_DATE5,'dd-mm-yyyy'), :GR_REQ_ADVERTISEMENT5, :GR_POST_NAME1, :GR_BS1, :GR_ORGANIZATION_NAME1, to_date(:GR_EXP_FROM_DATE1,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE1,'dd-mm-yyyy'), :GR_JOB_STATUS1, :GR_JOB_NATURE1, :GR_MAIN_DUTIES1, :GR_POST_NAME2, :GR_BS2, :GR_ORGANIZATION_NAME2, to_date(:GR_EXP_FROM_DATE2,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE2,'dd-mm-yyyy'), :GR_JOB_STATUS2, :GR_JOB_NATURE2, :GR_MAIN_DUTIES2, :GR_POST_NAME3, :GR_BS3, :GR_ORGANIZATION_NAME3, to_date(:GR_EXP_FROM_DATE3,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE3,'dd-mm-yyyy'), :GR_JOB_STATUS3, :GR_JOB_NATURE3, :GR_MAIN_DUTIES3, :GR_POST_NAME4, :GR_BS4, :GR_ORGANIZATION_NAME4, to_date(:GR_EXP_FROM_DATE4,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE4,'dd-mm-yyyy'), :GR_JOB_STATUS4, :GR_JOB_NATURE4, :GR_MAIN_DUTIES4, :GR_POST_NAME5, :GR_BS5, :GR_ORGANIZATION_NAME5, to_date(:GR_EXP_FROM_DATE5,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE5,'dd-mm-yyyy'), :GR_JOB_STATUS5, :GR_JOB_NATURE5, :GR_MAIN_DUTIES5, :GR_POST_NAME6, :GR_BS6, :GR_ORGANIZATION_NAME6, to_date(:GR_EXP_FROM_DATE6,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE6,'dd-mm-yyyy'), :GR_JOB_STATUS6, :GR_JOB_NATURE6, :GR_MAIN_DUTIES6, :GR_POST_NAME7, :GR_BS7, :GR_ORGANIZATION_NAME7, to_date(:GR_EXP_FROM_DATE7,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE7,'dd-mm-yyyy'), :GR_JOB_STATUS7, :GR_JOB_NATURE7, :GR_MAIN_DUTIES7, :GR_POST_NAME8, :GR_BS8, :GR_ORGANIZATION_NAME8, to_date(:GR_EXP_FROM_DATE8,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE8,'dd-mm-yyyy'), :GR_JOB_STATUS8, :GR_JOB_NATURE8, :GR_MAIN_DUTIES8, :GR_POST_NAME9, :GR_BS9, :GR_ORGANIZATION_NAME9, to_date(:GR_EXP_FROM_DATE9,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE9,'dd-mm-yyyy'), :GR_JOB_STATUS9, :GR_JOB_NATURE9, :GR_MAIN_DUTIES9, :GR_POST_NAME10, :GR_BS10, :GR_ORGANIZATION_NAME10, to_date(:GR_EXP_FROM_DATE10,'dd-mm-yyyy'), to_date(:GR_EXP_TO_DATE10,'dd-mm-yyyy'), :GR_JOB_STATUS10, :GR_JOB_NATURE10, :GR_MAIN_DUTIES10 )"; $stid = ociparse($conn, $sql); //$mobile_num=92+str_replace(substr($data->gr_mobile,strpos($data->gr_mobile,'3')),'-',''); //echo $data->gr_helper."----".$data->gr_disability; $mobile_num='92'.str_replace('-','',substr($data->gr_mobile,strpos($data->gr_mobile,'3'))); $current_date=date('d-m-Y h:i:s A'); //var_dump($data);exit; //print_r($data);exit; //echo "---".$data->gr_education[0]->degree_text; exit; ocibindbyname($stid, ':GR_APPLICANT_NAME', $data->gr_applicant_name); ocibindbyname($stid, ':GR_FATHER_NAME', $data->gr_father_name); ocibindbyname($stid, ':GR_DOB', $data->gr_dob); ocibindbyname($stid, ':GR_NEW_NIC', $data->gr_cnic); ocibindbyname($stid, ':GR_GENDER', $data->gr_gender); ocibindbyname($stid, ':GR_RELIGION', $data->gr_religion); ocibindbyname($stid, ':GR_POSTAL_ADD1', $data->gr_postal_adress1); ocibindbyname($stid, ':GR_POSTAL_ADD2', $data->gr_postal_adress2); ocibindbyname($stid, ':GR_PARMANENT_ADD1', $data->gr_permanent_adress1); ocibindbyname($stid, ':GR_PARMANENT_ADD2', $data->gr_permanent_adress2); ocibindbyname($stid, ':GR_APPLICANT_EMAIL', $data->gr_email); ocibindbyname($stid, ':GR_APPLICANT_PHONE_OFF', $data->gr_phone_off); ocibindbyname($stid, ':GR_APPLICANT_PHONE_RES', $data->gr_phone_res); ocibindbyname($stid, ':GR_APPLICANT_FAX', $data->gr_fax); ocibindbyname($stid, ':GR_APP_MOBILE', $mobile_num); ocibindbyname($stid, ':GR_AGEREX1', $data->gr_age_relaxation); ocibindbyname($stid, ':GR_RELAX_YEARS', $data->gr_relaxation_years); ocibindbyname($stid, ':GR_DOMICILE', $data->gr_domicile); ocibindbyname($stid, ':GR_DISTRICT_DOMICILE', $data->gr_district); ocibindbyname($stid, ':GR_DISABILITY', $data->gr_disability); ocibindbyname($stid, ':GR_HELPER', $data->gr_helper); ocibindbyname($stid, ':GR_AMOUNT', $data->gr_TR_Amount); ocibindbyname($stid, ':GR_JOB_ID', $data->gr_job_id); ocibindbyname($stid, ':GR_BANK_NAME', $data->gr_TR_Bank); ocibindbyname($stid, ':DATE_APPLIED', $current_date); ocibindbyname($stid, ':GR_CENTER_ID', $data->gr_test_centre); ocibindbyname($stid, ':GR_CENTER_NAME', $data->gr_test_centre_name); ocibindbyname($stid, ':GR_INTERVIEW_ID', $data->gr_interview_centre); ocibindbyname($stid, ':GR_INTERVIEW_NAME', $data->gr_interview_centre_name); ocibindbyname($stid, ':GR_EXAMINATION_ID1', $data->gr_education[0]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME1', $data->gr_education[0]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE1', $data->gr_education[0]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID1', $data->gr_education[0]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME1', $data->gr_education[0]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER1', $data->gr_education[0]->other_institute); ocibindbyname($stid, ':GR_GRADE1', $data->gr_education[0]->grade); ocibindbyname($stid, ':GR_DIVISION1', $data->gr_education[0]->division); ocibindbyname($stid, ':GR_CGP1', $data->gr_education[0]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS1', $data->gr_education[0]->major_subjects); ocibindbyname($stid, ':GR_EXAMINATION_ID2', $data->gr_education[1]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME2', $data->gr_education[1]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE2', $data->gr_education[1]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID2', $data->gr_education[1]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME2', $data->gr_education[1]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER2', $data->gr_education[1]->other_institute); ocibindbyname($stid, ':GR_GRADE2', $data->gr_education[1]->grade); ocibindbyname($stid, ':GR_DIVISION2', $data->gr_education[1]->division); ocibindbyname($stid, ':GR_CGP2', $data->gr_education[1]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS2', $data->gr_education[1]->major_subjects); ocibindbyname($stid, ':GR_EXAMINATION_ID3', $data->gr_education[2]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME3', $data->gr_education[2]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE3', $data->gr_education[2]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID3', $data->gr_education[2]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME3', $data->gr_education[2]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER3', $data->gr_education[2]->other_institute); ocibindbyname($stid, ':GR_GRADE3', $data->gr_education[2]->grade); ocibindbyname($stid, ':GR_DIVISION3', $data->gr_education[2]->division); ocibindbyname($stid, ':GR_CGP3', $data->gr_education[2]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS3', $data->gr_education[2]->major_subjects); ocibindbyname($stid, ':GR_EXAMINATION_ID4', $data->gr_education[3]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME4', $data->gr_education[3]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE4', $data->gr_education[3]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID4', $data->gr_education[3]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME4', $data->gr_education[3]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER4', $data->gr_education[3]->other_institute); ocibindbyname($stid, ':GR_GRADE4', $data->gr_education[3]->grade); ocibindbyname($stid, ':GR_DIVISION4', $data->gr_education[3]->division); ocibindbyname($stid, ':GR_CGP4', $data->gr_education[3]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS4', $data->gr_education[3]->major_subjects); ocibindbyname($stid, ':GR_EXAMINATION_ID5', $data->gr_education[4]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME5', $data->gr_education[4]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE5', $data->gr_education[4]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID5', $data->gr_education[4]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME5', $data->gr_education[4]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER5', $data->gr_education[4]->other_institute); ocibindbyname($stid, ':GR_GRADE5', $data->gr_education[4]->grade); ocibindbyname($stid, ':GR_DIVISION5', $data->gr_education[4]->division); ocibindbyname($stid, ':GR_CGP5', $data->gr_education[4]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS5', $data->gr_education[4]->major_subjects); ocibindbyname($stid, ':GR_EXAMINATION_ID6', $data->gr_education[5]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME6', $data->gr_education[5]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE6', $data->gr_education[5]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID6', $data->gr_education[5]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME6', $data->gr_education[5]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER6', $data->gr_education[5]->other_institute); ocibindbyname($stid, ':GR_GRADE6', $data->gr_education[5]->grade); ocibindbyname($stid, ':GR_DIVISION6', $data->gr_education[5]->division); ocibindbyname($stid, ':GR_CGP6', $data->gr_education[5]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS6', $data->gr_education[5]->major_subjects); ocibindbyname($stid, ':GR_EXAMINATION_ID7', $data->gr_education[6]->degree); ocibindbyname($stid, ':GR_EXAMINATION_NAME7', $data->gr_education[6]->degree_name); ocibindbyname($stid, ':GR_RESULT_DATE7', $data->gr_education[6]->result_date); ocibindbyname($stid, ':GR_UNIVERSITY_ID7', $data->gr_education[6]->institute); ocibindbyname($stid, ':GR_UNIVERSITY_NAME7', $data->gr_education[6]->institute_name); ocibindbyname($stid, ':GR_BOARD_OTHER7', $data->gr_education[6]->other_institute); ocibindbyname($stid, ':GR_GRADE7', $data->gr_education[6]->grade); ocibindbyname($stid, ':GR_DIVISION7', $data->gr_education[6]->division); ocibindbyname($stid, ':GR_CGP7', $data->gr_education[6]->cgpa); ocibindbyname($stid, ':GR_MAJOR_COURSE_WORKS7', $data->gr_education[6]->major_subjects); ocibindbyname($stid, ':GR_COURSE_NAME1', $data->gr_course[0]->course_name); ocibindbyname($stid, ':GR_INSTITUTION_NAME1', $data->gr_course[0]->institute_name); ocibindbyname($stid, ':GR_INSTITUTE_LOCATION1', $data->gr_course[0]->institute_loc); ocibindbyname($stid, ':GR_COURSE_GRADE1', $data->gr_course[0]->course_grade); ocibindbyname($stid, ':GR_WEEK1', $data->gr_course[0]->course_week); ocibindbyname($stid, ':GR_COURSE_FROM_DATE1', $data->gr_course[0]->course_sdate); ocibindbyname($stid, ':GR_COURSE_TO_DATE1', $data->gr_course[0]->course_edate); ocibindbyname($stid, ':GR_TRAINING_NATURE1', $data->gr_course[0]->course_nature); ocibindbyname($stid, ':GR_COURSE_NAME2', $data->gr_course[1]->course_name); ocibindbyname($stid, ':GR_INSTITUTION_NAME2', $data->gr_course[1]->institute_name); ocibindbyname($stid, ':GR_INSTITUTE_LOCATION2', $data->gr_course[1]->institute_loc); ocibindbyname($stid, ':GR_COURSE_GRADE2', $data->gr_course[1]->course_grade); ocibindbyname($stid, ':GR_WEEK2', $data->gr_course[1]->course_week); ocibindbyname($stid, ':GR_COURSE_FROM_DATE2', $data->gr_course[1]->course_sdate); ocibindbyname($stid, ':GR_COURSE_TO_DATE2', $data->gr_course[1]->course_edate); ocibindbyname($stid, ':GR_TRAINING_NATURE2', $data->gr_course[1]->course_nature); ocibindbyname($stid, ':GR_COURSE_NAME3', $data->gr_course[2]->course_name); ocibindbyname($stid, ':GR_INSTITUTION_NAME3', $data->gr_course[2]->institute_name); ocibindbyname($stid, ':GR_INSTITUTE_LOCATION3', $data->gr_course[2]->institute_loc); ocibindbyname($stid, ':GR_COURSE_GRADE3', $data->gr_course[2]->course_grade); ocibindbyname($stid, ':GR_WEEK3', $data->gr_course[2]->course_week); ocibindbyname($stid, ':GR_COURSE_FROM_DATE3', $data->gr_course[2]->course_sdate); ocibindbyname($stid, ':GR_COURSE_TO_DATE3', $data->gr_course[2]->course_edate); ocibindbyname($stid, ':GR_TRAINING_NATURE3', $data->gr_course[2]->course_nature); ocibindbyname($stid, ':GR_COURSE_NAME4', $data->gr_course[3]->course_name); ocibindbyname($stid, ':GR_INSTITUTION_NAME4', $data->gr_course[3]->institute_name); ocibindbyname($stid, ':GR_INSTITUTE_LOCATION4', $data->gr_course[3]->institute_loc); ocibindbyname($stid, ':GR_COURSE_GRADE4', $data->gr_course[3]->course_grade); ocibindbyname($stid, ':GR_WEEK4', $data->gr_course[3]->course_week); ocibindbyname($stid, ':GR_COURSE_FROM_DATE4', $data->gr_course[3]->course_sdate); ocibindbyname($stid, ':GR_COURSE_TO_DATE4', $data->gr_course[3]->course_edate); ocibindbyname($stid, ':GR_TRAINING_NATURE4', $data->gr_course[3]->course_nature); ocibindbyname($stid, ':GR_COURSE_NAME5', $data->gr_course[4]->course_name); ocibindbyname($stid, ':GR_INSTITUTION_NAME5', $data->gr_course[4]->institute_name); ocibindbyname($stid, ':GR_INSTITUTE_LOCATION5', $data->gr_course[4]->institute_loc); ocibindbyname($stid, ':GR_COURSE_GRADE5', $data->gr_course[4]->course_grade); ocibindbyname($stid, ':GR_WEEK5', $data->gr_course[4]->course_week); ocibindbyname($stid, ':GR_COURSE_FROM_DATE5', $data->gr_course[4]->course_sdate); ocibindbyname($stid, ':GR_COURSE_TO_DATE5', $data->gr_course[4]->course_edate); ocibindbyname($stid, ':GR_TRAINING_NATURE5', $data->gr_course[4]->course_nature); ocibindbyname($stid, ':GR_TITLE1', $data->gr_research[0]->research_title); ocibindbyname($stid, ':GR_CONFERENCE1', $data->gr_research[0]->research_JC); ocibindbyname($stid, ':GR_PUBLISHER1', $data->gr_research[0]->research_pub); ocibindbyname($stid, ':GR_PUBLISHER_DATE1', $data->gr_research[0]->research_pdate); ocibindbyname($stid, ':GR_REQ_ADVERTISEMENT1', $data->gr_research[0]->research_required); ocibindbyname($stid, ':GR_TITLE2', $data->gr_research[1]->research_title); ocibindbyname($stid, ':GR_CONFERENCE2', $data->gr_research[1]->research_JC); ocibindbyname($stid, ':GR_PUBLISHER2', $data->gr_research[1]->research_pub); ocibindbyname($stid, ':GR_PUBLISHER_DATE2', $data->gr_research[1]->research_pdate); ocibindbyname($stid, ':GR_REQ_ADVERTISEMENT2', $data->gr_research[1]->research_required); ocibindbyname($stid, ':GR_TITLE3', $data->gr_research[2]->research_title); ocibindbyname($stid, ':GR_CONFERENCE3', $data->gr_research[2]->research_JC); ocibindbyname($stid, ':GR_PUBLISHER3', $data->gr_research[2]->research_pub); ocibindbyname($stid, ':GR_PUBLISHER_DATE3', $data->gr_research[2]->research_pdate); ocibindbyname($stid, ':GR_REQ_ADVERTISEMENT3', $data->gr_research[2]->research_required); ocibindbyname($stid, ':GR_TITLE4', $data->gr_research[3]->research_title); ocibindbyname($stid, ':GR_CONFERENCE4', $data->gr_research[3]->research_JC); ocibindbyname($stid, ':GR_PUBLISHER4', $data->gr_research[3]->research_pub); ocibindbyname($stid, ':GR_PUBLISHER_DATE4', $data->gr_research[3]->research_pdate); ocibindbyname($stid, ':GR_REQ_ADVERTISEMENT4', $data->gr_research[3]->research_required); ocibindbyname($stid, ':GR_TITLE5', $data->gr_research[4]->research_title); ocibindbyname($stid, ':GR_CONFERENCE5', $data->gr_research[4]->research_JC); ocibindbyname($stid, ':GR_PUBLISHER5', $data->gr_research[4]->research_pub); ocibindbyname($stid, ':GR_PUBLISHER_DATE5', $data->gr_research[4]->research_pdate); ocibindbyname($stid, ':GR_REQ_ADVERTISEMENT5', $data->gr_research[4]->research_required); ocibindbyname($stid, ':GR_POST_NAME1', $data->gr_experience[0]->experience_post); ocibindbyname($stid, ':GR_BS1', $data->gr_experience[0]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME1', $data->gr_experience[0]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE1', $data->gr_experience[0]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE1', $data->gr_experience[0]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS1', $data->gr_experience[0]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE1', $data->gr_experience[0]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES1', $data->gr_experience[0]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME2', $data->gr_experience[1]->experience_post); ocibindbyname($stid, ':GR_BS2', $data->gr_experience[1]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME2', $data->gr_experience[1]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE2', $data->gr_experience[1]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE2', $data->gr_experience[1]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS2', $data->gr_experience[1]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE2', $data->gr_experience[1]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES2', $data->gr_experience[1]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME3', $data->gr_experience[2]->experience_post); ocibindbyname($stid, ':GR_BS3', $data->gr_experience[2]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME3', $data->gr_experience[2]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE3', $data->gr_experience[2]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE3', $data->gr_experience[2]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS3', $data->gr_experience[2]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE3', $data->gr_experience[2]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES3', $data->gr_experience[2]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME4', $data->gr_experience[3]->experience_post); ocibindbyname($stid, ':GR_BS4', $data->gr_experience[3]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME4', $data->gr_experience[3]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE4', $data->gr_experience[3]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE4', $data->gr_experience[3]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS4', $data->gr_experience[3]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE4', $data->gr_experience[3]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES4', $data->gr_experience[3]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME5', $data->gr_experience[4]->experience_post); ocibindbyname($stid, ':GR_BS5', $data->gr_experience[4]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME5', $data->gr_experience[4]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE5', $data->gr_experience[4]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE5', $data->gr_experience[4]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS5', $data->gr_experience[4]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE5', $data->gr_experience[4]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES5', $data->gr_experience[4]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME6', $data->gr_experience[5]->experience_post); ocibindbyname($stid, ':GR_BS6', $data->gr_experience[5]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME6', $data->gr_experience[5]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE6', $data->gr_experience[5]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE6', $data->gr_experience[5]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS6', $data->gr_experience[5]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE6', $data->gr_experience[5]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES6', $data->gr_experience[5]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME7', $data->gr_experience[6]->experience_post); ocibindbyname($stid, ':GR_BS7', $data->gr_experience[6]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME7', $data->gr_experience[6]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE7', $data->gr_experience[6]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE7', $data->gr_experience[6]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS7', $data->gr_experience[6]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE7', $data->gr_experience[6]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES7', $data->gr_experience[6]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME8', $data->gr_experience[7]->experience_post); ocibindbyname($stid, ':GR_BS8', $data->gr_experience[7]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME8', $data->gr_experience[7]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE8', $data->gr_experience[7]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE8', $data->gr_experience[7]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS8', $data->gr_experience[7]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE8', $data->gr_experience[7]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES8', $data->gr_experience[7]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME9', $data->gr_experience[8]->experience_post); ocibindbyname($stid, ':GR_BS9', $data->gr_experience[8]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME9', $data->gr_experience[8]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE9', $data->gr_experience[8]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE9', $data->gr_experience[8]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS9', $data->gr_experience[8]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE9', $data->gr_experience[8]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES9', $data->gr_experience[8]->experience_duties); ocibindbyname($stid, ':GR_POST_NAME10', $data->gr_experience[9]->experience_post); ocibindbyname($stid, ':GR_BS10', $data->gr_experience[9]->experience_BS); ocibindbyname($stid, ':GR_ORGANIZATION_NAME10', $data->gr_experience[9]->experience_OMDD); ocibindbyname($stid, ':GR_EXP_FROM_DATE10', $data->gr_experience[9]->experience_fdate); ocibindbyname($stid, ':GR_EXP_TO_DATE10', $data->gr_experience[9]->experience_tdate); ocibindbyname($stid, ':GR_JOB_STATUS10', $data->gr_experience[9]->experience_status); ocibindbyname($stid, ':GR_JOB_NATURE10', $data->gr_experience[9]->experience_nature); ocibindbyname($stid, ':GR_MAIN_DUTIES10', $data->gr_experience[9]->experience_duties); $r = ociexecute($stid); if ($r) { return "1"; }else{ return OCIError(); } } ?>