$value) { $$key = $value; } if($isValidForm) { $Start_Date = "$S_Date"; $End_Date = "$E_Date"; //$ex_activity = $ex_act; //echo $Start_Date."---".$End_Date."---".$exeid."---".$userId."---".$activity; exit; $updQuery = "update CSS_APP_EXTRA_CURRICULUM set CSS_FROM_DATE = to_timestamp('$Start_Date','DD-MM-YYYY') ,CSS_TO_DATE =to_timestamp('$End_Date','DD-MM-YYYY'), CSS_EXTRA_CURRICULUM_ACT = '$extra' where CSS_EXTRA_CURRICULUM_ID = $exeid and CSS_APPLICANT_ID = $userId"; if ($conn){ if($rs = OCIParse($conn,$updQuery)) OCIExecute($rs); header("Location: ./extra_curriculum.php"); exit(); } } } for($i = Date("Y"); $i >= (Date("Y") - 60); $i--) { $bldSelect = $bldSelect . "
$i
"; } $selQuery = "Select CSS_EXTRA_CURRICULUM_ID,CSS_FROM_DATE,CSS_FROM_DATE,to_char(CSS_TO_DATE,'MM') as edm, to_char(CSS_TO_DATE,'YYYY') as edy,to_char(CSS_TO_DATE,'DD') as edd,to_char(CSS_FROM_DATE,'MM') as stm, to_char(CSS_FROM_DATE,'YYYY') as sty,to_char(CSS_FROM_DATE,'DD') as std, CSS_TO_DATE, CSS_EXTRA_CURRICULUM_ACT from CSS_APP_EXTRA_CURRICULUM where CSS_APPLICANT_ID=$userId and CSS_EXTRA_CURRICULUM_ID = $exeid"; //echo $selQuery;exit; $rsExperience = OCIParse($conn,$selQuery); OCIExecute($rsExperience); if($rsExperience) { while (OCIFetchInto($rsExperience,$arrExperience,OCI_ASSOC)) { $exid = $arrExperience["CSS_EXTRA_CURRICULUM_ID"]; $activity = $arrExperience["CSS_EXTRA_CURRICULUM_ACT"]; $from_date = $arrExperience["CSS_FROM_DATE"]; $edy = $arrExperience["EDY"]; $edm = $arrExperience["EDM"]; $edd = $arrExperience["EDD"]; $stm = $arrExperience["STM"]; $sty = $arrExperience["STY"]; $std = $arrExperience["STD"]; } // echo $sty."-----".$from_date; exit; $S_Date = $std."-".$stm."-".$sty; $E_Date = $edd."-".$edm."-".$edy; //$ex_act = $activity; //echo $St_Date; echo $Et_Date; //echo $exid; echo $activity;exit; } ?>
:: Edit Extra Curriculum Activities
Start Date
*
(DD-MM-YYYY)
End Date
*
(DD-MM-YYYY)
Extra Curricular Activities/ Sports/ Hobbies