<?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);

?>