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.37 GB of 127.8 GB (40.98%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     termConfig.php (2.96 KB)      -rw-r--r--

query($sql);
    
    echo "Insert Success!!";

}

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

    $sql = "DELETE FROM rg_TermConfig WHERE tmcAcY = '" . $_REQUEST["tmcAcY"] . "' AND tmcTmId = '" . $_REQUEST["tmcTmId"] . "'";
    $link->query($sql);
    
    echo "Data deleted.";
}

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

    $sql = "SELECT * FROM rg_TermConfig WHERE tmcAcY = '".$_REQUEST["tmcAcY"]."' AND tmcTmId = '".$_REQUEST["tmcTmId"]."'";
    $link->query($sql);
    
    echo json_encode($link->getnext());
}

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

    $sql = "SELECT * FROM rg_TermConfig rtmc
    LEFT JOIN rg_Term rtm ON rtm.tmId = rtmc.tmcTmId
    ORDER BY rtmc.tmcAcY Desc, rtmc.tmcTmId ASC";
    $link->query($sql);

    while($data = $link->getnext()){
    $opt = "Edit";    
    $opt .= " Del";
    $json["data"][] = array("tmcAcY"=>$data->tmcAcY,"tmName"=>$data->tmName,"tmcFrDate"=>thai_date_fullmonth(strtotime($data->tmcFrDate)),"tmcToDate"=>thai_date_fullmonth(strtotime($data->tmcToDate)), "opt"=>$opt);
    }

    echo json_encode($json);
    
}

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

    $sql = "UPDATE rg_TermConfig SET tmcFrDate='" . $_REQUEST["tmcFrDate"] . "', tmcToDate='" . $_REQUEST["tmcToDate"] . "' WHERE tmcAcY = '".$_REQUEST["tmcAcY"]."' AND tmcTmId = '".$_REQUEST["tmcTmId"]."'";
    $link->query($sql);
        
    echo "Update Success!!";
    
}

?>
bool(false)