Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/reg-tools/api/   drwxr-xr-x
Free 52.4 GB of 127.8 GB (41%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     curriculumMapping.php (2.88 KB)      -rw-r--r--

<?php

include("../include/class.mysqldb.php");
include("../include/config.inc.php");

if($_REQUEST["action"] == "insertCm"){

    $sql = "INSERT INTO rg_ProgramCourses VALUES ('" . $_REQUEST["pcrCsCurId"] . "', '" . $_REQUEST["pcrCsCdId1"] . "', '" . $_REQUEST["pcrCsCdId2"] . "', '" . $_REQUEST["pcrCrsIdSelect"] . "', 'C', '" . $_REQUEST["pcrMinGrade"] . "', 'Y')";
    $link->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 = "<button class='btn btn-primary btn-sm' data-toggle='modal' data-target='#modalAddCm' data-id='" . $data->csCurId . "' data-id2='" . $data->csCdId1 . "' data-id3='" . $data->csCdId2 . "'>Add</button>";
        $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 = "<button class='btn btn-danger btn-sm' data-toggle='modal' data-target='#modalDelCm' data-id='" . $data->csCurId . "' data-id2='" . $data->csCdId1 . "' data-id3='" . $data->csCdId2 . "' data-id4='" . $rs->pcrCrsId . "'>Del</button>";
            $json["data"][] = array("csSeq"=>"","cdName1"=>"","cdName2"=>"&nbsp;&nbsp;".$rs->crsCode." ".$rs->crsName." (".$rs->crsCreditTotal.")","csCreditTotal"=>"", "opt"=>$opt);
        }

    }
    }
    else {
    $json["data"][] = array("csSeq"=>"ไม่พบข้อมูล","cdName1"=>"ไม่พบข้อมูล","cdName2"=>"ไม่พบข้อมูล","csCreditTotal"=>"ไม่พบข้อมูล", "opt"=>"ไม่พบข้อมูล");
    }


    echo json_encode($json);
}

?>