query($sql);
echo "Insert Success!!";
}
if($_REQUEST["action"] == "deleteCrs"){
$sql = "DELETE FROM rg_Course WHERE crsId = '" . $_REQUEST["crsId"] . "'";
$link->query($sql);
echo "Data deleted.";
}
if($_REQUEST["action"] == "getCrsById"){
$sql = "SELECT * FROM rg_Course WHERE crsId = '".$_REQUEST["crsId"]."'";
$link->query($sql);
echo json_encode($link->getnext());
}
if($_REQUEST["action"] == "getCrsAll"){
$sql = "SELECT * FROM rg_Course";
$link->query($sql);
$i = 1;
while($data = $link->getnext()){
$opt = "";
$opt .= " ";
$json["data"][] = array("No"=>$i++,"crsCode"=>$data->crsCode,"crsCodeE"=>$data->crsCodeE,"crsName"=>$data->crsName,"crsNameE"=>$data->crsNameE,"crsUnit"=>$data->crsUnit, "opt"=>$opt);
}
echo json_encode($json);
}
if($_REQUEST["action"] == "updateCrs"){
$crsUnit = $_REQUEST["crsCreditTotal"]."(".$_REQUEST["crsCredit1"]."-".$_REQUEST["crsCredit2"]."-".$_REQUEST["crsPeriod3"].")";
$sql = "UPDATE rg_Course SET crsCode='" . $_REQUEST["crsCode"] . "', crsCodeE='" . $_REQUEST["crsCodeE"] . "',crsName='" . $_REQUEST["crsName"] . "', crsNameE='" . $_REQUEST["crsNameE"] . "', crsAbbr='" . $_REQUEST["crsAbbr"] . "', crsAbbrE='" . $_REQUEST["crsAbbrE"] . "', crsCreditTotal='" . $_REQUEST["crsCreditTotal"] . "', crsCredit1='" . $_REQUEST["crsCredit1"] . "', crsCredit2='" . $_REQUEST["crsCredit2"] . "', crsPeriod1='" . $_REQUEST["crsCredit1"] . "', crsPeriod2='" . $_REQUEST["crsCredit2"] . "', crsPeriod3='" . $_REQUEST["crsPeriod3"] . "', crsUnit='" . $crsUnit . "', crsCdId='" . $_REQUEST["crsCdId"] . "' WHERE crsId = '".$_REQUEST["crsId"]."'";
$link->query($sql);
echo "Update Success!!";
}
?>