query($sql);
echo "Insert Success";
}
if($_REQUEST["action"] == "deleteCm"){
$sql = "DELETE FROM rg_ProgramCourses WHERE pcrCsCurId = '" . $_REQUEST["pcrCsCurId"] . "' AND pcrCsCdId1 = '" . $_REQUEST["pcrCsCdId1"] . "' AND pcrCsCdId2 = '" . $_REQUEST["pcrCsCdId2"] . "' AND pcrCrsId = '" . $_REQUEST["pcrCrsId"] . "'";
$link->query($sql);
echo "Data deleted.";
}
if($_REQUEST["action"] == "getCmByCurId"){
$sql = "SELECT rcs.csCurId, rcs.csCdId1, rcs.csCdId2, 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 = "";
$json["data"][] = array("csSeq"=>$data->csSeq,"cdName1"=>$data->cdName1,"cdName2"=>$data->cdName2,"csCreditTotal"=>$data->csCreditTotal, "opt"=>$opt);
$sql = "SELECT * FROM rg_ProgramCourses rpc
LEFT JOIN rg_Course rc ON rpc.pcrCrsId = rc.crsId
WHERE rpc.pcrCsCurId = '".$data->csCurId."' AND rpc.pcrCsCdId1 = '".$data->csCdId1."' AND rpc.pcrCsCdId2 = '".$data->csCdId2."'";
//$res = mysql_query($sql);
$res = $mysqli->query($sql);
//while($rs = mysql_fetch_object($res)){
while($rs = $res->fetch_object()){
$opt = "";
$json["data"][] = array("csSeq"=>"","cdName1"=>"","cdName2"=>" ".$rs->crsCode." ".$rs->crsName." (".$rs->crsCreditTotal.")","csCreditTotal"=>"", "opt"=>$opt);
}
}
}
else {
$json["data"][] = array("csSeq"=>"ไม่พบข้อมูล","cdName1"=>"ไม่พบข้อมูล","cdName2"=>"ไม่พบข้อมูล","csCreditTotal"=>"ไม่พบข้อมูล", "opt"=>"ไม่พบข้อมูล");
}
echo json_encode($json);
}
?>