Viewing file: curriculumStructure.php (2.71 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../include/class.mysqldb.php");
include("../include/config.inc.php");
if($_REQUEST["action"] == "insertCs"){
$sql = "INSERT INTO rg_CurriculumStructure VALUES ('" . $_REQUEST["csCurId"] . "','" . $_REQUEST["csCdId1"] . "','" . $_REQUEST["csCdId2"] . "','" . $_REQUEST["csSeq"] . "','" . $_REQUEST["csCreditTotal"] . "')";
$link->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 = "<button class='btn btn-primary btn-sm' data-toggle='modal' data-target='#editCs' data-id='" . $data->csCurId . "' data-id2='" . $data->csSeq . "'>Edit</button>";
$opt .= " <button class='btn btn-danger btn-sm' data-toggle='modal' data-target='#modalDelCs' data-id='" . $data->csCurId . "' data-id2='" . $data->csSeq . "'>Del</button>";
$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!!";
}
?>
|