File manager

File manager - Edit - /var/www/ams.cmtc.ac.th/api/GetRegisPayment/index.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']; $academicYear = $_REQUEST['academicYear']; $semester = $_REQUEST['semester']; } function get_alldata() { //GLOBAL $dbname; global $connect; global $data_to_get; if ($data_to_get == 'regis_payment'){ //$sqlQuery = " WHERE academicYear='$academicYear'and school_id = '".$_SESSION[school_id]."' "; //$sqlQuery = " WHERE academicYear='$academicYear' AND semester='$semester' "; //$sqlQuery = " WHERE confirm=1"; //$alldataQuery = "SELECT * FROM ".$data_to_get." ".$sqlQuery." "; $alldataQuery = "SELECT * FROM regis_payment_log 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); } } function get_data() { //GLOBAL $dbname; global $connect; global $data_to_get; if ($data_to_get == 'regis_payment'){ //$sqlQuery = " WHERE academicYear='$academicYear'and school_id = '".$_SESSION[school_id]."' "; $sqlQuery = " WHERE academicYear=$_REQUEST[academicYear] AND semester=$_REQUEST[semester] "; //$sqlQuery = " WHERE 1"; $alldataQuery = "SELECT * FROM regis_payment_log ".$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] =='regis_payment' && $_REQUEST[app_name] == 'rms' && $_REQUEST[academicYear] !='' && $_REQUEST[semester] !='' ){ //echo "xx $academicYear $semester $data_to_get"; get_data(); }elseif($_REQUEST[data] =='regis_payment' && $_REQUEST[app_name] == 'rms' && $_REQUEST[academicYear] =="" && $_REQUEST[semester] =="" ){ get_alldata(); }else{ $response["error"] = true; $response["error_msg"] = "invalid error"; echo json_encode($response); } //วิธีใช้ก็ url/api/GetRegisPayment/?data=regis_payment&app_name=rms&academicYear=2565&semester=2

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.43 | proxy | phpinfo | Settings