$value) { $$key = $value; } if($isValidForm) { //$aid =1; $S_Date=explode("-",$S_Date); $E_Date=explode("-",$E_Date); $S_Date = "$S_Date[0]-$S_Date[1]-$S_Date[2]"; $E_Date = "$E_Date[0]-$E_Date[1]-$E_Date[2]"; //echo $E_Date,$S_Date; exit; $updQuery = "update CSS_COURCE_TRAINING_DETAIL set CSS_COURSE_NAME = '$Course_Name', CSS_INSTITUTION_NAME = '$Ins_Name' ,CSS_INSTITUTE_LOCATION = '$Ins_Loc' , CSS_GRADE = '$Grade', CSS_WEEK = '$Weeks' , CSS_FROM_DATE = to_timestamp('$S_Date','DD-MM-YYYY') ,CSS_TO_DATE =to_timestamp('$E_Date','DD-MM-YYYY') where CSS_COURCE_TRANINING_ID = $courseid and CSS_APPLICANT_ID = $userId"; if ($conn){ if($rs = OCIParse($conn,$updQuery)) OCIExecute($rs); header("Location: ./course.php"); exit(); } } } $courseid = $_GET['eid']; for($i = Date("Y"); $i >= (Date("Y") - 60); $i--) { $bldSelect = $bldSelect . ""; } $selQuery = "Select CSS_COURCE_TRANINING_ID,CSS_COURSE_NAME,CSS_INSTITUTION_NAME,CSS_INSTITUTE_LOCATION,CSS_GRADE, CSS_WEEK,to_char(CSS_FROM_DATE,'MM') as stm, to_char(CSS_FROM_DATE,'YYYY') as sty,to_char(CSS_FROM_DATE,'DD') as std,to_char(CSS_FROM_DATE,'MM') as stm, to_char(CSS_TO_DATE,'YYYY') as edy,to_char(CSS_TO_DATE,'MM') as edm,to_char(CSS_TO_DATE,'DD') as edd from CSS_COURCE_TRAINING_DETAIL where CSS_APPLICANT_ID=$userId and CSS_COURCE_TRANINING_ID = $courseid"; $rsExperience = OCIParse($conn,$selQuery); OCIExecute($rsExperience); if($rsExperience) { while (OCIFetchInto($rsExperience,$arrExperience,OCI_ASSOC)) { $courseid = $arrExperience["CSS_COURCE_TRANINING_ID"]; $name = $arrExperience["CSS_COURSE_NAME"]; $institution = $arrExperience["CSS_INSTITUTION_NAME"]; $location = $arrExperience["CSS_INSTITUTE_LOCATION"]; $grade = $arrExperience["CSS_GRADE"]; $week = $arrExperience["CSS_WEEK"]; $edy = $arrExperience["EDY"]; $edm = $arrExperience["EDM"]; $edd = $arrExperience["EDD"]; $stm = $arrExperience["STM"]; $sty = $arrExperience["STY"]; $std = $arrExperience["STD"]; } $S_Date = $std."-".$stm."-".$sty; $E_Date = $edd."-".$edm."-".$edy; //echo $S_Date; echo $E_Date; exit; } ?>