Viewing file: course.php (2.85 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"] == "insertCrs"){
$crsUnit = $_REQUEST["crsCreditTotal"] . "(" . $_REQUEST["crsCredit1"] . "-" . $_REQUEST["crsCredit2"] . "-" . $_REQUEST["crsPeriod3"] . ")";
$sql = "INSERT INTO rg_Course VALUES ('','" . $_REQUEST["crsCode"] . "','" . $_REQUEST["crsCodeE"] . "','" . $_REQUEST["crsName"] . "','" . $_REQUEST["crsNameE"] . "','" . $_REQUEST["crsAbbr"] . "','" . $_REQUEST["crsAbbrE"] . "','','','" . $_REQUEST["crsCreditTotal"] . "','" . $_REQUEST["crsCredit1"] . "','" . $_REQUEST["crsCredit2"] . "','" . $_REQUEST["crsCredit1"] . "','" . $_REQUEST["crsCredit2"] . "','" . $_REQUEST["crsPeriod3"] . "','" . $crsUnit . "','Y','','" . $_REQUEST["crsCdId"] . "','1',now(),'reg-tools',now(),'reg-tools')";
$link->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 = "<button class='btn btn-primary btn-sm' data-toggle='modal' data-target='#editCourse' data-id='" . $data->crsId . "'>Edit</button>";
$opt .= " <button class='btn btn-danger btn-sm' data-toggle='modal' data-target='#modalDel' data-id='" . $data->crsId . "'>Del</button>";
$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!!";
}
?>
|