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/sync-eis-college/api/   drwxr-xr-x
Free 52.3 GB of 127.8 GB (40.93%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     get-data.php (1.2 KB)      -rw-r--r--

<?php
	error_reporting(E_ALL);
    ini_set('display_errors', 1);
    ini_set('memory_limit','16M');
    require_once 'JSON.php';
	header('Content-Type: application/json; charset=utf-8');
	
	$table = $_GET["table"];
    $db = $_GET["db"];
    $limit = isset($_GET["limit"]) ?  'limit ' . $_GET["limit"] : ''; 
    $skip = isset($_GET["skip"]) ?  ' offset  '  . $_GET["skip"] : '' ;  

    $isCount = isset($_GET["count"]);

      if(!$isCount){
        $sql = "select * from  `$table` $limit  $skip";
      }else{
        $sql = "select count(*) as c from   `$table` ";
      }


	$host = "localhost";
	$username = "eis_sync";
	$password = "P@ssw0rd@2017";
    $objConnect = mysql_connect($host,$username,$password);

	$objDB = mysql_select_db($db);

    mysql_query("SET NAMES UTF8");
	$result = mysql_query($sql) or die (mysql_error());
   

    $post = array();
    while($row = mysql_fetch_assoc($result)){
        $post[] = $row;
    }
    mysql_free_result($result);

    $arr = array('isError' => false , 'data' => $isCount ? $post[0]["c"] : $post);
    //echo json_encode($arr);
    $json = new Services_JSON;
    echo  $json->encode($arr);


    mysql_close($objConnect);

?>