<?php
header('Content-Type: text/html; charset=utf-8');
header('Content-Type: application/json');
//include ('sys_connect.php');
require("inc/config.inc.php");
require("inc/common.php");
//mysql_query("SET NAMES utf8");
//วิธีใช้ก็ api_con.php?data=student&app_name=rms
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE);
if ($_REQUEST[school_id] != null){
	$_SESSION[school_id] = $_REQUEST['school_id'];
}else{
	$_SESSION[school_id] = '01';
}

if ($_REQUEST[data] != null){
$data_to_get = $_REQUEST['data'];
}

function get_alldata() {		
	//GLOBAL $dbname;
	global $connect;
	global $data_to_get;
		if ($data_to_get == 'regis_payment_log'){
		//$sqlQuery = " WHERE academicYear='$academicYear'and school_id = '".$_SESSION[school_id]."' ";	
		//$sqlQuery = " WHERE academicYear='$academicYear' AND semester='$semester' ";
		$sqlQuery = " WHERE 1";
		$alldataQuery = "SELECT *	FROM ".$data_to_get." ".$sqlQuery." ";	
		//$alldataQuery = "SELECT *	FROM $data_to_get  WHERE 1 ";	
		//$resultData = mysql_db_query($connect,$alldataQuery);	
		$resultData = mysqli_query($connect,$alldataQuery);	
		$alldataData = array();
		while( $alldataRecord = mysqli_fetch_array($resultData) ) {
			$alldataData[] = $alldataRecord;
		}
		
		echo json_encode($alldataData);	
			
		}
}

if ($_REQUEST[data] != null && ($_REQUEST[app_name] == 'rms')){
	//echo "xx $academicYear $semester $data_to_get";
	get_alldata();
}else{
	$response["error"] = true;
	$response["error_msg"] = "invalid error";
	echo json_encode($response);		
}

//วิธีใช้ก็ api_con.php?data=regis_payment_log&app_name=rms