query($sql);
echo "Insert Success!!";
}
if($_REQUEST["action"] == "deleteCur"){
$sql = "DELETE FROM rg_Curriculum WHERE curId = '" . $_REQUEST["curId"] . "'";
$link->query($sql);
echo "Data deleted.";
}
if($_REQUEST["action"] == "getCurById"){
$sql = "SELECT * FROM rg_Curriculum WHERE curId = '".$_REQUEST["curId"]."'";
$link->query($sql);
echo json_encode($link->getnext());
}
if($_REQUEST["action"] == "getCurAll"){
$sql = "SELECT * FROM rg_Curriculum WHERE curStatus = 'Y'";
$link->query($sql);
$i = 1;
while($data = $link->getnext()){
$opt = "";
$opt .= " ";
$json["data"][] = array("No"=>$i++,"curName"=>$data->curName, "opt"=>$opt);
}
echo json_encode($json);
}
if($_REQUEST["action"] == "updateCur"){
$sql = "UPDATE rg_Curriculum SET curImproveY='" . $_REQUEST["curImproveY"] . "', curName='" . $_REQUEST["curNameT"] . "', curNameE='" . $_REQUEST["curNameE"] . "', curAbbr='" . $_REQUEST["curNameAbbrT"] . "', curAbbrE='" . $_REQUEST["curNameAbbrE"] . "', curDescription='" . $_REQUEST["curDescT"] . "', curDescriptionE='" . $_REQUEST["curDescE"] . "', curMinCredit='" . $_REQUEST["curMinCredit"] . "', curMinGPAX='" . $_REQUEST["curMinGPAX"] . "', curNumStudyY='" . $_REQUEST["curNumStudyY"] . "', curMaxStudyY='" . $_REQUEST["curMaxStudyY"] . "', curNumTmPerY='" . $_REQUEST["curNumTmPerY"] . "', curCcId='" . $_REQUEST["ccSelect"] . "', curEdgId='" . $_REQUEST["edgSelect"] . "', curElvId='" . $_REQUEST["elvSelect"] . "', curUpdateDate=now(), curUpdateUsLogin='jiroat' WHERE curId = '".$_REQUEST["curId"]."'";
$link->query($sql);
echo "Update Success!!";
}
?>