$value) { $$key = $value; } if($isValidForm) { //$aid =1; $P_Date=explode("-",$P_Date); $P_Date = "$P_Date[0]-$P_Date[1]-$P_Date[2]"; // echo $P_Date; exit; if ($Check=='on') $Check='1'; else $Check='0'; $updQuery = "update CSS_RESEARCH_PUB_DETAILS set CSS_TITLE = '$Title', CSS_CONFERENCE = '$Journal' ,CSS_PUBLISHER = '$Publisher' ,CSS_PUBLISHER_DATE = to_timestamp('$P_Date','DD-MM-YYYY'),CSS_REQ_ADVERTISEMENT='$Check' where CSS_RESEARCH_ID = $reid and CSS_APPLICANT_ID = $userId"; if ($conn){ if($rs = OCIParse($conn,$updQuery)) OCIExecute($rs); header("Location: ./research.php"); exit(); } } } $reid = $_GET['eid']; //for($i = Date("Y"); $i >= (Date("Y") - 60); $i--) { // $bldSelect = $bldSelect . "
$i
"; //} $selQuery = "Select CSS_RESEARCH_ID,CSS_TITLE,CSS_CONFERENCE,CSS_PUBLISHER, to_char(CSS_PUBLISHER_DATE,'MM') as ptm, to_char(CSS_PUBLISHER_DATE,'YYYY') as pty,to_char(CSS_PUBLISHER_DATE,'DD') as ptd,CSS_REQ_ADVERTISEMENT from CSS_RESEARCH_PUB_DETAILS where CSS_APPLICANT_ID=$userId and CSS_RESEARCH_ID = $reid"; $rsResearch = OCIParse($conn,$selQuery); OCIExecute($rsResearch); if($rsResearch) { while (OCIFetchInto($rsResearch,$arrResearch,OCI_ASSOC)) { $rseid = $arrResearch["CSS_RESEARCH_ID"]; $title = $arrResearch["CSS_TITLE"]; $conf = $arrResearch["CSS_CONFERENCE"]; $pub = $arrResearch["CSS_PUBLISHER"]; $adv = $arrResearch["CSS_REQ_ADVERTISEMENT"]; $pty = $arrResearch["PTY"]; $ptm = $arrResearch["PTM"]; $ptd = $arrResearch["PTD"]; } $P_Date = $ptd."-".$ptm."-".$pty; } ?>
Edit Research
Title
*
Journal / Conferences
Publisher
Publication Date
*
Required in Advertisement