query($sql);
echo "Insert Success!!";
}
if($_REQUEST["action"] == "deleteCs"){
$sql = "DELETE FROM rg_CurriculumStructure WHERE csCurId = '" . $_REQUEST["csCurId"] . "' AND csSeq = '" . $_REQUEST["csSeq"] . "'";
$link->query($sql);
echo "Data deleted.";
}
if($_REQUEST["action"] == "getCsByCurId"){
$sql = "SELECT rcs.csCurId, rcs.csSeq, rcs.csCreditTotal, rcd1.cdName as cdName1, rcd2.cdName as cdName2 FROM rg_CurriculumStructure rcs
INNER JOIN rg_Condition rcd1 ON rcd1.cdId = rcs.csCdId1
INNER JOIN rg_Condition rcd2 ON rcd2.cdId = rcs.csCdId2
WHERE rcs.csCurId = '".$_REQUEST["curId"]."'
ORDER BY rcs.csSeq";
$link->query($sql);
$i = 1;
//echo $sql;
if($link->num_rows()){
while($data = $link->getnext()){
$opt = "";
$opt .= " ";
$json["data"][] = array("csSeq"=>$data->csSeq,"cdName1"=>$data->cdName1,"cdName2"=>$data->cdName2,"csCreditTotal"=>$data->csCreditTotal, "opt"=>$opt);
}
}
else {
$json["data"][] = array("csSeq"=>"ไม่พบข้อมูล","cdName1"=>"ไม่พบข้อมูล","cdName2"=>"ไม่พบข้อมูล","csCreditTotal"=>"ไม่พบข้อมูล", "opt"=>"ไม่พบข้อมูล");
}
echo json_encode($json);
}
if($_REQUEST["action"] == "getCsByCurIdSeq"){
$sql = "SELECT * FROM rg_CurriculumStructure WHERE csCurId = '".$_REQUEST["csCurId"]."' AND csSeq = '".$_REQUEST["csSeq"]."'";
$link->query($sql);
echo json_encode($link->getnext());
}
if($_REQUEST["action"] == "updateCs"){
$sql = "UPDATE rg_CurriculumStructure SET csCurId = '" . $_REQUEST["csCurId"] . "', csCdId1 = '" . $_REQUEST["csCdId1-edit"] . "', csCdId2 = '" . $_REQUEST["csCdId2-edit"] . "', csSeq ='" . $_REQUEST["csSeq"] . "', csCreditTotal = '" . $_REQUEST["csCreditTotal"] . "' WHERE csCurId = '".$_REQUEST["csCurId"]."' AND csSeq = '".$_REQUEST["csSeq"]."'";
$link->query($sql);
echo "Update Success!!";
}
?>