Viewing file: curriculum.php (2.7 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"] == "insertCur"){
$sql = "INSERT INTO rg_Curriculum VALUES ('','" . $_REQUEST["curImproveY"] . "','" . $_REQUEST["curNameT"] . "','" . $_REQUEST["curNameE"] . "','" . $_REQUEST["curNameAbbrT"] . "','" . $_REQUEST["curNameAbbrE"] . "','" . $_REQUEST["curDescT"] . "','" . $_REQUEST["curDescE"] . "','" . $_REQUEST["curMinCredit"] . "','" . $_REQUEST["curMinGPAX"] . "','" . $_REQUEST["curNumStudyY"] . "','" . $_REQUEST["curMaxStudyY"] . "','" . $_REQUEST["curNumTmPerY"] . "','Y','" . $_REQUEST["ccSelect"] . "','" . $_REQUEST["edgSelect"] . "','" . $_REQUEST["elvSelect"] . "','1',now(),'reg-tools',now(),'reg-tools')";
$link->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 = "<button class='btn btn-primary btn-sm' data-toggle='modal' data-target='#editCurriculum' data-id='" . $data->curId . "'>Edit</button>";
$opt .= " <button class='btn btn-danger btn-sm' data-toggle='modal' data-target='#modalDel' data-id='" . $data->curId . "'>Del</button>";
$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!!";
}
?>
|