File manager - Edit - /var/www/ams.cmtc.ac.th/api_con.php
Back
<?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
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.62 |
proxy
|
phpinfo
|
Settings